blankbrackets/postgres-mcp
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 dayong@mcphub.com.
The Postgres MCP Server is a TypeScript-based server that provides AI assistants with read-only access to PostgreSQL databases for comprehensive analysis and optimization recommendations.
Tools
Functions exposed to the LLM to take actions
comprehensive_database_analysis
Scans the entire database for issues and creates a complete action plan.
get_database_health
Provides database-wide metrics and health assessment.
list_tables
Lists all tables with schemas, types, row counts, and sizes.
analyze_query_performance
Identifies slowest queries using pg_stat_statements or analyzes specific queries with EXPLAIN.
suggest_indexing_strategies
Analyzes indexing for a specific table.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client