Blackklegend/postgres-mcp
3.3
If you are the rightful owner of postgres-mcp 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 Postgres database utilities over stdio, written in TypeScript.
Tools
Functions exposed to the LLM to take actions
listSchemas
List all schemas in the database.
listTables
List tables for a specified schema.
getTableDDL
Generate a basic CREATE TABLE DDL from information_schema.
getTableData
Return up to a specified limit of rows from a table.
executeSQL
Execute arbitrary SQL queries with an auto-appended LIMIT if missing.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client