Postgres MCP
Official MCP server for PostgreSQL. Provides read and write access to PostgreSQL databases with schema introspection, query execution, and transaction support. The reference implementation for database MCP servers.
“The gold standard for Postgres MCP servers. Explicit transactions, EXPLAIN output, and read-only mode make this the production-safe choice.”
INSTALL THIS SERVER
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-postgres"
],
"env": {
"DATABASE_URL": "postgres://user:pw@host:5432/db",
"READ_ONLY": "false"
}
}
}
}
14 TOOLS AVAILABLE
OUR ASSESSMENT
- Explicit transaction tools (BEGIN/COMMIT) as first-class operations
- EXPLAIN plan output returns as structured JSON
- Read-only mode via CLI flag, no config surgery needed
- Fastest cold start in the category at 180ms
- 14 tools covering schema introspection, queries, and admin operations
- Connection-string-only auth, no OAuth flow
- No built-in branching for reversible migrations
- Zero BaaS features — this is a database client only
Supports read-only mode via --read-only flag. Credentials passed as DATABASE_URL environment variable or .pgpass file.
Production Postgres clusters where DBA-governed schemas demand explicit transactions and EXPLAIN plans.
TECHNICAL DETAILS
ADOPTION METRICS
OTHER DATABASE MCP SERVERS
Supabase
Persistence layer with full Postgres access and Row Level Security awareness. Query tables, manage schemas, handle auth users, and work with storage buckets.
MindsDB
A federated query engine that exposes 200+ data sources as MCP tools through a unified SQL-compatible interface. Built around a Connect → Unify → Respond workflow with structured tables fused with vectorized data inside Knowledge Bases.
Neon MCP
MCP server for Neon serverless Postgres. Provides database branching, query execution, and project management. Branch-per-query makes every schema change reversible.
MongoDB MCP Server
Vendor-built MongoDB MCP server covering both direct database operations (against any MongoDB connection string) and MongoDB Atlas API operations (via Service Accounts credentials). Ships with --readOnly enabled by default in every official install snippet.
Neo4j MCP (Labs)
Four Neo4j MCP servers maintained by the Neo4j Field GenAI team as part of Neo4j Labs: cypher (natural-language-to-Cypher with schema introspection), memory (knowledge-graph memory across agent sessions), cloud-aura-api (Aura cloud instance management), and data-modeling (graph data modelling and visualization). Each is a separate installable PyPI package.
DISCUSS YOUR
MCP REQUIREMENTS.
Evaluating a server, scoping an internal deployment, or working out whether MCP is the right fit at all. Start the conversation and we will point you at the right piece of the ecosystem.