enhanced-postgres-mcp-server
6
The PostgreSQL MCP Server (Enhanced) is a tool designed to provide comprehensive access to PostgreSQL databases through Model Context Protocol. It allows users to perform both read and write operations and manage database schemas using LLMs, paired with extensive tools and security features.
Overview
PostgreSQL MCP Server (Enhanced)
- Description: A Model Context Protocol server enabling read and write access to PostgreSQL databases. The server interacts with LLMs to inspect and modify database schemas and data.
- Features:
- Execute read-only SQL queries
- Data modification (INSERT, UPDATE, DELETE)
- Schema management (Create/Modify tables, functions, triggers, and indices)
- Components:
- Data Query: Tools for executing SQL queries
- Data Modification: Tools for inserting, updating, and deleting records
- Schema Management: Tools for creating and altering database structures
Usage
- Instructions provided for running with Docker and NPX.
- Example commands for querying data, inserting data, updating data, creating tables, functions, and triggers.
Security Considerations
- Utilizes transactions with COMMIT/ROLLBACK
- Executes parameterized queries to prevent SQL injection
License
- Licensed under the MIT License.