Query
queryExecutes SQL statements securely against configured databases, supporting parameterized inputs and blocking destructive operations in read-only mode.
Instructions
Execute a SQL query against the database.
Supports parameterized queries for injection safety. In read-only mode, destructive operations (INSERT, UPDATE, DELETE, DROP, etc.) are blocked.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | SQL query to execute | |
| params | No | Optional list of parameters for parameterized queries (use instead of string formatting) | |
| database | No | Database key (format: "type:name"). Required when multiple databases are configured. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |