# Metabase integration

> Open-source business intelligence: query databases, build dashboards, and run saved questions (cards) via the Metabase REST API

- Authentication: apiKey

## Tools (42)

- **Create Card**: Save a new question, model, or metric
- **Create Collection**: Create a new collection
- **Create Dashboard**: Create a new empty dashboard
- **Export Ad-hoc Query**: Run an ad-hoc query and download the results as CSV, JSON, or XLSX
- **Export Card Query**: Run a card and download its results as CSV, JSON, or XLSX
- **Get Card**: Retrieve a single saved question, model, or metric by ID
- **Get Collection**: Retrieve a single collection by ID
- **Get Collection Tree**: Get collections as a nested tree
- **Get Current User**: Retrieve the authenticated user's profile
- **Get Dashboard**: Retrieve a dashboard including its tabs, cards, and parameters
- **Get Database**: Retrieve a single database, optionally with its tables and fields
- **Get Database Metadata**: Retrieve a database's full schema: tables, fields, and field values
- **Get Field**: Retrieve a single field (column) by ID
- **Get Field Values**: Get the distinct cached values for a field
- **Get Metric**: Retrieve a metric card by ID
- **Get Popular Items**: List the most-viewed items on the Metabase instance
- **Get Recent Items**: List items the current user has most recently viewed or selected
- **Get Segment**: Retrieve a single segment by ID
- **Get Table**: Retrieve a single table by ID
- **Get Table Query Metadata**: Get a table's fields, FKs, and field values for building queries
- **Get User**: Retrieve a single user by ID
- **List Alerts**: List alerts the current user created or receives
- **List Cards (Saved Questions)**: List saved questions, models, and metrics the current user can access
- **List Collection Items**: List the items (cards, dashboards, subcollections) inside a collection
- **List Collections**: List collections the current user has read access to
- **List Dashboards**: List dashboards the current user can access
- **List Dashboard Subscriptions**: List dashboard subscriptions (pulses) the current user manages or receives
- **List Databases**: List all databases connected to Metabase
- **List Metrics**: List metric cards visible to the current user
- **List Segments**: List all reusable filter segments
- **List Tables**: List all tables across all connected databases
- **List Timelines**: List timelines (collections of annotated events for charts)
- **List Users**: List Metabase users (admin or group manager only)
- **Rescan Field Values**: Trigger a re-scan of a database's field values (filter dropdown caches)
- **Run Ad-hoc Query**: Execute an MBQL or native SQL query against a database without saving it as a card
- **Run Card Query**: Execute a saved card's query and return the result rows as JSON
- **Run Dashboard Card Query**: Run a specific card within a dashboard, using the dashboard's parameter values
- **Search**: Search cards, dashboards, collections, tables, and other Metabase items
- **Sync Database Schema**: Trigger a schema sync for a database (tables, fields, keys)
- **Update Card**: Modify a saved card's name, query, display, collection, or archive state
- **Update Collection**: Rename, re-parent, set authority level, or archive a collection
- **Update Dashboard**: Update a dashboard's metadata, cards (dashcards), tabs, parameters, or archive state

## Related prompts

- [Monthly investor update draft from Metabase](https://www.generalinput.com/prompts/monthly-investor-update-draft-from-metabase.md)
- [Catch a Metabase metric breach and auto-file a Linear ticket](https://www.generalinput.com/prompts/catch-a-metabase-metric-breach-and-auto-file-a-linear-ticket.md)
- [Weekday morning KPI pulse from Metabase to Slack](https://www.generalinput.com/prompts/weekday-morning-kpi-pulse-from-metabase-to-slack.md)
- [Weekly at-risk customer follow-ups from Metabase to HubSpot](https://www.generalinput.com/prompts/weekly-at-risk-customer-follow-ups-from-metabase-to-hubspot.md)
- [Mirror a Metabase question into Google Sheets on a schedule](https://www.generalinput.com/prompts/mirror-a-metabase-question-into-google-sheets-on-a-schedule.md)

Connect Metabase in General Input: https://www.generalinput.com/apps/metabase