PostgreSQL MCP

Tools · 11

• analyze_database Comprehensive schema analysis without LLM. Returns full schema structure, junction tables, implicit relationships, join suggestions, PlantUML diagrams, and Markdown documentation.
• explain_database AI-powered database analysis using Ollama LLM. Provides business explanation, relationship detection, improved PlantUML ERD, and quality recommendations.
• get_table_details Detailed analysis of a specific table including structure, relationships, column information, constraints, and Markdown documentation.
• get_database_info Unified info retrieval tool. Supports info_type='tables' (list tables), 'ollama' (check LLM status), or 'summary' (quick database statistics).
• render_database_diagrams Generate visual database structure diagrams (ER, Class, Component) in SVG, PNG, or PDF format saved to the diagrams/ directory.
• crud_insert Smart insert supporting single (Dict) or batch (List[Dict]) operations with automatic mode detection and SQL injection prevention.
• crud_create_table Create a new table with specified columns, types, constraints, and optional primary key.
• crud_create_view Create a database view from a SELECT query with optional replacement if the view already exists.
• crud_create_index Create single or composite indexes on a table with optional UNIQUE constraint.
• crud_query Execute raw SQL SELECT queries with parameterized values (%s placeholders) and pagination support via limit/offset.
• crud_get Unified high-level read operation supporting mode='records' for filtered record retrieval with where clause and options.