$ loading_
Access PostgreSQL in read-only mode for queries, tables, and schema inspection.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "pg-mcp" yet — see the docs or source repo.
List all tables in the current PostgreSQL database grouped by schema. Then inspect the users, orders, and products tables and return their column names, types, nullability, and primary key markers.
A schema-grouped table list plus detailed column structure for the specified tables.
Query the orders table for the last 30 days' order count, total revenue, and average order value, grouped by date. If column names differ, inspect the schema first and then generate the correct SQL.
An executable read-only SQL query and the daily aggregated results or a result summary.
Inspect the schema of customers, orders, order_items, and products, infer the relationships between them, and explain the joins suitable for analyzing customer purchase behavior.
An explanation of table relationships, likely foreign key links, and recommended JOIN patterns for behavior analysis.
Safely explore PostgreSQL schemas and run controlled read or write queries.
Connect to PostgreSQL via MCP for queries, schema inspection, and database changes.
Safely query read-only PostgreSQL data and inspect schemas, tables, and columns.
Safely inspect and query PostgreSQL databases using natural language.
Query PostgreSQL, inspect tables, and explore schemas through MCP clients.
Query PostgreSQL securely in read-only mode using natural language.