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.
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.