execute_query
Run a SQL SELECT query on a Metabase database and retrieve results with options for field selection, pagination, and response format.
Instructions
Execute a SQL query (SELECT statements only)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_id | Yes | Database ID to query | |
| sql | Yes | SQL query (SELECT statements only) | |
| fields | No | Column names to include in results (default: all) | |
| format | No | Response format (default: compact). Use "default" for pretty-printed output | |
| limit | No | Max rows to return (default: server maxRows setting) | |
| offset | No | Row offset for pagination |