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 SELECTED TOOLS
OUR ASSESSMENT
The official Postgres MCP server sets the bar for database tooling. Explicit transaction support, structured EXPLAIN output, and a CLI read-only flag make it the safest choice for production clusters.
- 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
RECORDED ADOPTION METRICS
Saved directory snapshots. Record last checked MAY 3, 2026. The review date above does not refresh these figures.
// Recorded note84,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.
SOURCES & RECORDED CHECKS
These are the directory listings and check details held in this record. Client compatibility, directory listings and installation testing are separate signals. Recorded client names describe the scope of a check; they do not establish a security assessment or a recurring test schedule.
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.
DBHub
Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, and SQLite. Maintained by Bytebase. 2,717 GitHub stars and 3 commits on main in the last 30 days.
Timescale Postgres AI Guide
Timescale official MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding agents write better Postgres queries. 1,718 GitHub stars and 2 commits on main in the last 30 days.
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.
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.