postgresql-mcp-server and postgres-mcp
About postgresql-mcp-server
HenkDz/postgresql-mcp-server
A Powerful PostgreSQL MCP server with 14 consolidated database management tools for AI assistants.
Implements 17 consolidated tools using the Model Context Protocol (MCP) stdio transport, reducing the original 46 individual tools to 8 intelligent meta-tools while adding 4 new capabilities for complete CRUD operations, SQL execution, and schema management. Built on Node.js with connection pooling, parameterized queries for SQL injection prevention, and Docker support for production deployment. Designed for AI assistants like Claude and Cursor, handling everything from schema introspection and performance analysis to real-time monitoring and cross-database data migration.
About postgres-mcp
neverinfamous/postgres-mcp
PostgreSQL MCP Server: Secure Administration & Observability Featuring Code Mode—One Tool Replacing All Specialized 232 Tools for up to 90% Token Savings. Includes Connection Pooling, HTTP/SSE, OAuth 2.1, Deterministic Error Handling and Full Support for 8 Extensions (citext, HypoPG, ltree, pgcrypto, pg_cron, pg_stat_kcache, pgvector & PostGIS).
Implements a JavaScript sandbox (Code Mode) that executes multi-step database operations locally within a single tool invocation, enabling AI agents to chain 232 PostgreSQL capabilities without round-trip communication overhead. Provides 20 observability resources for real-time schema, performance, and connection metrics, plus 19 guided prompts for query optimization and extension management. Targets AI assistants and agents via MCP with dual HTTP/SSE transport, schema introspection, migration tracking with SHA-256 deduplication, and granular OAuth 2.1 scopes (`read`, `write`, `admin`, `db:*`, `table:*:*`).
Related comparisons
Scores updated daily from GitHub, PyPI, and npm data. How scores work