PostgreSQL MCP Server provides a comprehensive set of tools for PostgreSQL database management through the Model Context Protocol. It enables analyzing database configurations, debugging issues, managing schemas, migrating data, and monitoring performance metrics. The server implements connection pooling for efficient resource management, supports various PostgreSQL operations including table creation, data export/import, function management, and Row-Level Security policies. Built with TypeScript and Node.js, it offers platform-specific setup instructions and detailed documentation, making it valuable for developers who need to interact with PostgreSQL databases directly within AI assistant workflows without requiring separate database management tools.
暂无评论. 成为第一个评论的人！
登录以参与讨论
Perform SELECT operations with support for count and exists. Parameters: query (string), parameters (array of values), limit (optional integer)
Perform INSERT, UPDATE, DELETE, or UPSERT operations. Parameters: table (string), data (object), returning (optional string)
Execute arbitrary SQL commands with transaction support. Parameters: sql (string)
Manage comments for database objects. Parameters: objectType (string), objectName (string), comment (string)
Analyze database performance and configuration. Parameters: analysisType (string)
Troubleshoot connection issues, performance problems, and locks.
Migrate data between JSON and CSV formats.
Transfer data across different databases.
Monitor live database metrics and receive alerts.
Manage database schema including tables, columns, ENUMs, and constraints.
Create database users and manage their permissions.
Analyze query performance using EXPLAIN plans, identify slow queries, and view statistics.
Create, analyze, and optimize database indexes.
Create, modify, and manage stored functions in the database.
Manage database triggers.
Manage foreign keys, checks, and unique constraints in the database.
Manage Row-Level Security (RLS) policies.
