Postgres-Connector-MCP

martymarkenson/Postgres-Connector-MCP

3.4

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

An MCP (Model Context Protocol) server designed for interacting with PostgreSQL databases, enabling secure SQL query execution and database management through MCP-compatible clients.

Tools

Functions exposed to the LLM to take actions

test-postgres-connection

Tests your database connection and displays the current configuration.

get-all-tables

Retrieves a list of all tables in the public schema of your database.

execute-sql-query

Executes SELECT queries on your database with security validation.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources