get_generated_sql
Generate the actual SQL query that Metabase creates from query builder parameters to understand how your visual queries translate to database commands.
Instructions
š [MODERATE RISK] Get the generated SQL for a query-builder card with parameters. Use this to see the actual SQL that Metabase generates from query builder parameters. Risk: Moderate - executes queries to generate SQL.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cardId | Yes | The card ID | |
| parameters | Yes | Query parameters object |
Input Schema (JSON Schema)
{
"properties": {
"cardId": {
"description": "The card ID",
"minimum": 1,
"type": "integer"
},
"parameters": {
"additionalProperties": true,
"description": "Query parameters object",
"type": "object"
}
},
"required": [
"cardId",
"parameters"
],
"type": "object"
}