Metabase

Metabase MCP Server for Cloudflare Workers

Available Tools

78 tools available in the Metabase MCP server. Each tool can be called by AI assistants to perform specific actions.

metabase_list_segments

List all segments in Metabase.

Segments are saved filter sets that can be reused in questions.

Args:

format: Response format

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    }
  }
}

metabase_get_user

Get details of a specific user by ID.

Args:

userId: User ID
format: Response format

{
  "type": "object",
  "required": [
    "userId"
  ],
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "userId": {
      "type": "number",
      "description": "User ID"
    }
  }
}

metabase_get_current_user

Get the currently authenticated user.

Args:

format: Response format

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    }
  }
}

metabase_favorite_card

Add or remove a card from favorites.

Args:

cardId: Card ID
favorite: true to favorite, false to unfavorite

{
  "type": "object",
  "required": [
    "cardId",
    "favorite"
  ],
  "properties": {
    "cardId": {
      "type": "number",
      "description": "Card ID"
    },
    "favorite": {
      "type": "boolean",
      "description": "true to favorite, false to unfavorite"
    }
  }
}

metabase_remove_card_from_dashboard

Remove a card from a dashboard.

Args:

dashboardId: Dashboard ID
dashcardId: Dashboard card ID (not the card ID)

{
  "type": "object",
  "required": [
    "dashboardId",
    "dashcardId"
  ],
  "properties": {
    "dashcardId": {
      "type": "number",
      "description": "Dashboard card ID"
    },
    "dashboardId": {
      "type": "number",
      "description": "Dashboard ID"
    }
  }
}

metabase_get_segment

Get details of a specific segment.

Args:

segmentId: Segment ID
format: Response format

{
  "type": "object",
  "required": [
    "segmentId"
  ],
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "segmentId": {
      "type": "number",
      "description": "Segment ID"
    }
  }
}

metabase_run_card

Execute a card's query and return the results.

Args:

cardId: Card ID to run
parameters: Query parameters (for parameterized queries)
format: Response format

{
  "type": "object",
  "required": [
    "cardId"
  ],
  "properties": {
    "cardId": {
      "type": "number",
      "description": "Card ID to run"
    },
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string",
      "default": "json",
      "description": "Response format"
    },
    "parameters": {
      "type": "object",
      "description": "Query parameters"
    }
  }
}

metabase_delete_alert

Delete an alert.

Args:

alertId: Alert ID to delete

{
  "type": "object",
  "required": [
    "alertId"
  ],
  "properties": {
    "alertId": {
      "type": "number",
      "description": "Alert ID"
    }
  }
}

metabase_unsubscribe_from_alert

Unsubscribe the current user from an alert.

Args:

alertId: Alert ID

{
  "type": "object",
  "required": [
    "alertId"
  ],
  "properties": {
    "alertId": {
      "type": "number",
      "description": "Alert ID"
    }
  }
}

metabase_update_card

Update an existing card (question).

Args:

cardId: Card ID to update
name: New card name
description: New description
display: New visualization type
archived: Archive/unarchive the card
collectionId: Move to collection

{
  "type": "object",
  "required": [
    "cardId"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "New name"
    },
    "cardId": {
      "type": "number",
      "description": "Card ID to update"
    },
    "archived": {
      "type": "boolean",
      "description": "Archive/unarchive"
    },
    "description": {
      "type": "string",
      "description": "New description"
    },
    "collectionId": {
      "type": "number",
      "description": "Move to collection"
    }
  }
}

metabase_list_alerts

List all alerts in Metabase.

Alerts notify users when query results meet certain conditions.

Args:

archived: Include archived alerts (default: false)
format: Response format

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "archived": {
      "type": "boolean",
      "default": false,
      "description": "Include archived"
    }
  }
}

metabase_get_alerts_for_card

Get all alerts set up for a specific card (question).

Args:

cardId: Card ID
format: Response format

{
  "type": "object",
  "required": [
    "cardId"
  ],
  "properties": {
    "cardId": {
      "type": "number",
      "description": "Card ID"
    },
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    }
  }
}

metabase_create_alert

Create a new alert for a card.

