execute_query
Execute SQL SELECT queries on Oracle databases and retrieve results as a formatted table or JSON. Supports limiting rows.
Instructions
Execute a SELECT query on an Oracle database. Returns results as a formatted table. Only SELECT statements are allowed.
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": {
"connection": "<connection>",
"sql": "<sql>"
},
"name": "execute_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | SQL SELECT query to execute | |
| format | No | Output format (default: markdown) | markdown |
| max_rows | No | Maximum number of rows to return (default: 100) | |
| connection | Yes | Name of the database connection to use |