Lightdash MCP Server

Data Science ToolsTypeScript

Access and query your Lightdash analytics data

Available Tools

list_projects

List all projects in the Lightdash organization

get_project

Get details of a specific project

list_spaces

List all spaces in a project

list_charts

List all charts in a project

list_dashboards

List all dashboards in a project

get_custom_metrics

Get custom metrics for a project

get_catalog

Get catalog for a project

get_metrics_catalog

Get metrics catalog for a project

get_charts_as_code

Get charts as code for a project

get_dashboards_as_code

Get dashboards as code for a project

Lightdash MCP Server provides AI assistants with direct access to your Lightdash analytics platform. This integration allows AI to explore projects, spaces, charts, dashboards, and metrics in your Lightdash instance, enabling data-driven conversations and insights without leaving your AI assistant.

Overview

Lightdash MCP Server creates a bridge between AI assistants and your Lightdash analytics platform. This integration enables AI to access your business data and metrics directly through the Lightdash API, making it possible to have data-informed conversations without switching contexts.

Installation

Option 1: Install via Smithery (Recommended for Claude Desktop)

The easiest way to install Lightdash MCP Server is through Smithery:

npx -y @smithery/cli install lightdash-mcp-server --client claude

Option 2: Manual Installation

Install the package:

npm install lightdash-mcp-server

Start the server:

npx lightdash-mcp-server

Configuration

To connect to your Lightdash instance, you'll need to configure the following environment variables:

LIGHTDASH_API_KEY: Your Lightdash Personal Access Token (PAT)
LIGHTDASH_API_URL: Your Lightdash API base URL (e.g., "https://app.lightdash.cloud/api/v1")

MCP Configuration

Add the following configuration to your AI assistant's MCP configuration:

"lightdash": {
  "command": "npx",
  "args": [
    "-y",
    "lightdash-mcp-server"
  ],
  "env": {
    "LIGHTDASH_API_KEY": "your-lightdash-pat",
    "LIGHTDASH_API_URL": "https://your-lightdash-instance/api/v1"
  }
}

Usage

Once configured, your AI assistant can access your Lightdash data through various tools. For example:

List all projects in your Lightdash organization
Explore charts and dashboards within a project
View metrics and catalog information
Access chart and dashboard configurations

The AI can now answer questions about your data, help analyze metrics, and provide insights based on your Lightdash analytics.

Development

If you want to contribute or modify the server:

Clone the repository
Install dependencies: npm install
Run in development mode: npm run dev
Build for production: npm run build

For more information, visit the GitHub repository.