Mcpg
Connects Claude directly to PostgreSQL with over 100 tools spanning catalog introspection, query analysis, natural language SQL translation, and database operations. Runs read-only by default with AST validation on every SQL statement, then unlocks write access and DBA tools (EXPLAIN analysis, index tuning, vacuuming, pg_dump) through explicit environment flags. Built on psycopg3 with native support for pgvector, PostGIS, TimescaleDB, and Apache AGE. Includes connection pooling, read-replica routing, per-request role switching for multi-tenancy, and a Prometheus metrics endpoint. Ships as a pip package for stdio transport in Claude Desktop or as an HTTP server with OIDC auth for web integrations. Tested against Postgres 14 through 18 in CI.
- tools
- 32
- transport
- STDIO
- last updated
- Nov 3, 2026
Tools
32 toolsPublic tool metadata for what this MCP can expose to an agent.
list_tables
No parameter schema in public metadata yet.
summarize_table
No parameter schema in public metadata yet.
why_is_this_slow
No parameter schema in public metadata yet.
recommend_indexes
No parameter schema in public metadata yet.
validate_migration
No parameter schema in public metadata yet.
translate_nl_to_sql
No parameter schema in public metadata yet.
generate_schema_diagram
No parameter schema in public metadata yet.
audit_database
No parameter schema in public metadata yet.
run_write
No parameter schema in public metadata yet.
optimize_query
No parameter schema in public metadata yet.
run_ddl
No parameter schema in public metadata yet.
create_graph
No parameter schema in public metadata yet.
drop_graph
No parameter schema in public metadata yet.
dump_database
No parameter schema in public metadata yet.
restore_database
No parameter schema in public metadata yet.
run_pg_binary
No parameter schema in public metadata yet.
alter_system
No parameter schema in public metadata yet.
alter_system_reset_all
No parameter schema in public metadata yet.
reload_config
No parameter schema in public metadata yet.
subscribe_channel
No parameter schema in public metadata yet.
poll_notifications
No parameter schema in public metadata yet.
unsubscribe_channel
No parameter schema in public metadata yet.
list_notification_subscriptions
No parameter schema in public metadata yet.
drop_chunks
No parameter schema in public metadata yet.
compress_chunk
No parameter schema in public metadata yet.
decompress_chunk
No parameter schema in public metadata yet.
reorder_chunk
No parameter schema in public metadata yet.
merge_chunks
No parameter schema in public metadata yet.
refresh_continuous_aggregate
No parameter schema in public metadata yet.
run_job
No parameter schema in public metadata yet.
alter_job
No parameter schema in public metadata yet.
delete_job
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageReadme
MCPg
A production-grade Model Context Protocol server for PostgreSQL. It lets AI agents safely inspect, query, operate, and tune a Postgres database — 279 tools spanning catalog introspection, query intelligence, natural-language SQL, structural diffs, hybrid search, graph queries, data movement, live ops, and more.
Details
- Repository
- github.com/devopam/mcpg
- Website
- devopam.github.io/MCPg
- Category
- Databases
- Package
mcpg- Transport
- STDIO
- Registry
- MCP registry, active
Related Databases MCP servers
View all
DBeast PostgreSQL MCPsnss10/dbeastPostgreSQL MCP server for schema, query, health, security, and performance analysis.9stars
Terminal Mcpmkpvishnu/terminal-mcpMCP server for interactive terminal sessions — SSH, REPLs, database CLIs, TUI apps7stars
Mcp Graphql Enhancedletoribo/mcp-graphql-enhancedGraphQL gateway for LLMs. Handles huge GitHub GraphQL & @neo4j/graphql schemas without crashing6stars
Faostat Mcp Servercyanheads/faostat-mcp-serverUN FAOSTAT global food & agriculture statistics over a local SQLite mirror, via MCP.3stars
Acmi Mcpmadezmedia/acmiPersistent agent memory via ACMI — Profile/Signals/Timeline. 16 tools on Upstash Redis.3stars