Args:

cardId: Card ID to monitor
alertCondition: 'rows' (alert when rows exist) or 'goal' (alert on goal status)
alertFirstOnly: Only alert the first time condition is met
alertAboveGoal: For goal alerts, alert when above goal (true) or below (false)
channelType: Notification channel ('email' or 'slack')
scheduleType: How often to check ('hourly', 'daily', 'weekly')
scheduleHour: Hour to check (for daily/weekly)
scheduleDay: Day to check (for weekly, e.g., 'mon', 'tue')
recipients: User IDs to notify (for email)

{
  "type": "object",
  "required": [
    "cardId",
    "alertCondition",
    "scheduleType"
  ],
  "properties": {
    "cardId": {
      "type": "number",
      "description": "Card ID"
    },
    "recipients": {
      "type": "array",
      "items": {
        "type": "number"
      },
      "description": "User IDs"
    },
    "channelType": {
      "enum": [
        "email",
        "slack"
      ],
      "type": "string",
      "default": "email",
      "description": "Channel"
    },
    "scheduleDay": {
      "type": "string",
      "description": "Day of week"
    },
    "scheduleHour": {
      "type": "number",
      "description": "Hour (0-23)"
    },
    "scheduleType": {
      "enum": [
        "hourly",
        "daily",
        "weekly"
      ],
      "type": "string",
      "description": "Schedule"
    },
    "alertAboveGoal": {
      "type": "boolean",
      "description": "Alert above goal"
    },
    "alertCondition": {
      "enum": [
        "rows",
        "goal"
      ],
      "type": "string",
      "description": "Alert condition"
    },
    "alertFirstOnly": {
      "type": "boolean",
      "default": false,
      "description": "Alert first time only"
    }
  }
}

metabase_update_alert

Update an existing alert.

Args:

alertId: Alert ID
alertCondition: New alert condition
alertFirstOnly: Alert first time only
alertAboveGoal: Alert above goal
archived: Archive/unarchive the alert

{
  "type": "object",
  "required": [
    "alertId"
  ],
  "properties": {
    "alertId": {
      "type": "number",
      "description": "Alert ID"
    },
    "archived": {
      "type": "boolean",
      "description": "Archive"
    },
    "alertAboveGoal": {
      "type": "boolean",
      "description": "Above goal"
    },
    "alertCondition": {
      "enum": [
        "rows",
        "goal"
      ],
      "type": "string",
      "description": "Alert condition"
    },
    "alertFirstOnly": {
      "type": "boolean",
      "description": "First time only"
    }
  }
}

metabase_list_cards

List all saved questions (cards) in Metabase.

Returns a list of cards with their IDs, names, display types, and collection info.

Args:

collectionId: Filter cards by collection ID (optional)
archived: Include archived cards (default: false)
format: Response format ('json' or 'markdown')

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string",
      "default": "json",
      "description": "Response format"
    },
    "archived": {
      "type": "boolean",
      "default": false,
      "description": "Include archived cards"
    },
    "collectionId": {
      "type": "number",
      "description": "Filter by collection ID"
    }
  }
}

metabase_get_card

Get details of a specific card (question) by ID.

Returns the full card definition including query, visualization settings, and metadata.

Args:

cardId: The card ID
format: Response format

{
  "type": "object",
  "required": [
    "cardId"
  ],
  "properties": {
    "cardId": {
      "type": "number",
      "description": "Card ID"
    },
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    }
  }
}

metabase_create_card

Create a new card (saved question) in Metabase.

Args:

name: Card name (required)
description: Card description
display: Visualization type (table, bar, line, pie, etc.)
databaseId: Database ID for the query
queryType: Query type ('query' for MBQL, 'native' for SQL)
nativeQuery: SQL query (if queryType is 'native')
sourceTable: Source table ID (if queryType is 'query')
collectionId: Collection to save the card in

