run_native_query
Run a read-only native SQL query against a Metabase database. Enforces a LIMIT clause and rejects write or multi-statement queries.
Instructions
Run a native SQL query against a Metabase database. Requires that your API key has native query (SQL) permission in Metabase. IMPORTANT: You must include a LIMIT clause in your SQL to avoid large result sets. Write operations (INSERT, UPDATE, DELETE, DROP, etc.) and multi-statement queries are rejected. The server strips SQL comments before validation.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | The SQL query to execute. Include a LIMIT clause to control result size. | |
| database_id | Yes | The database ID |