MagiciannnY/postgresql-mcp-server
If you are the rightful owner of postgresql-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
The PostgreSQL MCP Server is a Model Context Protocol server designed to enhance PostgreSQL database management for AI assistants.
Tools
Functions exposed to the LLM to take actions
Schema Management
Manage tables, columns, ENUMs, and constraints.
User & Permissions
Create users and manage permissions.
Query Performance
Analyze query performance and statistics.
Index Management
Create and optimize indexes.
Functions
Manage stored functions.
Triggers
Manage database triggers.
Constraints
Manage foreign keys and unique constraints.
Row-Level Security
Manage RLS policies.
Execute Query
Perform SELECT operations with support for count/exists.
Execute Mutation
Perform INSERT/UPDATE/DELETE/UPSERT operations.
Execute SQL
Execute arbitrary SQL with transaction support.
Comments Management
Manage comments for database objects.
Database Analysis
Analyze performance and configuration.
Debug Database
Troubleshoot connection and performance issues.
Data Export/Import
Migrate data in JSON/CSV format.
Copy Between Databases
Transfer data between databases.
Real-time Monitoring
Monitor live database metrics and alerts.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client