PostgreSQL-MCP-Server

Aftabbs/PostgreSQL-MCP-Server

3.1

If you are the rightful owner of PostgreSQL-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.

The PostgreSQL MCP Server provides a seamless interface for exploring and querying PostgreSQL databases using natural language through Claude.

Tools

Functions exposed to the LLM to take actions

query

Execute SQL queries.

list_schemas

List all database schemas.

list_tables

List tables in a specific schema.

describe_table

Get table structure.

get_foreign_keys

Get foreign key relationships.

find_relationships

Find explicit and implied relationships.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources