startino/unrestricted-postgres-mcp

3.3

If you are the rightful owner of unrestricted-postgres-mcp 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, enabling LLMs to query and modify database content with transaction management and safety controls.

Tools

Functions exposed to the LLM to take actions

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, safely applying changes to the database.

execute_rollback

Explicitly rollback a transaction by its ID, discarding all changes and cleaning up resources.

list_tables

Get a comprehensive list of all tables in the database, including column count and descriptions.

describe_table

Get detailed information about a specific table structure, including primary keys, foreign keys, and indexes.