{
  "type": "object",
  "required": [
    "name",
    "databaseId"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "Card name"
    },
    "queryType": {
      "enum": [
        "query",
        "native"
      ],
      "type": "string",
      "default": "query",
      "description": "Query type"
    },
    "databaseId": {
      "type": "number",
      "description": "Database ID"
    },
    "description": {
      "type": "string",
      "default": "table') .describe('Visualization type",
      "description": "Card description"
    },
    "nativeQuery": {
      "type": "string",
      "description": "SQL query for native type"
    },
    "sourceTable": {
      "type": "number",
      "description": "Source table ID for MBQL query"
    },
    "collectionId": {
      "type": "number",
      "description": "Collection ID"
    }
  }
}

metabase_delete_card

Delete (archive) a card. Cards are not permanently deleted but moved to trash.

Args:

cardId: Card ID to delete

{
  "type": "object",
  "required": [
    "cardId"
  ],
  "properties": {
    "cardId": {
      "type": "number",
      "description": "Card ID to delete"
    }
  }
}

metabase_list_collections

List all collections in Metabase.

Collections are folders that organize dashboards, questions, and other items.

Args:

archived: Include archived collections (default: false)
format: Response format ('json' or 'markdown')

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string",
      "default": "json",
      "description": "Response format"
    },
    "archived": {
      "type": "boolean",
      "default": false,
      "description": "Include archived collections"
    }
  }
}

metabase_get_collection

Get details of a specific collection by ID.

Use 'root' as the ID to get the root collection.

Args:

collectionId: The collection ID (number or 'root')
format: Response format

{
  "type": "object",
  "required": [
    "collectionId"
  ],
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "collectionId": {
      "type": "string",
      "description": "Collection ID or \"root\""
    }
  }
}

metabase_create_collection

Create a new collection in Metabase.

Args:

name: Collection name (required)
description: Collection description
color: Collection color (hex format, e.g., '#509EE3')
parentId: Parent collection ID ('root' or number)

{
  "type": "object",
  "required": [
    "name"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "Collection name"
    },
    "color": {
      "type": "string",
      "description": "Collection color (hex)"
    },
    "parentId": {
      "type": "string",
      "description": "Parent collection"
    },
    "description": {
      "type": "string",
      "description": "Collection description"
    }
  }
}

metabase_update_collection

Update an existing collection.

Args:

collectionId: Collection ID to update
name: New collection name
description: New description
color: New color
archived: Archive/unarchive the collection
parentId: Move to parent collection

{
  "type": "object",
  "required": [
    "collectionId"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "New name"
    },
    "color": {
      "type": "string",
      "description": "New color"
    },
    "archived": {
      "type": "boolean",
      "description": "Archive/unarchive"
    },
    "parentId": {
      "type": "string",
      "description": "Move to parent"
    },
    "description": {
      "type": "string",
      "description": "New description"
    },
    "collectionId": {
      "type": "number",
      "description": "Collection ID to update"
    }
  }
}

metabase_get_collection_items

Get items (cards, dashboards, etc.) in a collection.

Args:

collectionId: Collection ID (number or 'root')
models: Filter by item types (card, dashboard, collection, pulse)
archived: Include archived items
format: Response format

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "archived": {
      "type": "boolean",
      "default": false,
      "description": "Include archived items"
    },
    "collectionId": {
      "type": "string",
      "description": "Collection ID or \"root\""
    }
  }
}

metabase_get_collection_tree

Get the collection hierarchy as a tree structure.

Returns all collections organized in their parent-child relationships.

Args:

format: Response format

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    }
  }
}

metabase_list_dashboards

List all dashboards in Metabase.

Returns a list of dashboards with their IDs, names, and collection info.

Args:

archived: Include archived dashboards (default: false)
format: Response format ('json' or 'markdown')

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string",
      "default": "json",
      "description": "Response format"
    },
    "archived": {
      "type": "boolean",
      "default": false,
      "description": "Include archived dashboards"
    }
  }
}

metabase_get_dashboard

Get details of a specific dashboard by ID.

Returns the full dashboard definition including cards, parameters, and layout.

Args:

dashboardId: The dashboard ID
format: Response format

{
  "type": "object",
  "required": [
    "dashboardId"
  ],
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "dashboardId": {
      "type": "number",
      "description": "Dashboard ID"
    }
  }
}

metabase_create_dashboard

