mcp-postgres-full-access
If you are the rightful owner of mcp-postgres-full-access 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 a robust implementation of the Model Context Protocol that allows Large Language Models (LLMs) to interact with PostgreSQL databases with full read-write capabilities. Unlike the official read-only MCP PostgreSQL server, this version supports data manipulation and schema modification operations, ensuring proper transaction management and safety controls. It provides detailed schema information, advanced safety features, and integrates seamlessly with platforms like Claude Desktop. The server is designed to handle complex database operations while maintaining security and integrity through explicit transaction management and user confirmation processes.
Features
- Full Read-Write Access: Safely execute DML operations, manage database objects, and handle transactions with safety timeouts.
- 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, isolated transactions, and a two-step transaction commit process.
Tools
execute_query
Execute read-only SQL queries (SELECT statements) within a READ ONLY transaction.
execute_dml_ddl_dcl_tcl
Execute data modification operations or schema changes, automatically wrapped in a transaction.
execute_maintenance
Execute maintenance commands like VACUUM, ANALYZE, or CREATE DATABASE outside of transactions.
execute_commit
Explicitly commit a transaction by its ID, applying changes to the database.
execute_rollback
Explicitly rollback a transaction by its ID, discarding all changes.
list_tables
Get a comprehensive list of all tables in the database.
describe_table
Get detailed information about a specific table structure.
