Read-only Model Context Protocol server
2EZI Oracle
Provides schema discovery, relationship mapping, and guarded read-only SELECT access for Claude, Codex, and other MCP clients.
MCP endpoint
/api/mcp
API key
configured
Database
configured
Important Entities
| Table | Primary Key | Domain | LMS refs |
|---|---|---|---|
| Loans | LoanID | client, loan, payment, lender, config | 1356 |
| Clients | ClientID | client, loan, communications, compliance, marketing, transactions, config, security, reporting | 1204 |
| LoanPayments | PaymentID | loan, payment, communications, config | 876 |
| LoanStatuses | LoanStatusID | client, loan, config, reporting | 665 |
| LoanFees | FeeID | loan | 631 |
| ClientBanks | BankID | client, config | 416 |
| ClientStatuses | ClientStatusID | client, loan, marketing, config, reporting | 376 |
| Addresses | AddressID | client, communications, config | 335 |
| Configuration | ConfigurationID | config | 262 |
| ClientSources | ClientSourceID | client, communications, marketing, config | 223 |
| ClientNotes | NoteID | client, loan, communications, config, reporting | 175 |
| ClientSubscriptions | ClientSubscriptionID | client, marketing, config, security | 155 |
| SecurityPermissions | SecurityPermissionID | config, security | 147 |
| FieldHistory | FieldHistoryID | reporting | 102 |
| DebitProviders | DebitProviderID | loan, payment, communications, transactions, config, security | 100 |
| Subscriptions | SubscriptionID | client, loan, payment, communications, config, security | 98 |
| Lenders | LenderID | communications, lender, marketing, config | 87 |
| Transactions | TransactionID | client, marketing, transactions, config | 76 |