Create a new dashboard in Metabase.

Args:

name: Dashboard name (required)
description: Dashboard description
collectionId: Collection to save the dashboard in

{
  "type": "object",
  "required": [
    "name"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "Dashboard name"
    },
    "description": {
      "type": "string",
      "description": "Dashboard description"
    },
    "collectionId": {
      "type": "number",
      "description": "Collection ID"
    }
  }
}

metabase_update_dashboard

Update an existing dashboard.

Args:

dashboardId: Dashboard ID to update
name: New dashboard name
description: New description
archived: Archive/unarchive the dashboard
collectionId: Move to collection

{
  "type": "object",
  "required": [
    "dashboardId"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "New name"
    },
    "archived": {
      "type": "boolean",
      "description": "Archive/unarchive"
    },
    "dashboardId": {
      "type": "number",
      "description": "Dashboard ID to update"
    },
    "description": {
      "type": "string",
      "description": "New description"
    },
    "collectionId": {
      "type": "number",
      "description": "Move to collection"
    }
  }
}

metabase_delete_dashboard

Delete a dashboard.

Args:

dashboardId: Dashboard ID to delete

{
  "type": "object",
  "required": [
    "dashboardId"
  ],
  "properties": {
    "dashboardId": {
      "type": "number",
      "description": "Dashboard ID to delete"
    }
  }
}

metabase_add_card_to_dashboard

Add a saved question (card) to a dashboard.

Args:

dashboardId: Dashboard ID
cardId: Card ID to add
row: Row position (default: 0)
col: Column position (default: 0)
sizeX: Width in grid units (default: 4)
sizeY: Height in grid units (default: 4)

{
  "type": "object",
  "required": [
    "dashboardId",
    "cardId"
  ],
  "properties": {
    "col": {
      "type": "number",
      "default": 0,
      "description": "Column position"
    },
    "row": {
      "type": "number",
      "default": 0,
      "description": "Row position"
    },
    "sizeX": {
      "type": "number",
      "default": 4,
      "description": "Width in grid units"
    },
    "sizeY": {
      "type": "number",
      "default": 4,
      "description": "Height in grid units"
    },
    "cardId": {
      "type": "number",
      "description": "Card ID to add"
    },
    "dashboardId": {
      "type": "number",
      "description": "Dashboard ID"
    }
  }
}

metabase_copy_dashboard

Create a copy of a dashboard.

Args:

dashboardId: Dashboard ID to copy
name: Name for the new dashboard
collectionId: Collection for the new dashboard

{
  "type": "object",
  "required": [
    "dashboardId"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "Name for the copy"
    },
    "dashboardId": {
      "type": "number",
      "description": "Dashboard ID to copy"
    },
    "collectionId": {
      "type": "number",
      "description": "Target collection"
    }
  }
}

metabase_favorite_dashboard

Add or remove a dashboard from favorites.

Args:

dashboardId: Dashboard ID
favorite: true to favorite, false to unfavorite

{
  "type": "object",
  "required": [
    "dashboardId",
    "favorite"
  ],
  "properties": {
    "favorite": {
      "type": "boolean",
      "description": "true to favorite, false to unfavorite"
    },
    "dashboardId": {
      "type": "number",
      "description": "Dashboard ID"
    }
  }
}

metabase_list_databases

List all databases connected to Metabase.

Args:

includeTables: Include table information (default: false)
format: Response format ('json' or 'markdown')

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string",
      "default": "json",
      "description": "Response format"
    },
    "includeTables": {
      "type": "boolean",
      "default": false,
      "description": "Include tables"
    }
  }
}

metabase_get_database

Get details of a specific database by ID.

Args:

databaseId: The database ID
format: Response format

{
  "type": "object",
  "required": [
    "databaseId"
  ],
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "databaseId": {
      "type": "number",
      "description": "Database ID"
    }
  }
}

metabase_get_database_metadata

Get full metadata for a database including all tables and fields.

This is useful for understanding the schema before writing queries.

Args:

databaseId: The database ID
format: Response format

{
  "type": "object",
  "required": [
    "databaseId"
  ],
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "databaseId": {
      "type": "number",
      "description": "Database ID"
    }
  }
}

