$ loading_
Connect to PostgreSQL with psycopg2 for queries, sessions, and transaction control.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "mcp-psycopg2" yet — see the docs or source repo.
Connect to the PostgreSQL database, run this SQL: SELECT id, name, created_at FROM users ORDER BY created_at DESC LIMIT 10; and return the results as a table.
A structured result table containing the latest 10 user records.
Connect to the database, start a transaction, update records in the orders table where status='pending' and created_at is older than 30 days to 'expired', then commit and return the affected row count.
A committed transaction result with the number of affected rows.
Test the current PostgreSQL connection configuration and return the database version, current user, and connection status.
A connectivity check result with key database session details.
Connect to PostgreSQL via MCP for queries, schema inspection, and database changes.
Securely query and manage PostgreSQL databases for operations and automation.
Safely inspect and query PostgreSQL databases using natural language.
Query PostgreSQL, inspect tables, and explore schemas through MCP clients.
Safely query and inspect PostgreSQL databases without enabling risky write operations by default.
Safely explore PostgreSQL schemas and run controlled read or write queries.