Speak to your database: Safely read your PG/SQL DB with Query Studio MCP server

说明与用途

Query Studio 通过聊天界面安全、透明地访问 PostgreSQL，生成只读 SELECT 查询，验证并可选摘要结果。

问题

Users need a conversational interface to query a PostgreSQL database safely, with clear SQL visibility and optional natural‑language explanations.

结果

Query Studio enables safe, conversational access to a PostgreSQL database, providing transparent SQL, read‑only execution, optional explanations, and multiple safeguards against unsafe queries.

工作流

• 1. Connect to PostgreSQL and fetch schema metadata (tables, columns, types).
• 2. Cache schema for reuse; refresh on schema changes.
• 3. Receive user natural‑language request.
• 4. Use construct_sql tool to generate a single SELECT statement, validating against schema.
• 5. Execute the accepted SQL via execute_query tool (no AI call).
• 6. Optionally call summarize_results to explain fetched rows.
• 7. Display SQL, result table, and optional summary to the user.
• 8. Enforce limits: 10s statement timeout, 3s lock timeout, max 1,000 rows, read‑only transaction, and a 6‑model‑call loop limit.

证据

Query Studio connects to a PostgreSQL/SQL database and discovers its structure.

来源

The application validates the completed SQL, accepts one SELECT-based statement, checks its referenced tables against the discovered schema, and rejects writes, deletes, schema changes, and other disallowed forms.

来源

Execution repeats the checks and requires the incoming SQL to match the statement recorded by construct_sql after normalization.

来源