metabase_sync_database

Trigger a sync of a database's metadata.

This refreshes Metabase's understanding of the database schema.

Args:

databaseId: The database ID

{
  "type": "object",
  "required": [
    "databaseId"
  ],
  "properties": {
    "databaseId": {
      "type": "number",
      "description": "Database ID"
    }
  }
}

metabase_sync_database_schema

Force a full schema sync of a database.

This is more thorough than a regular sync and requires admin privileges.

Args:

databaseId: The database ID

{
  "type": "object",
  "required": [
    "databaseId"
  ],
  "properties": {
    "databaseId": {
      "type": "number",
      "description": "Database ID"
    }
  }
}

metabase_rescan_database_field_values

Rescan field values for a database.

This updates the cached list of values for filter dropdowns.

Args:

databaseId: The database ID

{
  "type": "object",
  "required": [
    "databaseId"
  ],
  "properties": {
    "databaseId": {
      "type": "number",
      "description": "Database ID"
    }
  }
}

metabase_discard_database_field_values

Discard cached field values for a database.

Args:

databaseId: The database ID

{
  "type": "object",
  "required": [
    "databaseId"
  ],
  "properties": {
    "databaseId": {
      "type": "number",
      "description": "Database ID"
    }
  }
}

metabase_get_database_schemas

Get all schemas in a database.

Args:

databaseId: The database ID

{
  "type": "object",
  "required": [
    "databaseId"
  ],
  "properties": {
    "databaseId": {
      "type": "number",
      "description": "Database ID"
    }
  }
}

metabase_get_database_tables

Get all tables in a database, optionally filtered by schema.

Args:

databaseId: The database ID
schema: Filter by schema name
format: Response format

{
  "type": "object",
  "required": [
    "databaseId"
  ],
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "schema": {
      "type": "string",
      "description": "Schema name filter"
    },
    "databaseId": {
      "type": "number",
      "description": "Database ID"
    }
  }
}

metabase_list_permissions_groups

List all permission groups in Metabase.

Permission groups control access to databases, tables, and features.

Args:

format: Response format

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    }
  }
}

metabase_get_permissions_group

Get details of a specific permission group.

Args:

groupId: Permission group ID
format: Response format

{
  "type": "object",
  "required": [
    "groupId"
  ],
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "groupId": {
      "type": "number",
      "description": "Permission group ID"
    }
  }
}

metabase_create_permissions_group

Create a new permission group.

Requires admin privileges.

Args:

name: Group name

{
  "type": "object",
  "required": [
    "name"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "Group name"
    }
  }
}

metabase_delete_permissions_group

Delete a permission group.

Requires admin privileges. Cannot delete built-in groups.

Args:

groupId: Permission group ID

{
  "type": "object",
  "required": [
    "groupId"
  ],
  "properties": {
    "groupId": {
      "type": "number",
      "description": "Permission group ID"
    }
  }
}

metabase_get_permissions_graph

Get the full permissions graph.

Shows all database and table permissions for all groups. Requires admin privileges.

Args:

format: Response format

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    }
  }
}

metabase_get_permissions_membership

Get all user-group memberships.

Shows which users belong to which groups. Requires admin privileges.

{
  "type": "object",
  "properties": {}
}

metabase_add_user_to_group

Add a user to a permission group.

Requires admin privileges.

Args:

groupId: Permission group ID
userId: User ID

{
  "type": "object",
  "required": [
    "groupId",
    "userId"
  ],
  "properties": {
    "userId": {
      "type": "number",
      "description": "User ID"
    },
    "groupId": {
      "type": "number",
      "description": "Permission group ID"
    }
  }
}

metabase_remove_user_from_group

Remove a user from a permission group.

Requires admin privileges.

Args:

membershipId: Membership ID (from permissions membership endpoint)

{
  "type": "object",
  "required": [
    "membershipId"
  ],
  "properties": {
    "membershipId": {
      "type": "number",
      "description": "Membership ID"
    }
  }
}

metabase_run_native_query

Execute a native SQL query against a database.

