Safely query and modify PostgreSQL data with transactions and controlled full access.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "mcp-postgres-full-access-extended" yet — see the docs or source repo.
Connect to the PostgreSQL database and find the top 10 customers by order count in the last 30 days. Return customer name, order count, and total spending, sorted by total spending descending.
A query result showing customer names, order counts, and total spending summaries.
Within a transaction, update all tickets with status 'pending' and created more than 7 days ago to 'expired'. First count affected rows, then perform the update and return a summary.
A summary with affected row count, update status, and transaction outcome.
Check for duplicate values in the users table email column. If duplicates exist, provide remediation suggestions. If not, add a unique constraint on email within a transaction and explain the steps and risks.
A report with validation results, risk notes, and either the constraint change summary or remediation guidance.
Query and manage remote PostgreSQL databases securely using natural language.
Query PostgreSQL databases safely in natural language with read-only access.
Query and explore PostgreSQL databases with SQL, tables, and schema inspection.
Let AI query, manage, tune, and administer PostgreSQL databases deeply.
Query PostgreSQL securely in read-only mode using natural language.
Safely explore PostgreSQL schemas and run controlled read or write queries.