AmunCore connects to SQL Server, MySQL, PostgreSQL, SQLite or Oracle and instantly exposes any table as a secure, authenticated REST API — in under 5 minutes, without writing a line of code. Now with Model Context Protocol (MCP) support for AI-native integrations.
The Model Context Protocol is an open standard that enables AI systems to securely connect to your data sources. With AmunCore's MCP integration, your database APIs become native tools that AI assistants can discover and use in real-time.
// claude_desktop_config.json { "mcpServers": { "amuncore": { "command": "npx", "args": [ "@amuncore/mcp-server", "--api-key", "uae_xxxx", "--endpoint", "https://api.amuncore.com" ], "env": { "AMUNCORE_APP_ID": "myapp" } } } } # Available tools after connection: • list_records # GET /api/v1/{app}/{table} • get_record # GET /api/v1/{app}/{table}/{id} • create_record # POST /api/v1/{app}/{table} • update_record # PUT /api/v1/{app}/{table}/{id} • delete_record # DELETE /api/v1/{app}/{table}/{id}
Pass your API key in the request header. Find it on the Application Details page in the dashboard.
X-Api-Key: uae_xxxxxxxxxxxxxxxxxxxxxxxx
# Or as query parameter
?api_key=uae_xxxx
| Parameter | Type | Description |
|---|---|---|
| appId | required | Application AppId slug |
| endpoint | required | Endpoint name as defined in the UI |
| page | query | Page number, 1-based |
| pageSize | query | Records per page (max 500, default 20) |
| orderBy | query | Column name to sort by |
| orderDir | query | ASC or DESC (default ASC) |
| {column}=value | query | Filter by any column: ?Status=active |
Returns a single object. The {id} maps to the configured Primary Key column (default: Id).
GET /api/v1/myapp/orders/142
X-Api-Key: uae_xxxx
→ { "success": true, "data": { "Id": 142, "Status": "pending", ... } }
POST /api/v1/myapp/orders
Content-Type: application/json
X-Api-Key: uae_xxxx
{ "Customer": "Acme Corp", "Amount": 1250.00, "Status": "pending" }
→ 201 { "success": true, "data": { "Id": 143, ... } }
PUT /api/v1/myapp/orders/142
Content-Type: application/json
X-Api-Key: uae_xxxx
{ "Status": "shipped", "TrackingNo": "TRK-001" }
→ 200 { "success": true, "data": { "Id": 142, "Status": "shipped", ... } }
Configure on the Endpoint. Injected into every WHERE and INSERT automatically. Essential for multi-tenant SaaS.
# Fixed value — always filter OrganizationId = 23 {"OrganizationId": "23"} # Dynamic — read ?tid= from query string {"TenantId": "@tid"} # Combined {"OrganizationId": "23", "TenantId": "@tid", "IsDeleted": "0"}
Enable MCP mode in Application Settings to expose your endpoints as Model Context Protocol tools.
# Step 1: Enable MCP in Dashboard Application → Settings → MCP → Enable # Step 2: Configure your MCP client { "mcpServers": { "amuncore-myapp": { "url": "https://api.amuncore.com/mcp/v1/myapp", "headers": { "X-Api-Key": "uae_xxxx" } } } } # Step 3: AI assistants can now: • Query records with natural language • Insert data through structured tool calls • Update status fields automatically • Respect all Cloud Filters and permissions
| Code | Meaning |
|---|---|
| 200 | Success — GET, PUT, DELETE |
| 201 | Created — POST |
| 400 | Bad request or database error |
| 401 | Missing or invalid API key |
| 403 | IP not in whitelist |
| 404 | Application or endpoint not found / inactive |
| 405 | Wrong HTTP method for this endpoint |
| 429 | Rate limit exceeded |
No boilerplate. No backend code. Register your application, define an endpoint, call your API. Now with MCP for AI-native workflows.