metabase-ai-assistant
Verified Safeby enessari
Overview
The Metabase AI Assistant integrates an AI agent with Metabase to enable AI-powered data exploration, SQL generation, dashboard creation, and Metabase instance management through an MCP client.
Installation
npm run mcpEnvironment Variables
- METABASE_URL
- METABASE_USERNAME
- METABASE_PASSWORD
- METABASE_API_KEY
- ANTHROPIC_API_KEY
- OPENAI_API_KEY
- MB_METADATA_ENABLED
- MB_METADATA_ENGINE
- MB_METADATA_HOST
- MB_METADATA_PORT
- MB_METADATA_DATABASE
- MB_METADATA_USER
- MB_METADATA_PASSWORD
- MB_METADATA_SSL
- METABASE_EMBEDDING_SECRET_KEY
- LOG_LEVEL
- AI_PROVIDER
Security Notes
The server implements robust security controls for direct database (DDL) operations, including enforced naming prefixes (claude_ai_), explicit approval requirements, dry-run modes, and blacklisting of dangerous SQL commands (e.g., DROP DATABASE, TRUNCATE). The Metabase metadata client is explicitly read-only. Environment variables are used for credentials, preventing hardcoding. A minor theoretical risk exists from `JSON.parse` operations on AI-generated content, though AI models are typically constrained to valid JSON output.
Similar Servers
DBchat
Transforms a database into an intelligent conversational partner, enabling natural language queries, instant answers, and data visualizations via MCP clients.
metabase-mcp-server
Enables AI assistants to interact with and manage Metabase's analytics platform by providing comprehensive API access through a Model Context Protocol server.
vcon-mcp
The vCon MCP Server stores, manages, and provides advanced search and AI/ML analysis capabilities for IETF vCon (Virtual Conversation) objects, supporting multi-tenancy and extensibility via plugins.
dx-mcp-server
Empowers AI applications to interact with and query a user-provided Postgres database via the Model Context Protocol (MCP).