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 count/exists support.
Perform INSERT/UPDATE/DELETE/UPSERT operations.
Execute arbitrary SQL with transaction support.
Manage comments for all database objects.
Analyze performance and configuration of the database.
Troubleshoot database connection, performance, and locks.
Migrate data in JSON/CSV format.
Transfer data across different databases.
Monitor live database metrics and receive alerts.
Manage tables, columns, ENUMs, and constraints.
Create users and manage permissions.
Analyze EXPLAIN plans, slow queries, and statistics.
Create, analyze, and optimize database indexes.
Create, modify, and manage stored functions.
Manage database triggers.
Manage foreign keys, checks, and unique constraints.
Manage row-level security policies.
