Metabase Ai Assistant
by enessaricommunityv3.2.0
37
6
Metabase AI Assistant is an MCP server that enables users to generate SQL from natural language, create dashboards, manage users, and automate business intelligence workflows.
From the registry: MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL
Install & configure
Prerequisites
- requiredNode.js 18+Node.js version 18 or higher
- requiredMetabase accountMetabase instance URL and API key
Install in your client
Paste into the AI you're chatting with — it will figure out the rest
Please install the `metabase-ai-assistant` MCP server into my current AI client (that's you).
Required prerequisites (do these first if not already done):
- **Node.js 18+** — Node.js version 18 or higher
- **Metabase account** — Metabase instance URL and API key
Canonical MCP server config (stdio transport):
- command: `npx`
- args: ["-y","metabase-ai-assistant"]
- required environment variables:
- `METABASE_URL`: Metabase instance URL (example: `https://your-metabase.com`)
- `METABASE_API_KEY`: Metabase API key (starts with mb_) (example: `<your-api-key>`)
- optional environment variables:
- `METABASE_READ_ONLY_MODE`: Block write operations (default: true) (example: `true`)
- `ANTHROPIC_API_KEY`: For AI SQL generation
- `OPENAI_API_KEY`: For AI SQL generation
- `CACHE_TTL_MS`: Cache TTL in ms (example: `600000`)
Note: Alternative: METABASE_USERNAME + METABASE_PASSWORD instead of METABASE_API_KEY.
Add this MCP server to my current client's config in the correct format for you. If you need secrets or credentials I haven't provided, ASK me — do not invent values or leave raw placeholders. After adding it, tell me how to verify the server is connected.Note: Alternative: METABASE_USERNAME + METABASE_PASSWORD instead of METABASE_API_KEY.
Tools (14)
ai_sql_generate
Natural language → SQL
ai_sql_optimize
Query optimization suggestions
ai_sql_explain
Explain SQL in plain English
ai_relationships_suggest
Suggest table relationships
mb_auto_describe
Auto-generate descriptions
mb_dashboard_template_executive
Executive templates
db_list
List all databases
db_schemas
Get schemas in a database
db_tables
Get tables with fields
sql_execute
Execute SQL queries
mb_question_create
Create new questions
mb_dashboard_create
Create dashboards
mb_user_create
Create users
mb_meta_overview
Instance health check
Environment variables
METABASE_URLrequiredURL of the Metabase instanceMETABASE_API_KEYrequiredAPI key for accessing MetabasePackages
metabase-ai-assistant
npmv3.2.0transport: stdio
Details
- Language
- JavaScript
- License
- Apache-2.0
- Released
- Jan 23, 2026
- Last commit
- Feb 22, 2026
- Registry name
- io.github.enessari/metabase-ai-assistant