metabase-ai-assistant

Generate schema-aware SQL from natural language and automate Metabase dashboards and reports.

1|Updated Apr 6, 2026
One-click install
npx skills add https://github.com/pkoka888/server-infra-templates --skill metabase-ai-assistant
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: metabase-ai-assistant
Source: https://github.com/pkoka888/server-infra-templates/tree/main/.kilo/skills/metabase-ai-assistant
Command: npx skills add https://github.com/pkoka888/server-infra-templates --skill metabase-ai-assistant

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Enables non-expert users and analysts to translate natural language requests into schema-aware SQL and automate dashboard and report creation in Metabase, reducing manual query writing and repetitive dashboard tasks.

Core Features & Use Cases

  • SQL generation and optimization: Produce and refine SQL from plain English, validate and explain queries against your schema.
  • Dashboard and question automation: Create, update, and delete dashboards and questions, assemble visualizations, and set up scheduled reports.
  • Administration and integration: List and manage databases, tables, users, and collections and integrate with Claude, Cursor, and ChatGPT for AI-driven assistance.
  • Use Case: Ask for a daily sales report and automatically generate the underlying questions, visuals, and a dashboard with scheduled notifications.

Quick Start

Use the metabase-ai-assistant to generate a SQL query counting users by signup date and create a dashboard with sales metrics.

Frequently Asked Questions about metabase-ai-assistant

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate SQL queries from natural language for Metabase?

You can generate SQL from natural language by using an AI assistant that translates plain English into schema-aware SQL, validates the queries against your database, and automates Metabase dashboard creation. This requires API key access to your Metabase instance.

Can I automate Metabase dashboard creation and scheduled reporting?

Yes, you can automate Metabase dashboard creation by generating underlying questions and visualizations from natural language and setting up scheduled reporting. This handles the creation, updating, and deletion of dashboards to streamline your BI workflows.

Does the Metabase AI assistant require PostgreSQL to generate SQL?

Schema-aware SQL generation and dashboard automation require a Metabase instance connected to PostgreSQL. You also need Metabase API access via an API key to manage databases, tables, and execute queries.

What is the best way to manage Metabase collections and users via API?

The best way to manage Metabase collections and users is through API key access that supports listing, creating, and updating resources. This allows you to automate administrative tasks alongside dashboard and question generation.

Can I integrate Metabase dashboard automation with Claude or ChatGPT?

You can integrate Metabase dashboard automation with Claude, Cursor, and ChatGPT for AI-driven assistance. This allows you to generate SQL, create visualizations, and manage reporting workflows directly within your preferred AI interface.

Why use an AI assistant for SQL generation instead of writing Metabase questions manually?

Using an AI assistant for SQL generation reduces manual query writing and repetitive dashboard tasks by translating natural language requests into schema-aware SQL. It automatically assembles visualizations and scheduled reports, saving time for non-expert users and analysts.