enhanced-postgres-mcp-server
If you are the rightful owner of enhanced-postgres-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.
A Model Context Protocol server that provides both read and write access to PostgreSQL databases, enabling LLMs to inspect database schemas, execute queries, modify data, and create/modify database schema objects.
The PostgreSQL MCP Server (Enhanced) is a powerful tool that extends the capabilities of the original PostgreSQL MCP server by adding write capabilities and schema management. This server allows for comprehensive interaction with PostgreSQL databases, including executing read-only queries, modifying data, and managing database schema objects such as tables, functions, triggers, and indexes. It is designed to work seamlessly with LLMs, providing them with the ability to understand and manipulate database structures and data. The server supports transactions with proper COMMIT/ROLLBACK handling to ensure data integrity and uses parameterized queries to prevent SQL injection. It is compatible with various platforms, including Docker and NPX, making it versatile and easy to integrate into different environments.
Features
- Read and Write Access: Execute queries and modify data with full transaction support.
- Schema Management: Create and modify tables, functions, triggers, and indexes.
- Security: Uses parameterized queries to prevent SQL injection.
- Platform Compatibility: Works with Docker and NPX for easy integration.
- Transparency: Returns executed SQL for all operations.
Tools
query
Perform read-only SQL query
execute
Execute SQL statements for data modification
insert
Insert a new record
update
Update records
delete
Delete records
createTable
Create a new table
createFunction
Create functions/processes
createTrigger
Create a trigger
createIndex
Create an index
alterTable
Modify the table structure
