Query PostgreSQL databases read-only and inspect schemas, tables, and metadata.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "mcp-postgresdb-readonly" yet — see the docs or source repo.
List all schemas and tables in the current PostgreSQL environment, grouped by schema.
A schema-grouped list of tables for quickly understanding the database structure.
Describe the structure of the public.orders table, including column names, data types, nullability, and primary key or index information.
Detailed table metadata to help understand column design and constraints.
Query the top 10 customers with the most orders in the last 30 days, returning customer ID and order count sorted descending.
Read-only SQL query results that can be used to analyze recent business performance.
Safely query read-only PostgreSQL data and inspect schemas, tables, and columns.
Safely inspect PostgreSQL schemas and run read-only queries for analysis.
Safely query, inspect, and analyze PostgreSQL databases in read-only mode.
Safely query read-only PostgreSQL data and inspect schemas for analysis.
Safely explore PostgreSQL schemas, table relationships, and sample data in read-only mode.
Inspect PostgreSQL schemas and run read-only SQL queries through MCP tools.