metabase

name	metabase
description	Run SQL queries against a Metabase instance via its API. Use when the user asks to query Metabase, extract data from Metabase, list Metabase databases, or run SQL against a Metabase-connected database. Triggers on "metabase", "query metabase", "metabase SQL", "metabase databases".

Metabase

Run SQL queries against Metabase via its REST API using an API key.

Setup

On first use, check for a .metabase config file at the git repo root. If missing, ask the user to create it:

cat > .metabase <<'EOF'
METABASE_URL=https://metabase.example.com
METABASE_API_KEY=your_api_key_here
METABASE_DATABASE_ID=1
EOF

Then ensure .metabase is in .gitignore. Add it if missing.

Scripts

All scripts source .metabase from the repo root ($(git rev-parse --show-toplevel)/.metabase).

List databases

scripts/databases.sh

Returns {id, name, engine} for each database. Use this to help the user pick the right METABASE_DATABASE_ID.

Run a SQL query

scripts/query.sh 'SELECT count(*) FROM users'

Returns jq-formatted .data.rows array. Override the database per-query:

METABASE_DATABASE_ID=3 scripts/query.sh 'SELECT 1'

Auth

Uses x-api-key header (Metabase API keys), not session tokens.

Error handling

Scripts check HTTP status and print the error body on failure. Common errors:

• 401: invalid or expired API key
• 400: bad SQL syntax (Metabase returns the DB error)