efeabio/mcp-postgresql-server
If you are the rightful owner of mcp-postgresql-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.
A Model Context Protocol (MCP) server that provides AI agents with secure and efficient access to PostgreSQL databases.
Tools
Functions exposed to the LLM to take actions
connect_database
Establish dynamic connection to PostgreSQL database.
execute_query
Execute SQL queries with timeout and row limits.
describe_table
Get detailed table information (columns, constraints, indexes).
list_tables
List all database objects (tables, views, functions).
analyze_schema_relationships
Analyze foreign key relationships and dependencies.
performance_stats
Database performance analysis (slow queries, index usage, table stats).
integrity_check
Data integrity validation (constraint violations, orphaned records).
data_distribution
Data quality analysis (null values, distinct counts, distributions).
schema_suggestions
Optimization recommendations (indexes, normalization, performance).
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client