igorviniciusavanci/postgres-mcp-server
3.2
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 henry@mcphub.com.
A Model Context Protocol (MCP) server that provides tools for connecting to and querying PostgreSQL databases.
Tools
Functions exposed to the LLM to take actions
connect_db
Connect to a PostgreSQL database with specified credentials.
list_schemas
List all schemas in the connected database, excluding system schemas.
list_tables
List all tables in a specified schema.
describe_table
Get detailed information about a table's structure.
query
Execute a SELECT query on the database with parameter support.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client