This runs the query directly and returns the results. Use this for ad-hoc analysis.

Args:

databaseId: Database ID to run the query against
query: SQL query to execute
format: Response format ('json' or 'markdown')

{
  "type": "object",
  "required": [
    "databaseId",
    "query"
  ],
  "properties": {
    "query": {
      "type": "string",
      "description": "SQL query"
    },
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string",
      "default": "json",
      "description": "Response format"
    },
    "databaseId": {
      "type": "number",
      "description": "Database ID"
    }
  }
}

metabase_run_query

Execute a structured query (MBQL) against a database.

MBQL is Metabase's query language for building queries without SQL.

Args:

databaseId: Database ID
sourceTable: Source table ID
fields: Field IDs to select (optional - returns all if not specified)
filter: Filter conditions in MBQL format (optional)
aggregation: Aggregation in MBQL format (optional)
breakout: Grouping fields in MBQL format (optional)
orderBy: Sort order in MBQL format (optional)
limit: Maximum rows to return (optional)
format: Response format

{
  "type": "object",
  "required": [
    "databaseId",
    "sourceTable"
  ],
  "properties": {
    "limit": {
      "type": "number",
      "description": "Maximum rows"
    },
    "fields": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Field references to select"
    },
    "filter": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Filter conditions"
    },
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "orderBy": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Sort order"
    },
    "breakout": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Grouping fields"
    },
    "databaseId": {
      "type": "number",
      "description": "Database ID"
    },
    "aggregation": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Aggregation"
    },
    "sourceTable": {
      "type": "number",
      "description": "Source table ID"
    }
  }
}

metabase_search

Search across all Metabase content.

Searches cards, dashboards, collections, tables, and more.

Args:

query: Search query string
models: Filter by content types (card, dashboard, collection, table, database, segment, metric)
archived: Include archived items (default: false)
databaseId: Filter by database ID
limit: Maximum results to return
format: Response format

{
  "type": "object",
  "properties": {
    "limit": {
      "type": "number",
      "default": 20,
      "description": "Maximum results"
    },
    "query": {
      "type": "string",
      "description": "Search query"
    },
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "archived": {
      "type": "boolean",
      "default": false,
      "description": "Include archived"
    },
    "databaseId": {
      "type": "number",
      "description": "Filter by database"
    }
  }
}

metabase_list_settings

List all Metabase settings.

Returns all configurable settings with their current values. Requires admin privileges for most settings.

Args:

format: Response format

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    }
  }
}

metabase_get_setting

Get a specific Metabase setting value.

Args:

key: Setting key (e.g., 'site-name', 'admin-email')

{
  "type": "object",
  "required": [
    "key"
  ],
  "properties": {
    "key": {
      "type": "string",
      "description": "Setting key"
    }
  }
}

metabase_update_setting

Update a Metabase setting.

Requires admin privileges.

Args:

key: Setting key
value: New value

{
  "type": "object",
  "required": [
    "key",
    "value"
  ],
  "properties": {
    "key": {
      "type": "string",
      "description": "Setting key"
    },
    "value": {
      "description": "New value"
    }
  }
}

metabase_get_recent_activity

Get recent activity across Metabase.

Shows recent user actions like creating cards, viewing dashboards, etc.

Args:

format: Response format

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    }
  }
}

metabase_get_recent_views

Get the current user's recently viewed items.

Returns up to 10 most recently viewed cards and dashboards.

Args:

format: Response format

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    }
  }
}

metabase_create_segment

Create a new segment.

Requires admin privileges.

Args:

name: Segment name
description: Segment description
tableId: Table ID the segment applies to
filter: Filter definition in MBQL format

{
  "type": "object",
  "required": [
    "name",
    "tableId",
    "filter"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "Segment name"
    },
    "filter": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Filter in MBQL format"
    },
    "tableId": {
      "type": "number",
      "description": "Table ID"
    },
    "description": {
      "type": "string",
      "description": "Description"
    }
  }
}

metabase_update_segment

Update an existing segment.

Args:

segmentId: Segment ID
name: New name
description: New description
filter: New filter definition
archived: Archive/unarchive

