db_query
Query discovered PostgreSQL, MySQL, or SQLite databases read-only. Obtain a connectionId with inspect_project, then run validated SELECT, WITH, or EXPLAIN statements; writes, functions, and unbounded executions are blocked.
Instructions
Read-only query of a discovered PostgreSQL, MySQL or SQLite database. First call inspect_project for a connectionId. Supports validated SELECT, read-only WITH and EXPLAIN SELECT, including metadata tables. Writes, arbitrary functions, multi-statements, comments and execution modifiers are rejected. Credentials remain inside the server. Rows and execution time are bounded.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | ||
| maxRows | No | ||
| connectionId | Yes |