Postgres MCP Server
JSON →Provides secure database access to PostgreSQL using the Kysely ORM.
Install
npx postgres-mcp-server Tools · 10
- query Execute SQL queries with pagination support
- describe_table Get table structure and column details
- list_tables List all tables in a schema
- list_schemas List all schemas in the database
- get_constraints Get table constraints (PK, FK, etc.)
- list_indexes List indexes for a table or schema
- list_views List views in a schema
- list_functions List functions and procedures
- explain_query Get query execution plan
- get_table_stats Get table size and statistics
Links
★ 1 GitHub stars