Databases APIs and MCP servers for AI agents
Managed SQL, NoSQL, key-value and analytics databases an agent can create, query and manage.
12 databases APIs an AI agent can call: auth method and header, official MCP server (12), free tier (9), docs links. Machine-readable JSON included. Agents: fetch catalog/databases.json instead of parsing this page. Last checked 2026-09-24.
Ratings and usage (★) fetched: .
| Service | What an agent can do | Auth | MCP server | Free tier | Details (with sources) | Notes | Proof (ratings, usage) |
|---|---|---|---|---|---|---|---|
| ClickHouse Cloud | Run SQL analytics queries and manage Cloud services/backups via REST API or official MCP server. | API keyBasic auth with Cloud API key id/secret | official | no permanent free tier; 30-day trial with $300 credits | Base URL: https://api.clickhouse.cloud/v1 Free plan: $300 in credits over 30 days, one-time, no card ↗ Rate limits: Cloud API: 10 requests per 10-second window per API key; up to 100 keys per organization ↗ Example call: run a SQL query over the HTTPS interface: POST https://{service_host}:8443/ ↗ MCP tools: 10: get_organizations, list_databases, list_tables, run_select_query, get_services_list, get_service_details … ↗ | Cloud-hosted remote MCP adds service management, billing, and ClickPipe visibility. | GitHub 879★ ClickHouse/mcp-clickhouse |
| Convex | Introspect tables/functions, call functions, and read/write data in a reactive database via MCP or client SDKs. | API keydeploy key / admin key | official | generous free tier for small apps, zero cost/maintenance | Base URL: https://<deployment>.convex.cloud/api Free plan: 1M function calls, 0.5 GB database storage, 1 GB data egress, 1 GB file storage, per month ↗ Example call: call a query function over HTTP: POST https://{deployment}.convex.cloud/api/query ↗ Unit price: Function calls: Free plan 1M/month included, then $2.20 per extra 1M; Pro 25M included, then $2 per extra 1M ↗ MCP tools: 12: status, tables, data, runOneoffQuery, functionSpec, run … ↗ | Vector search available even on the free tier. | GitHub 12.6k★ get-convex/convex-backend |
| Google BigQuery | Run SQL queries and inspect datasets/tables in BigQuery via REST API or the fully-managed remote MCP server. | cloud IAMOAuth2/IAM (Google Cloud service account or user credentials) | official | Free tier: 1 TiB of querying and 10 GiB of storage per month | Base URL: https://bigquery.googleapis.com Free plan: 1 TiB of querying and 10 GiB of storage, per month, card required ↗ Rate limits: 100 API requests per second per user per method; tabledata.list 1,000 req/s per project; on-demand query usage 200 TiB/day per project ↗ OAuth scopes: https://www.googleapis.com/auth/bigquery ↗ Example call: run a SQL query: POST https://bigquery.googleapis.com/bigquery/v2/projects/{projectId}/queries ↗ Unit price: On-demand queries: $6.25 per TiB scanned (first 1 TiB/month free) ↗ MCP tools: 7: list_dataset_ids, get_dataset_info, list_table_ids, get_table_info, execute_sql, execute_sql_readonly … ↗ | Remote MCP server is hosted by Google, no local install needed. | Smithery 6,986 uses |
| MongoDB Atlas | Create/manage Atlas clusters and query MongoDB data via Admin API, drivers, or official MCP server. | API key / OAuthOAuth2 service account (client credentials) -> Authorization: Bearer <access token, 1h>; legacy: HTTP Digest with Atlas public/private API key | official | free tier: M0 cluster free forever (512MB) | Base URL: https://cloud.mongodb.com/api/atlas/v2 Free plan: M0 Free cluster: 512 MB storage, shared RAM/vCPU, up to 100 ops/sec; free forever ↗ Example call: list clusters in a project: GET https://cloud.mongodb.com/api/atlas/v2/groups/{groupId}/clusters ↗ Unit price: Flex cluster from $0.011/hour (capped at $8/month); dedicated M10 from $0.08/hour; M0 free ↗ MCP tools: 23: find, aggregate, count, insert-many, update-many, delete-many … ↗ | MongoDB also runs the Atlas Managed MCP Server (GA Aug 2026, OAuth, recommended), reached via AI-client plugins or the mongodb-atlas-mcp-remote npm package; no public endpoint URL is documented. | GitHub 1,137★ mongodb-js/mongodb-mcp-server SourceForge 5.0★/1 review |
| Neon Postgres | Provision and manage serverless Postgres projects/branches and run SQL via REST API or MCP server. | API key / OAuthAuthorization: Bearer <api_key> | official | Free tier: 100 projects; 0.5 GB storage, 100 CU-hours and 5 GB egress per project per month, no card required | Base URL: https://console.neon.tech/api/v2 Free plan: 100 projects; 0.5 GB storage, 100 CU-hours and 5 GB egress per project per month, no card ↗ Async jobs: long-running tasks return operation IDs; poll GET /projects/{project_id}/operations/{operation_id} ↗ Example call: create a Postgres project: POST https://console.neon.tech/api/v2/projects ↗ MCP tools: 33: list_projects, describe_project, create_project, delete_project, list_organizations, list_branches … ↗ | OAuth recommended for local IDEs, static API key for headless agents. | GitHub 650★ neondatabase/mcp-server-neon |
| PlanetScale | Manage MySQL databases, branches, and schema, and view Insights via hosted MCP server or API. | API key / OAuthService token or OAuth (for MCP) | official | Paid only: no free or Hobby plan; cheapest is Postgres PS-5 single node at $5/month | Base URL: https://api.planetscale.com/v1 Free plan: none ↗ Rate limits: 600 requests per minute (subject to change) ↗ | MCP server launched Jan 2026; configurable read-only vs full-access permissions. | Smithery 2 uses |
| Snowflake | Run SQL, Cortex Analyst, and Cortex Search over warehoused data via REST API or managed MCP server. | API key / OAuthKey-pair auth, OAuth, or PAT; cloud_iam variants for Snowpark | official | trial credits (no permanent free tier); check pricing | Base URL: https://<account_identifier>.snowflakecomputing.com/api/v2 Free plan: 30-day trial with a free usage balance (ends at 30 days or when balance is used up); AI features disabled until a card is added, one-time, no card ↗ Example call: execute a SQL statement: POST https://{account_identifier}.snowflakecomputing.com/api/v2/statements ↗ | Snowflake-managed MCP server reached GA Nov 2025; hosted per account at https://<account_url>/api/v2/databases/{db}/schemas/{schema}/mcp-servers/{name}. Snowflake-Labs/mcp is a separate self-hosted server. | GitHub 299★ Snowflake-Labs/mcp SourceForge 4.8★/4 reviews |
| Supabase | Manage Postgres tables, auth, storage, and edge functions via REST/GraphQL APIs or client SDKs. | API key / OAuthapikey: <publishable or secret key> (not Authorization: Bearer; new keys are not JWTs); Management API: Authorization: Bearer <PAT or OAuth token> | official | free tier: 2 projects, 500MB DB, 5GB bandwidth | Base URL: https://api.supabase.com/v1 Free plan: 2 active projects, 500 MB database, 5 GB egress, 1 GB file storage, 50,000 MAU; paused after 1 week of inactivity, per month ↗ Rate limits: Management API: 120 requests/min per user per scope; some analytics and database endpoints 30 or 10/min; Free plan data API requests unlimited ↗ Example call: query rows from a table via the Data REST API: GET https://{project_ref}.supabase.co/rest/v1/{table}?select=* ↗ MCP tools: 30: list_organizations, get_organization, list_projects, get_project, create_project, pause_project … ↗ | Official MCP server can also create/manage whole projects, not just query data. | Smithery 189 uses |
| TiDB Cloud API (Starter) | Lets an agent create and manage serverless MySQL-compatible TiDB clusters and run SQL, full-text and vector search queries against them. | API keyHTTP Digest auth with API public key as username and private key as password (Management API); SQL via MySQL connection string or serverless HTTP driver with cluster user/password | official | Free: up to 5 Starter instances per org, 25 GiB row storage + 25 GiB columnar storage + 250M Request Units per month in total; no credit card | Free plan: 25 GiB row storage, 25 GiB column storage and 250M Request Units per organization, per month, no card ↗ Example call: list Starter clusters: GET https://serverless.tidbapi.com/v1beta1/clusters ↗ Unit price: Starter: $0.10 per 1M Request Units in US regions ($0.12 APAC/Europe); row storage $0.20/GiB-month ↗ MCP tools: 7: show_databases, switch_database, show_tables, db_query, db_execute, db_create_user … ↗ | Cloud API is in public preview (v1beta1 for Starter/Essential/Dedicated). Official MCP server is local (uvx --from pytidb[mcp] tidb-mcp-server, stdio or SSE) and needs the cluster connection credentials. A 6th instance requires a card and spending limit. | — |
| Tinybird API | Lets an agent ingest events into real-time ClickHouse-based data sources, run SQL queries and call published analytics API endpoints. | API keyAuthorization: Bearer <TINYBIRD_TOKEN> (workspace admin, resource-scoped token or JWT) | official | Free plan: 10 GB storage, 1,000 API requests/day, 0.25 vCPU shared; no credit card | Base URL: https://api.tinybird.co Free plan: 10 GB storage, 1,000 API requests per day, 0.25 vCPU, no card ↗ Rate limits: Limits depend on plan (Free: 1,000 API requests/day); 429 Too many requests when exceeded ↗ Example call: run a SQL query: POST https://{api_host}/v0/sql ↗ MCP tools: 6: call_endpoint, execute_query, text_to_sql, list_endpoints, list_datasources, list_service_datasources ↗ | Remote MCP over Streamable HTTP, token passed as query parameter (add &host=... for non-default regions); use mcp-remote for older clients. API host depends on workspace region. | — |
| Turso | Create and query edge SQLite (libSQL) databases programmatically via HTTP/SDK client libraries. | API keyAuthorization: Bearer <token> | official | Free tier: 100 databases, 5 GB storage, 500M rows read and 10M rows written per month, no card required | Base URL: https://api.turso.tech/v1 Free plan: 100 databases, 5 GB storage, 500M rows read and 10M rows written per month, no card ↗ Example call: create a database: POST https://api.turso.tech/v1/organizations/{organizationSlug}/databases ↗ | Official hosted MCP server (OAuth 2.1) manages databases and groups and runs SQL; repo github.com/tursodatabase/turso-mcp. | — |
| Upstash (Redis, Vector) | Call serverless Redis, Vector, and QStash over HTTP REST API from edge/serverless runtimes. | API keyAuthorization: Bearer <token> | official | Free tier: Redis 256MB/500K cmds per month; Vector 10K queries+updates per day (max 200M vectors x dimensions, 1,536 dims) | Free plan: Redis: 256 MB data, 500K commands/month; Vector: 1 free index, 10K queries+updates/day, no card ↗ Example call: set a Redis key over REST: GET {UPSTASH_REDIS_REST_URL}/set/{key}/{value} ↗ Unit price: Redis pay-as-you-go: $0.20 per 100K commands ↗ | Remote MCP endpoint supports OAuth or API key. | — |
Other categories
- Web search
- Web scraping and browser automation
- Knowledge and research data
- Image generation and editing
- Video generation and editing
- Speech and audio
- Music generation
- 3D generation and assets
- Architecture, CAD and BIM
- Diagrams and software architecture
- Design and UI
- Documents, OCR and presentations
- Translation and language
- Code execution sandboxes
- Developer platforms and DevOps
- Cloud and hosting
- Vector search, memory and RAG
- Email, team chat and notifications
- SMS and messaging apps
- Voice agents and telephony
- Productivity and workspace
- CRM, support and marketing
- Social media
- Maps, geolocation and weather
- Finance, payments and market data
- E-commerce
- Automation and integration platforms
- Model APIs and inference