
A comprehensive PostgreSQL client that exposes 27 tools across connection management, queries, schema introspection, CRUD operations, and server administration. You get parameterized queries with EXPLAIN ANALYZE, full schema exploration including indexes and constraints, and type-safe inserts with injection protection. It handles multi-database configs via YAML, supports HashiCorp Vault for credential management through AppRole authentication, and includes practical DBA tools like config reload and database sizing. Safety features like required confirmation flags on destructive operations make it suitable for production use. If you're doing database work through Claude and need more than basic queries, this covers the operational surface area you'd expect from a proper PostgreSQL client.
Public tool metadata for what this MCP can expose to an agent.
execute_custom_queryExecute a custom SQL query against the database. WARNING: Use with care. Do not expose to untrusted input.4 paramsExecute a custom SQL query against the database. WARNING: Use with care. Do not expose to untrusted input.
connectionStringstringquerystringtimeoutnumbervaluesarrayPOSTGRES_CONNECTION_STRINGPostgreSQL connection string (e.g. postgresql://user:pass@host:5432/db)