Postgres MCP Server
The reference implementation for relational databases. Best-tested. Handles connection pooling, schema introspection, safe read-only mode, and query complexity limits out of the box.
Every MCP server in our directory that connects an AI assistant to a database — relational (Postgres, MySQL, SQL Server), embedded (SQLite, DuckDB), NoSQL (MongoDB, Cassandra), key-value (Redis, DynamoDB), warehouses (Snowflake, BigQuery), and search (Elasticsearch). Each server has been installed, tested against a real database, and documented with auth setup notes for Claude Desktop, Claude Code, Cursor, and Cline.
Database MCP servers expose a database to an AI assistant through the Model Context Protocol. They translate the assistant's natural-language requests into safe database operations (schema introspection, SELECT queries, sometimes writes) and return the results back to the assistant. The AI never talks to the database directly; the MCP server is the middleware that enforces auth, connection pooling, query limits, and safety guards.
The value the MCP layer adds is safe abstraction. Plain LLM output that connects to a database can hallucinate tables, run unbounded queries, or execute writes when only reads were intended. A well-designed database MCP server enforces boundaries — read-only by default, explicit schemas, connection limits, statement timeouts, query complexity caps. For real databases with real data, this discipline is essential.
What lives here vs. elsewhere: if the server's primary job is talking to a database engine, it belongs here. If it's about analytics on top of a database (BI tools, dashboards), see Data & Analytics. If it's about file-based data (CSVs, Parquet in a bucket), see Files & Storage. Servers with dual-purpose (Snowflake is both warehouse and analytics platform) appear in both hubs.
Our editorial picks — heaviest tested, highest reader ratings.
The reference implementation for relational databases. Best-tested. Handles connection pooling, schema introspection, safe read-only mode, and query complexity limits out of the box.
MySQL / MariaDB / Aurora MySQL counterpart. Same tool surface as Postgres MCP. Handles connection pooling, prepared statements, and read-replica routing.
Local file-based database. Great for prototyping data models before productionizing, working with SQLite-based apps (browsers, mobile apps), or as a lightweight cache for AI workflows.
Filter by sub-type, search by name, sort by recency or alphabetical.
PostgreSQL 12–17. Connection pooling, schema introspection, read-only mode, statement timeouts.
MySQL 8+, MariaDB, Aurora MySQL. Prepared statements, read-replica routing, character-set aware.
File-based database. Perfect for prototyping, mobile-app inspection, and lightweight AI workflow caches.
Microsoft SQL Server 2019+, Azure SQL. T-SQL dialect, Windows auth support, always-encrypted aware.
MongoDB 6+, Atlas. Aggregation pipeline support, index inspection, safe read-only mode by default.
Apache Cassandra 4+, DataStax. CQL query support, partition-aware queries, replication-factor aware.
AWS DynamoDB. IAM auth, GSI-aware queries, cost-estimate before running expensive scans.
Snowflake. Warehouse selection, credit estimation, VPS-safe read-only mode. Cross-database queries.
Google BigQuery. Cost-estimate before queries, dry-run mode, INFORMATION_SCHEMA introspection.
Redis 7+. Key patterns, TTL inspection, Cluster-aware, pub/sub-safe operations only by default.
Memcached inspection and management. Key browsing, TTL inspection, hit-rate stats.
Elasticsearch 8+, OpenSearch. Index inspection, DSL queries, aggregation pipeline support.
AI Skills our team pairs with Database MCP servers for full workflows.
The primary Skill for SQL work. Pairs with any of the SQL MCP servers above.
Explain queries and analyze plans. Works especially well with Postgres MCP's EXPLAIN support.
Generate migration files (Alembic, Prisma, ActiveRecord) with the live schema as context.
Auto-generate ER diagrams from an introspected schema via one of the SQL MCPs.
Convert Pandas operations to SQL pushed down to the database.
Ingest CSV files into any of the database MCPs above with schema validation.
Longer-form tutorials for the concepts behind these servers.
The specific IAM/user/role setup we recommend for connecting AI to production databases without risk.
Deep dive on the setup that scales to production usage patterns.
Decision guide for picking the right MCP based on your database engine, scale, and workflow.
Head-to-head reviews that touch on Database workflows.
MCP-based database access vs in-tool AI features in database admin tools.
Warehouse-to-MCP comparison for cost, features, and AI workflow support.
Which AI provider is best at generating SQL against the same database MCP?
Our sister sites cover errors, workarounds, and diagnostic recipes across the AI ecosystem. Bookmark them for the inevitable moment something breaks.
Weekly roundup of new MCP servers we've tested, install notes, and workflow patterns. Join 2,400+ readers of "The Skill Report" every Tuesday.