postgresql-mcp-server
44
PostgreSQL MCP Server is a Model Context Protocol server designed to enhance AI assistants by providing advanced PostgreSQL database management tools. The server consolidates and streamlines database tasks with a focus on ease of use and security.
PostgreSQL MCP Server
A Model Context Protocol (MCP) server providing comprehensive PostgreSQL database management capabilities for AI assistants.
What's New
- Redesigned from 46 to 17 intelligent tools, enhancing AI discovery, data manipulation, and comment management.
Tools Overview
- Consolidation (8 tools): Includes schema management, user & permissions, query performance, etc.
- Enhancement (4 tools): New capabilities like execute query and SQL, comments management.
- Specialized (5 tools): Database analysis, debug, data export/import, real-time monitoring.
Prerequisites
- Node.js ≥ 18.0.0
- PostgreSQL server access
Features Highlights
- Intelligent tool consolidation, multiple operations per tool, enhanced CRUD operations, and security-focused execution.
Contributing
Fork repository, create branch, commit changes, and pull request.