{"slug":"HenkDz/postgresql-mcp-server","name":"PostgreSQL MCP Server","description":"A server for managing PostgreSQL databases, enabling comprehensive database operations.","category":"database","tags":[],"official":false,"stars":186,"transport":"http","install":[{"cmd":"npx -y @smithery/cli","imports":[]}],"tools":[{"name":"Schema Management","description":"Manage tables, columns, ENUMs, and constraints"},{"name":"User & Permissions","description":"Create users, grant/revoke permissions"},{"name":"Query Performance","description":"EXPLAIN plans, slow queries, statistics"},{"name":"Index Management","description":"Create, analyze, optimize indexes"},{"name":"Functions","description":"Create, modify, manage stored functions"},{"name":"Triggers","description":"Database trigger management"},{"name":"Constraints","description":"Foreign keys, checks, unique constraints"},{"name":"Row-Level Security","description":"RLS policies and management"},{"name":"Execute Query","description":"SELECT operations with count/exists support"},{"name":"Execute Mutation","description":"INSERT/UPDATE/DELETE/UPSERT operations"},{"name":"Execute SQL","description":"Arbitrary SQL execution with transaction support"},{"name":"Comments Management","description":"Comprehensive comment management for all database objects"},{"name":"Database Analysis","description":"Performance and configuration analysis"},{"name":"Debug Database","description":"Troubleshoot connection, performance, locks"},{"name":"Data Export/Import","description":"JSON/CSV data migration"},{"name":"Copy Between Databases","description":"Cross-database data transfer"},{"name":"Real-time Monitoring","description":"Live database metrics and alerts"}],"env_vars":[],"auth_type":"none","github":"https://github.com/HenkDz/postgresql-mcp-server","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Thu May 28"}