{
  "type": "object",
  "required": [
    "segmentId"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "New name"
    },
    "filter": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "New filter"
    },
    "archived": {
      "type": "boolean",
      "description": "Archive"
    },
    "segmentId": {
      "type": "number",
      "description": "Segment ID"
    },
    "description": {
      "type": "string",
      "description": "New description"
    }
  }
}

metabase_delete_segment

Delete a segment.

Args:

segmentId: Segment ID

{
  "type": "object",
  "required": [
    "segmentId"
  ],
  "properties": {
    "segmentId": {
      "type": "number",
      "description": "Segment ID"
    }
  }
}

metabase_list_metrics

List all metrics in Metabase.

Metrics are saved aggregations that can be reused in questions.

Args:

format: Response format

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    }
  }
}

metabase_get_metric

Get details of a specific metric.

Args:

metricId: Metric ID
format: Response format

{
  "type": "object",
  "required": [
    "metricId"
  ],
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "metricId": {
      "type": "number",
      "description": "Metric ID"
    }
  }
}

metabase_create_metric

Create a new metric.

Requires admin privileges.

Args:

name: Metric name
description: Metric description
tableId: Table ID the metric applies to
aggregation: Aggregation definition in MBQL format
filter: Optional filter in MBQL format

{
  "type": "object",
  "required": [
    "name",
    "tableId",
    "aggregation"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "Metric name"
    },
    "filter": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Filter in MBQL"
    },
    "tableId": {
      "type": "number",
      "description": "Table ID"
    },
    "aggregation": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Aggregation in MBQL"
    },
    "description": {
      "type": "string",
      "description": "Description"
    }
  }
}

metabase_update_metric

Update an existing metric.

Args:

metricId: Metric ID
name: New name
description: New description
aggregation: New aggregation
filter: New filter
archived: Archive/unarchive

{
  "type": "object",
  "required": [
    "metricId"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "New name"
    },
    "filter": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "New filter"
    },
    "archived": {
      "type": "boolean",
      "description": "Archive"
    },
    "metricId": {
      "type": "number",
      "description": "Metric ID"
    },
    "aggregation": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "New aggregation"
    },
    "description": {
      "type": "string",
      "description": "New description"
    }
  }
}

metabase_delete_metric

Delete a metric.

Args:

metricId: Metric ID

{
  "type": "object",
  "required": [
    "metricId"
  ],
  "properties": {
    "metricId": {
      "type": "number",
      "description": "Metric ID"
    }
  }
}

metabase_list_tables

List all tables, optionally filtered by database.

Args:

databaseId: Filter by database ID (optional)
format: Response format

{
  "type": "object",
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "databaseId": {
      "type": "number",
      "description": "Filter by database"
    }
  }
}

metabase_get_table

Get details of a specific table by ID.

Args:

tableId: Table ID
format: Response format

{
  "type": "object",
  "required": [
    "tableId"
  ],
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "tableId": {
      "type": "number",
      "description": "Table ID"
    }
  }
}

metabase_get_table_metadata

Get full metadata for a table including all fields.

Args:

tableId: Table ID
format: Response format

{
  "type": "object",
  "required": [
    "tableId"
  ],
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "tableId": {
      "type": "number",
      "description": "Table ID"
    }
  }
}

metabase_update_table

Update table display settings.

Args:

tableId: Table ID
displayName: New display name
description: New description
visibilityType: Visibility type

{
  "type": "object",
  "required": [
    "tableId"
  ],
  "properties": {
    "tableId": {
      "type": "number",
      "description": "Table ID"
    },
    "description": {
      "type": "string",
      "description": "Description"
    },
    "displayName": {
      "type": "string",
      "description": "Display name"
    },
    "visibilityType": {
      "type": "string",
      "description": "Visibility type"
    }
  }
}

metabase_get_field

Get details of a specific field by ID.

Args:

fieldId: Field ID
format: Response format

{
  "type": "object",
  "required": [
    "fieldId"
  ],
  "properties": {
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "fieldId": {
      "type": "number",
      "description": "Field ID"
    }
  }
}

metabase_update_field

Update field metadata and settings.

