validate_sql
Parse and classify SQL queries for a selected database connection without executing them, ensuring syntax and structure are validated safely before use.
Instructions
Parse and classify SQL for the selected connection without executing it.
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_id": "<connection_id>",
"sql": "<sql>"
},
"name": "validate_sql"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| connection_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| valid | Yes | ||
| dialect | Yes | ||
| warnings | Yes | ||
| read_only | Yes | ||
| executable | Yes | ||
| normalized_sql | Yes | ||
| statement_type | Yes | Normalized statement families exposed through MCP and audit. | |
| blocked_reasons | Yes | ||
| parameter_names | Yes | ||
| referenced_objects | Yes | ||
| multiple_statements | Yes |