PostgreSQL MCP Server
JSON →A server for managing PostgreSQL databases, enabling comprehensive database operations.
Install
npx -y @smithery/cli Tools · 17
- Schema Management Manage tables, columns, ENUMs, and constraints
- User & Permissions Create users, grant/revoke permissions
- Query Performance EXPLAIN plans, slow queries, statistics
- Index Management Create, analyze, optimize indexes
- Functions Create, modify, manage stored functions
- Triggers Database trigger management
- Constraints Foreign keys, checks, unique constraints
- Row-Level Security RLS policies and management
- Execute Query SELECT operations with count/exists support
- Execute Mutation INSERT/UPDATE/DELETE/UPSERT operations
- Execute SQL Arbitrary SQL execution with transaction support
- Comments Management Comprehensive comment management for all database objects
- Database Analysis Performance and configuration analysis
- Debug Database Troubleshoot connection, performance, locks
- Data Export/Import JSON/CSV data migration
- Copy Between Databases Cross-database data transfer
- Real-time Monitoring Live database metrics and alerts
Links
★ 186 GitHub stars