Connection check
local install
postgres-mcp
PostgreSQL MCP wrapper with .env credential mapping, tool selection, and safe read-only defaults.
Tools
16
GitHub stars
5
Installs / wk
—
Licence
—
Transport
stdio
Last checked
never
Tools & capabilities
16 toolsRead from the published package source — this server runs locally, so there is no endpoint to query. Names are taken from the code, not observed at runtime, and descriptions are often absent.
pg_analyze_database
from source
Analyze PostgreSQL database performance and configuration. Analyze PostgreSQL database performance and configuration.
pg_debug_database
from source
Diagnose common PostgreSQL issues - connections, locks, performance, replication. Diagnose common PostgreSQL issues - connections, locks, performance, replication.
pg_execute_mutation
from source
Execute data modification operations - INSERT, UPDATE, DELETE, or UPSERT. NOT enabled by default; must be opted-in via tool= arg. Execute data modification operations - INSERT, UPDATE, DELETE, or UPSERT. NOT enabled by default; must be opted-in via tool= arg.
pg_execute_query
from source
Execute SELECT queries and data retrieval operations - operation= Execute SELECT queries and data retrieval operations - operation=
pg_execute_sql
from source
Execute arbitrary SQL statements with optional transaction support. NOT enabled by default; must be opted-in via tool= arg. Execute arbitrary SQL statements with optional transaction support. NOT enabled by default; must be opted-in via tool= arg.
pg_get_setup_instructions
from source
Get platform-specific PostgreSQL setup and connection instructions. Get platform-specific PostgreSQL setup and connection instructions.
pg_inspect_schema
from source
Inspect PostgreSQL schema - list tables and columns, view ENUM types. Read-only. Inspect PostgreSQL schema - list tables and columns, view ENUM types. Read-only.
pg_manage_constraints
from source
Manage PostgreSQL constraints - get, create foreign keys, drop constraints. Manage PostgreSQL constraints - get, create foreign keys, drop constraints.
pg_manage_functions
from source
Manage PostgreSQL functions - get, create, or drop functions. Manage PostgreSQL functions - get, create, or drop functions.
pg_manage_indexes
from source
Manage PostgreSQL indexes - get, create, drop, reindex, and analyze usage. Manage PostgreSQL indexes - get, create, drop, reindex, and analyze usage.
pg_manage_query
from source
Manage PostgreSQL query analysis and performance - EXPLAIN plans, slow queries, statistics. Manage PostgreSQL query analysis and performance - EXPLAIN plans, slow queries, statistics.
pg_manage_rls
from source
Manage PostgreSQL Row-Level Security - enable/disable RLS and manage policies. Manage PostgreSQL Row-Level Security - enable/disable RLS and manage policies.
pg_manage_schema
from source
Manage PostgreSQL schema - get schema info, create/alter tables, manage enums. Manage PostgreSQL schema - get schema info, create/alter tables, manage enums.
pg_manage_triggers
from source
Manage PostgreSQL triggers - get, create, drop, enable/disable. Manage PostgreSQL triggers - get, create, drop, enable/disable.
pg_manage_users
from source
Manage PostgreSQL users and permissions - get permissions, create/drop/alter users, grant/revoke. Manage PostgreSQL users and permissions - get permissions, create/drop/alter users, grant/revoke.
pg_monitor_database
from source