Datadog
optimize_query
Suggest a rewritten, optimized version of a SQL query with explanations. Identifies sequential scans, missing indexes, sort spills, join inefficiencies, and suggests index DDL. [BUILD tier]
Remote thinair/data
Other tools also called optimize_query?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"query": {
"type": "string",
"description": "SQL query to optimize"
},
"connection": {
"type": "string",
"description": "Target connection name from this tenant's inventory. Call `list_connections` to see every name + dialect, then match semantically to the user's intent (e.g. 'analytics' → a connection named `*-analytics-*`; 'prod' → a connection with `prod-` prefix). If the user didn't specify, use the tenant's default (first added). Do not invent names — resolve from `list_connections` output."
}
}
}