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
// Reading this84,955 stars belong to the modelcontextprotocol/servers monorepo (10 commits/30d). The Postgres server is one subdirectory; per-server activity is not separately reported. Audit (2026-05-03) confirmed the URL is correct; star count reflects monorepo aggregate.
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.
MCP Toolbox for Databases
Google's open-source MCP server for databases. One MCP binary speaks PostgreSQL, MySQL, BigQuery, Spanner, AlloyDB, Cloud SQL, and SQLite. 14,937 GitHub stars and 100 commits on main in the last 30 days. Highest commit cadence in the directory.
ClickHouse MCP
Official ClickHouse MCP server with both ClickHouse Tools (production cluster queries) and chDB Tools (embedded ClickHouse for local analytics). Apache-2.0 with destructive-operation protection: write access is opt-in via configuration.
Redis MCP
Official Redis MCP server with natural-language interface for managing and searching Redis data. EntraID authentication for Azure Managed Redis included; Redis ACL configurable via environment variables. Tool coverage spans strings, lists, hashes, sets, sorted sets, JSON, vectors, and search.
Elasticsearch MCP
Elasticsearch and OpenSearch MCP server with index management, document CRUD, search queries, cluster health, and aggregations. 270 stars and 22 commits on main in the last 30 days.
MindsDB
MindsDB ships native MCP server support as part of the main project (mindsdb/mindsdb, 39,093 stars). Federated query layer over 200+ data sources with built-in MCP endpoint for AI agent access to enterprise data.
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.