Data Metabase

What it does

This skill enables AI agents to interact with a Metabase instance via its API, allowing for automated creation and modification of reports (cards), dashboards, and chart settings. It supports authentication using an API key (preferred) or username/password credentials. The skill facilitates discovery of necessary IDs within the Metabase environment, promoting automation across different configurations.

When to use it

• Automating the generation of recurring data reports in Metabase.
• Creating new dashboards and populating them with specific charts and visualizations.
• Updating chart settings (display and visualization) programmatically.
• Managing a large number of Metabase cards and dashboards across multiple environments.

Key capabilities

• Automated creation and modification of Metabase reports ("cards").
• Creation and updating of Metabase dashboards.
• Configuration of chart display and visualization settings.
• API authentication using API key or username/password.
• Discovery of IDs (collection, database, source-table) within a Metabase instance.

Example prompts

• "Create a new dashboard in Metabase called 'Sales Performance' with a card showing monthly revenue."
• "Update the visualization settings for the existing 'Website Traffic' card to use a line chart."
• "Generate a report that displays the average order value from the last quarter."

Tips & gotchas

• Authentication: Prioritize using an API key for authentication. Avoid committing sensitive credentials like passwords or session tokens.
• ID Discovery: Do not hardcode IDs; use discovery methods to ensure compatibility across different Metabase environments.
• Serialization (Pro/Enterprise): For large-scale migrations, consider utilizing Metabase's serialization feature if you are on a Pro or Enterprise plan.