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.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"sql": "<sql>"
},
"name": "query"
}
}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 |