Metabase

List all segments in Metabase. Segments are saved filter sets that can be reused in questions. Args: - format: Response format

Get details of a specific user by ID. Args: - userId: User ID - format: Response format

Get the currently authenticated user. Args: - format: Response format

Add or remove a card from favorites. Args: - cardId: Card ID - favorite: true to favorite, false to unfavorite

Remove a card from a dashboard. Args: - dashboardId: Dashboard ID - dashcardId: Dashboard card ID (not the card ID)

Get details of a specific segment. Args: - segmentId: Segment ID - format: Response format

Execute a card's query and return the results. Args: - cardId: Card ID to run - parameters: Query parameters (for parameterized queries) - format: Response format

Delete an alert. Args: - alertId: Alert ID to delete

Unsubscribe the current user from an alert. Args: - alertId: Alert ID

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

List all alerts in Metabase. Alerts notify users when query results meet certain conditions. Args: - archived: Include archived alerts (default: false) - format: Response format

Get all alerts set up for a specific card (question). Args: - cardId: Card ID - format: Response format

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)

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

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')

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

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

Delete (archive) a card. Cards are not permanently deleted but moved to trash. Args: - cardId: Card ID to delete

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')

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

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)

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

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

Get the collection hierarchy as a tree structure. Returns all collections organized in their parent-child relationships. Args: - format: Response format

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')

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

Create a new dashboard in Metabase. Args: - name: Dashboard name (required) - description: Dashboard description - collectionId: Collection to save the dashboard in

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

Delete a dashboard. Args: - dashboardId: Dashboard ID to delete

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)

Create a copy of a dashboard. Args: - dashboardId: Dashboard ID to copy - name: Name for the new dashboard - collectionId: Collection for the new dashboard

Add or remove a dashboard from favorites. Args: - dashboardId: Dashboard ID - favorite: true to favorite, false to unfavorite

List all databases connected to Metabase. Args: - includeTables: Include table information (default: false) - format: Response format ('json' or 'markdown')

Get details of a specific database by ID. Args: - databaseId: The database ID - format: Response format

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

Trigger a sync of a database's metadata. This refreshes Metabase's understanding of the database schema. Args: - databaseId: The database ID

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

Rescan field values for a database. This updates the cached list of values for filter dropdowns. Args: - databaseId: The database ID

Discard cached field values for a database. Args: - databaseId: The database ID

Get all schemas in a database. Args: - databaseId: The database ID

Get all tables in a database, optionally filtered by schema. Args: - databaseId: The database ID - schema: Filter by schema name - format: Response format

List all permission groups in Metabase. Permission groups control access to databases, tables, and features. Args: - format: Response format

Get details of a specific permission group. Args: - groupId: Permission group ID - format: Response format

Create a new permission group. Requires admin privileges. Args: - name: Group name

Delete a permission group. Requires admin privileges. Cannot delete built-in groups. Args: - groupId: Permission group ID

Get the full permissions graph. Shows all database and table permissions for all groups. Requires admin privileges. Args: - format: Response format

Get all user-group memberships. Shows which users belong to which groups. Requires admin privileges.

Add a user to a permission group. Requires admin privileges. Args: - groupId: Permission group ID - userId: User ID

Remove a user from a permission group. Requires admin privileges. Args: - membershipId: Membership ID (from permissions membership endpoint)

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')

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

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

List all Metabase settings. Returns all configurable settings with their current values. Requires admin privileges for most settings. Args: - format: Response format

Get a specific Metabase setting value. Args: - key: Setting key (e.g., 'site-name', 'admin-email')

Update a Metabase setting. Requires admin privileges. Args: - key: Setting key - value: New value

Get recent activity across Metabase. Shows recent user actions like creating cards, viewing dashboards, etc. Args: - format: Response format

Get the current user's recently viewed items. Returns up to 10 most recently viewed cards and dashboards. Args: - format: Response format

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

Update an existing segment. Args: - segmentId: Segment ID - name: New name - description: New description - filter: New filter definition - archived: Archive/unarchive

Delete a segment. Args: - segmentId: Segment ID

List all metrics in Metabase. Metrics are saved aggregations that can be reused in questions. Args: - format: Response format

Get details of a specific metric. Args: - metricId: Metric ID - format: Response format

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

Update an existing metric. Args: - metricId: Metric ID - name: New name - description: New description - aggregation: New aggregation - filter: New filter - archived: Archive/unarchive

Delete a metric. Args: - metricId: Metric ID

List all tables, optionally filtered by database. Args: - databaseId: Filter by database ID (optional) - format: Response format

Get details of a specific table by ID. Args: - tableId: Table ID - format: Response format

Get full metadata for a table including all fields. Args: - tableId: Table ID - format: Response format

Update table display settings. Args: - tableId: Table ID - displayName: New display name - description: New description - visibilityType: Visibility type

Get details of a specific field by ID. Args: - fieldId: Field ID - format: Response format

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')

Get distinct values for a field. Useful for understanding data distribution and for filter dropdowns. Args: - fieldId: Field ID

Rescan values for a specific field. Args: - fieldId: Field ID

List all users in Metabase. Args: - limit: Maximum users to return (default: 20) - offset: Pagination offset - format: Response format

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

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

Deactivate a user account. The user will be unable to log in but their data is preserved. Args: - userId: User ID to deactivate

Reactivate a deactivated user account. Args: - userId: User ID to reactivate