List all saved questions/cards in Metabase.

Returns: Dictionary containing all cards with their metadata.

Get detailed information about a specific card/question.

Args: card_id: The ID of the card to retrieve.

Returns: Dictionary with full card metadata including query, visualization settings, and collection info.

Execute a saved Metabase question/card and retrieve results.

Args: card_id: The ID of the card to execute. parameters: Optional parameters for the card execution.

Returns: Card execution results.

Create a new question/card in Metabase.

Args: name: Name of the card. database_id: ID of the database to query. query: SQL query for the card. description: Optional description. collection_id: Optional collection to place the card in. visualization_settings: Optional visualization configuration.

Returns: The created card object.

Update an existing card/question in Metabase.

Args: card_id: The ID of the card to update. name: New name for the card. description: New description. query: New SQL query (requires database_id). database_id: Database ID for the query. collection_id: Move card to this collection. visualization_settings: New visualization configuration.

Returns: The updated card object.

Archive a card/question in Metabase (soft delete).

This sets the card's archived status to true, which hides it from normal views but preserves the data. Safer than permanent deletion.

Args: card_id: The ID of the card to archive.

Returns: The updated card object with archived status.

List all collections in Metabase.

Returns: Dictionary containing all collections with their metadata.

List items inside a specific collection.

Args: collection_id: The ID of the collection to browse. models: Optional filter for item types (e.g., ["card", "dashboard", "collection"]).

Returns: Dictionary containing the items in the collection.

Create a new collection in Metabase.

Args: name: Name of the collection. description: Optional description. color: Optional color for the collection. parent_id: Optional parent collection ID.

Returns: The created collection object.

List all dashboards in Metabase.

Returns: A list of dashboard metadata dictionaries.

Get detailed information about a specific dashboard.

Args: dashboard_id: The ID of the dashboard.

Returns: Dictionary with full dashboard metadata including cards, parameters, and layout.

Create a new dashboard in Metabase.

Args: name: Name of the dashboard. description: Optional description. collection_id: Optional collection to place the dashboard in. parameters: Optional dashboard filter parameters.

Returns: The created dashboard object.

Update an existing dashboard in Metabase.

Args: dashboard_id: The ID of the dashboard to update. name: New name for the dashboard. description: New description. collection_id: Move dashboard to this collection. parameters: New dashboard filter parameters.

Returns: The updated dashboard object.

Delete a dashboard from Metabase.

Args: dashboard_id: The ID of the dashboard to delete.

Returns: Confirmation of the deletion.

List all databases configured in Metabase.

Returns: A dictionary containing all available databases with their metadata.

List all tables in a specific database.

Args: database_id: The ID of the database to query.

Returns: Formatted markdown table showing table details.

Get all fields/columns in a specific table.

Args: table_id: The ID of the table. limit: Maximum number of fields to return (default: 20).

Returns: Dictionary with field metadata, truncated if necessary.

Get detailed information about a specific database.

Args: database_id: The ID of the database.

Returns: Dictionary with full database metadata including engine, features, and settings.

List all schemas in a specific database.

Args: database_id: The ID of the database.

Returns: A list of schema names available in the database.

List all tables within a specific schema of a database.

Args: database_id: The ID of the database. schema_name: The name of the schema.

Returns: A list of table metadata dictionaries for the given schema.

Execute a native SQL query against a Metabase database.

Args: database_id: The ID of the database to query. query: The SQL query to execute. native_parameters: Optional parameters for the query.

Returns: Query execution results.

Search across Metabase entities by keyword.

Searches cards (questions), dashboards, collections, and tables for matching results.

Args: query: The search keyword or phrase. models: Optional filter for entity types (e.g., ["card", "dashboard", "collection", "table"]).

Returns: Dictionary containing search results with matched entities.