Skip to main content

Metabase

Access Metabase dashboards, questions (cards), collections, databases, and users — browse and search BI content, and run saved or ad-hoc queries.

Categories: Analytics, Business Intelligence

What you can ask​

  • Run the Weekly Active Users saved question and post the result to the team channel.
  • Search dashboards and questions for anything referencing a deprecated table.
  • Run an ad-hoc query against the warehouse and summarize the result.

Set up​

Metabase connects with credentials from your Metabase account. Have these values ready:

  • Instance URL
  • API key
  1. Go to Organization > Connectors and find Metabase.
  2. Click Enable and choose which tools to allow.
  3. Each member enters their own values the first time they use it.

To use one account for the whole organization, turn on Share one connection with everyone. Every member's agents then act as that account, with exactly the access it has.

Tools​

Metabase offers 21 tools. Admins choose which ones agents can use. See Tool permission groups.

Read (15)​

View and search information without changing it.

ToolWhat it does
get_cardGet a card (saved question) by ID.
get_collectionGet a collection by ID.
get_dashboardGet a dashboard by ID.
get_databaseGet a database by ID.
get_groupGet a permission group by ID, including its member list (user id/email/name per member).
get_userGet a Metabase user by ID.
list_cardsList cards (saved questions) with client-side pagination (the Metabase API returns the full list; this tool slices it for you) and server-side filters.
list_collectionsList collections (folders that organize dashboards and questions) with client-side pagination (the Metabase API returns the full list; this tool slices it for you).
list_dashboardsList dashboards with server-side pagination and filters, including by collection_id.
list_databasesList databases connected to this Metabase instance with client-side pagination (the Metabase API returns the full list; this tool slices it for you).
list_groupsList permission groups with client-side pagination (the Metabase API returns the full list; this tool slices it for you).
list_usersList Metabase users with server-side pagination and filters.
run_card_queryRun a card's saved query and return its result rows and columns, truncated to limit rows (default 500) to avoid overflowing context.
searchSearch dashboards, cards (questions), collections, tables, and databases by name substring, with server-side filters and server-side pagination.
validate_credentialValidate the Metabase instance URL and API key by fetching the current user.

Write (2)​

Create or send data.

ToolWhat it does
create_cardCreate a new card (saved question).
create_dashboardCreate a new dashboard.

Delete or overwrite (4)​

Remove or replace existing data.

ToolWhat it does
delete_cardPermanently and irreversibly delete a card by ID (hard delete — cannot be undone).
delete_dashboardPermanently and irreversibly delete a dashboard by ID (hard delete — cannot be undone).
update_cardUpdate a card's name, description, query, display, collection, or archived status.
update_dashboardUpdate a dashboard's name, description, collection, or archived status.
⌘J