pg-mcp-server

weaker2003/pg-mcp-server

3.2

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

This project implements a Server-Sent Events (SSE) service using FastMCP and PostgreSQL.

Tools

Functions exposed to the LLM to take actions

pg_execute_query

Execute SQL queries

pg_get_table_schema

Retrieve table structure

pg_get_table_row_count

Count the number of rows in a table

pg_list_tables

List all user tables

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources