query
Execute SQL queries on a database connection with access control, row limits, and multi-statement blocking.
Instructions
Execute a SQL query on a database connection.
The query type is checked against the connection's allowed operations. Permissions can be a preset (read, write, admin) or a custom list of allowed operations (e.g. [select, insert]).
Multi-statement queries are blocked. SELECT queries have an automatic row limit.
Args: connection: Name of the database connection to use. sql: The SQL query to execute.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connection | Yes | ||
| sql | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |