postgres-mcp

freakynit/postgres-mcp

3.2

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 lightweight Model Context Protocol (MCP) server designed to interact with a Postgres database, offering tools for SQL query execution, schema introspection, and natural language querying.

Tools

Functions exposed to the LLM to take actions

execute_raw_query

Run arbitrary SQL and return rows.

list_tables

List all non-system tables.

describe_table

Get column names, types, and nullability for a table.

execute_english_query

Translate natural language to SQL and optionally execute.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources