abiswas97/postgres-mcp-server
If you are the rightful owner of postgres-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
The Postgres MCP Server is a Model Context Protocol server that facilitates secure and efficient interaction with PostgreSQL databases using natural language through the Claude Desktop application.
Tools
Functions exposed to the LLM to take actions
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.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client