Args:

fieldId: Field ID
displayName: New display name
description: New description
semanticType: Semantic type (e.g., 'type/Email', 'type/URL')
visibilityType: Visibility ('normal', 'details-only', 'sensitive', 'retired')
hasFieldValues: How to handle values ('none', 'list', 'search')

{
  "type": "object",
  "required": [
    "fieldId"
  ],
  "properties": {
    "fieldId": {
      "type": "number",
      "description": "Field ID"
    },
    "description": {
      "type": "string",
      "description": "Description"
    },
    "displayName": {
      "type": "string",
      "description": "Display name"
    },
    "semanticType": {
      "type": "string",
      "description": "Semantic type"
    },
    "hasFieldValues": {
      "enum": [
        "none",
        "list",
        "search"
      ],
      "type": "string",
      "description": "Field values mode"
    }
  }
}

metabase_get_field_values

Get distinct values for a field.

Useful for understanding data distribution and for filter dropdowns.

Args:

fieldId: Field ID

{
  "type": "object",
  "required": [
    "fieldId"
  ],
  "properties": {
    "fieldId": {
      "type": "number",
      "description": "Field ID"
    }
  }
}

metabase_rescan_field_values

Rescan values for a specific field.

Args:

fieldId: Field ID

{
  "type": "object",
  "required": [
    "fieldId"
  ],
  "properties": {
    "fieldId": {
      "type": "number",
      "description": "Field ID"
    }
  }
}

metabase_list_users

List all users in Metabase.

Args:

limit: Maximum users to return (default: 20)
offset: Pagination offset
format: Response format

{
  "type": "object",
  "properties": {
    "limit": {
      "type": "number",
      "default": 20,
      "description": "Maximum users"
    },
    "format": {
      "enum": [
        "json",
        "markdown"
      ],
      "type": "string"
    },
    "offset": {
      "type": "number",
      "default": 0,
      "description": "Pagination offset"
    }
  }
}

metabase_create_user

Create a new user in Metabase.

Requires admin privileges.

Args:

email: User email (required)
firstName: First name
lastName: Last name
password: Initial password
groupIds: Permission group IDs to add user to

{
  "type": "object",
  "required": [
    "email"
  ],
  "properties": {
    "email": {
      "type": "string",
      "description": "Email address"
    },
    "groupIds": {
      "type": "array",
      "items": {
        "type": "number"
      },
      "description": "Permission group IDs"
    },
    "lastName": {
      "type": "string",
      "description": "Last name"
    },
    "password": {
      "type": "string",
      "description": "Initial password"
    },
    "firstName": {
      "type": "string",
      "description": "First name"
    }
  }
}

metabase_update_user

Update an existing user.

Args:

userId: User ID to update
email: New email
firstName: New first name
lastName: New last name
locale: User locale
isSuperuser: Admin status (requires admin)
groupIds: Permission group IDs

{
  "type": "object",
  "required": [
    "userId"
  ],
  "properties": {
    "email": {
      "type": "string",
      "description": "Email"
    },
    "locale": {
      "type": "string",
      "description": "Locale"
    },
    "userId": {
      "type": "number",
      "description": "User ID"
    },
    "groupIds": {
      "type": "array",
      "items": {
        "type": "number"
      },
      "description": "Permission groups"
    },
    "lastName": {
      "type": "string",
      "description": "Last name"
    },
    "firstName": {
      "type": "string",
      "description": "First name"
    },
    "isSuperuser": {
      "type": "boolean",
      "description": "Admin status"
    }
  }
}

metabase_deactivate_user

Deactivate a user account.

The user will be unable to log in but their data is preserved.

Args:

userId: User ID to deactivate

{
  "type": "object",
  "required": [
    "userId"
  ],
  "properties": {
    "userId": {
      "type": "number",
      "description": "User ID"
    }
  }
}

metabase_reactivate_user

Reactivate a deactivated user account.

Args:

userId: User ID to reactivate

{
  "type": "object",
  "required": [
    "userId"
  ],
  "properties": {
    "userId": {
      "type": "number",
      "description": "User ID"
    }
  }
}