mcp-postgres-full-access-extended
If you are the rightful owner of mcp-postgres-full-access-extended 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 powerful Model Context Protocol server providing full read-write access to PostgreSQL databases.
The PostgreSQL Full Access MCP Server is an advanced implementation of the Model Context Protocol server that allows Large Language Models (LLMs) to interact with PostgreSQL databases with full read-write capabilities. This server extends the functionality of the official MCP PostgreSQL server by enabling data modification operations, schema management, and transaction handling with safety controls. It is designed to provide detailed schema information, advanced safety features, and integration with platforms like Claude Desktop. The server supports executing various SQL operations, including DML, DDL, DCL, and TCL, with explicit transaction management and safety timeouts to ensure secure and efficient database interactions.
Features
- Full Read-Write Access: Safely execute DML operations, manage database objects with DDL, and handle transactions with explicit commit and rollback.
- Rich Schema Information: Provides detailed column metadata, primary and foreign key identification, index information, and table descriptions.
- Advanced Safety Controls: Includes SQL query classification, enforced read-only execution for safe queries, and automatic transaction timeout monitoring.
Tools
execute_query
Execute read-only SQL queries within a READ ONLY transaction.
execute_dml_ddl_dcl_tcl
Execute data modification operations or schema changes with automatic transaction handling.
execute_maintenance
Execute maintenance commands like VACUUM or ANALYZE outside of transactions.
execute_commit
Explicitly commit a transaction by its ID.
execute_rollback
Explicitly rollback a transaction by its ID.
list_tables
Get a comprehensive list of all tables in the database.
describe_table
Get detailed information about a specific table structure.
list_schemas
Get a list of all schemas in the database.
