Securely connect AI to PostgreSQL for read-only queries, schema discovery, and performance analysis.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "pg-lens-mcp" yet — see the docs or source repo.
Connect to the PostgreSQL database in read-only mode, list all schemas, tables, views, and key columns, and summarize the purpose of each table.
A clear schema overview with database objects, column details, and table purpose summaries.
Based on the database schema, query weekly new users, paid users, and conversion rates for the last 30 days, and explain which tables and columns were used.
Executable query results or SQL, plus metric definitions and an explanation of the data sources used.
Please inspect the execution performance of this PostgreSQL query, identify likely bottlenecks, and suggest index or SQL optimizations: SELECT * FROM orders WHERE customer_id = 123 AND created_at >= NOW() - INTERVAL '90 days';
Performance issue analysis, likely causes, and concrete optimization recommendations.
Query PostgreSQL securely in read-only mode using natural language.
Query PostgreSQL databases safely in natural language with read-only access.
Safely query PostgreSQL databases to inspect schemas, tables, and data.
Query PostgreSQL, inspect schemas, and run SQL safely with natural language.
Securely connect AI to PostgreSQL for querying, schema analysis, and controlled writes.
Safely let AI query and analyze Postgres data in read-only mode.