adropofliquid/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 dayong@mcphub.com.
A Model Context Protocol (MCP) server providing read-only access to PostgreSQL databases, enabling AI clients to interact safely with database structures and data.
Tools
Functions exposed to the LLM to take actions
listTables
Lists all tables in the public schema.
executeSelectQuery
Executes SELECT queries safely, limited to 100 rows.
describeTable
Describes the structure of a specific table.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client