$ loading_
Safely explore PostgreSQL schemas and run controlled read or write queries.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "postgres-mcp" yet — see the docs or source repo.
Connect to this PostgreSQL database, list all schemas, tables, and key columns, and organize them by business domain with a short explanation of each table.
A structured schema inventory with schemas, tables, columns, and purpose notes for quickly understanding the data model.
Use readonly mode to query the last 30 days of order data, calculate daily order count, total revenue, and average order value, and highlight unusual fluctuation dates.
A read-only SQL execution summary with analysis results, key metrics, and notes on anomalous dates.
Using readwrite mode, prepare to update records where status='pending' and created_at is older than 90 days to 'archived'. Do a dry run first, show the affected row count and sample records, and wait for my confirmation before executing.
First returns a dry-run preview and impact summary, then performs the actual update after confirmation and reports the result.
Safely query and inspect PostgreSQL databases without enabling risky write operations by default.
Connect AI assistants to PostgreSQL for secure querying, management, and analysis.
Safely query read-only PostgreSQL data and inspect schemas, tables, and columns.
Safely query, inspect, and analyze PostgreSQL databases in read-only mode.
Safely manage PostgreSQL databases with schema exploration, procedure analysis, and test data generation.
Connect to PostgreSQL via MCP for queries, schema inspection, and database changes.