abdou-ghonim/mcp-postgres

3.1

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 henry@mcphub.com.

A Model Context Protocol (MCP) server that provides AI assistants with secure access to PostgreSQL databases.

Tools

Functions exposed to the LLM to take actions

query

Execute SELECT queries on the database.

list_tables

List all tables in a database schema.

describe_table

Get detailed information about a table's columns and structure.

list_schemas

List all available database schemas.

test_connection

Test the database connection and get server information.

validate_query

Validate and analyze a SQL query for security issues, performance problems, and optimization opportunities.