pg-mcp

melihbirim/pg-mcp

3.1

If you are the rightful owner of pg-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 dayong@mcphub.com.

A Model Context Protocol (MCP) server that enables AI assistants to interact with PostgreSQL databases using natural language queries.

Tools

Functions exposed to the LLM to take actions

connect_database

Connect to a PostgreSQL database

disconnect_database

Disconnect from the current database

list_tables

List all tables in the current database

describe_table

Get detailed information about a table's structure

get_schema

Get an overview of the database schema and relationships

execute_query

Execute read-only SQL queries with safety checks

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources