PostgreSQL MCP
JSON →Transforms PostgreSQL databases from "I have tables and I don't know what they do" into "I understand the entire database structure, relationships, and best practices"
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.
Environment variables
OLLAMA_BASE_URL
★ 1 GitHub stars