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.
Access PostgreSQL in read-only mode for queries, tables, and schema inspection.
Safely query read-only PostgreSQL data and inspect schemas, tables, and columns.
Safely explore PostgreSQL schemas, table relationships, and sample data in read-only mode.
Query and explore PostgreSQL databases with SQL, tables, and schema inspection.
Inspect PostgreSQL schemas and run read-only SQL queries through MCP tools.
Query PostgreSQL securely in read-only mode using natural language.