Postgres MCP
未认领The only postgress MCP server I have been able to connect to my docker postgres
安装
npx @javiagui/postgresql-mcp工具（15 个）
describe_table
Get table structure (columns, types, constraints)
describe_view
Get view definition and columns
execute
Execute write operations (INSERT/UPDATE/DELETE) when enabled
explain_query
Get EXPLAIN plan for query optimization
get_database_info
Get database version and connection info
list_constraints
List constraints (PK, FK, UNIQUE, CHECK)
list_databases
List the configured connections by alias, with host, database, write permission and which is the default. Never returns credentials.
list_functions
List functions and procedures
list_indexes
List indexes for a table
list_schemas
List all schemas in the database
list_tables
List tables in a specific schema
list_views
List views in a schema
query
Execute read-only SQL queries against the database
search_columns
Search for columns by name across all tables
table_stats
Get table statistics (row count, size, bloat)