kristofer84/mcp-postgres

3.2

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

The MCP PostgreSQL Server is a Model Context Protocol server that facilitates access and operations on PostgreSQL databases.

Tools

Functions exposed to the LLM to take actions

list_tables

Lists all tables in the database with their types.

get_schema

Gets database schema information including tables and columns.

execute_query

Executes a SQL query (SELECT statements only for safety).

describe_table

Get detailed information about a specific table including indexes and constraints.

get_table_sample

Gets a sample of rows from a table.

check_certificate_cache

Checks the status of the AWS RDS certificate cache.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client