metabase-mcp-server

metabase-mcp-server

7
communicationdatabases

Metabase MCP Server is a TypeScript-based server that integrates AI assistants with the Metabase analytics platform using the Model Context Protocol. It provides tools for seamless access and control of Metabase data through conversational AI and supports different authentication methods.

Metabase MCP Server

A Model Context Protocol server that integrates AI assistants with Metabase analytics platform.

Key Features

  • Resource Access: Navigate Metabase resources via intuitive URIs
  • Two Authentication Methods: Support for session-based and API key authentication
  • Structured Data Access: JSON-formatted responses for AI assistants
  • Comprehensive Logging: Detailed logging for debugging and monitoring
  • Error Handling: Robust error handling with clear error messages

Available Tools

  • list_dashboards: Retrieve all available dashboards
  • list_cards: Get saved questions/cards
  • list_databases: View connected database sources
  • execute_card: Run saved questions with optional parameters
  • get_dashboard_cards: Extract all cards from a specific dashboard
  • execute_query: Execute custom SQL queries

Configuration

Supports Username/Password and API Key Authentication. API Key is recommended for production environments.

Prerequisites

Node.js 18.0.0 or higher, an active Metabase instance.

Installation

Install dependencies, build the project, start the server, or use Docker.

Security Considerations

Use API key for production, keep credentials secure, and apply network security measures.