{"slug":"github-com-prasanna00019-mcp-toolhub-tree-main-postgresql-mcp","name":"PostgreSQL MCP","description":"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\"","category":"database","tags":[],"official":false,"stars":1,"transport":null,"install":null,"tools":[{"name":"analyze_database","description":"Comprehensive schema analysis without LLM. Returns full schema structure, junction tables, implicit relationships, join suggestions, PlantUML diagrams, and Markdown documentation."},{"name":"explain_database","description":"AI-powered database analysis using Ollama LLM. Provides business explanation, relationship detection, improved PlantUML ERD, and quality recommendations."},{"name":"get_table_details","description":"Detailed analysis of a specific table including structure, relationships, column information, constraints, and Markdown documentation."},{"name":"get_database_info","description":"Unified info retrieval tool. Supports info_type='tables' (list tables), 'ollama' (check LLM status), or 'summary' (quick database statistics)."},{"name":"render_database_diagrams","description":"Generate visual database structure diagrams (ER, Class, Component) in SVG, PNG, or PDF format saved to the diagrams/ directory."},{"name":"crud_insert","description":"Smart insert supporting single (Dict) or batch (List[Dict]) operations with automatic mode detection and SQL injection prevention."},{"name":"crud_create_table","description":"Create a new table with specified columns, types, constraints, and optional primary key."},{"name":"crud_create_view","description":"Create a database view from a SELECT query with optional replacement if the view already exists."},{"name":"crud_create_index","description":"Create single or composite indexes on a table with optional UNIQUE constraint."},{"name":"crud_query","description":"Execute raw SQL SELECT queries with parameterized values (%s placeholders) and pagination support via limit/offset."},{"name":"crud_get","description":"Unified high-level read operation supporting mode='records' for filtered record retrieval with where clause and options."}],"env_vars":["OLLAMA_BASE_URL"],"auth_type":"none","github":"https://github.com/prasanna00019/MCP-ToolHub/tree/main/PostgreSQL-MCP","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Mon May 25"}