lightdash-mcp-server

Overview

This MCP server bridges AI assistants with Lightdash, a business intelligence platform, by exposing various tools for data exploration and visualization. It enables AI systems to list projects, access charts and dashboards, retrieve custom metrics, and get data catalog information through Lightdash's API. The server supports both stdio and HTTP transport modes, making it flexible for different integration scenarios.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• list_projects

  List all projects in the Lightdash organization

  Try:Show me all projects in LightdashTry:List available projects
• get_project

  Get details of a specific project

  Try:Get details for the sales projectTry:Show me information about the marketing project
• list_spaces

  List all spaces in a project

  Try:What spaces are in the finance project?Try:Show me all spaces in the current project
• list_charts

  List all charts in a project

  Try:Show me all charts in the dashboardTry:List the available charts in the project
• list_dashboards

  List all dashboards in a project

  Try:What dashboards are available?Try:List all dashboards in the organization
• get_custom_metrics

  Get custom metrics for a project

  Try:Show me custom metrics for the sales projectTry:What custom metrics are defined?
• get_catalog

  Get catalog for a project

  Try:Show me the data catalogTry:Get the full catalog for the finance project
• get_metrics_catalog

  Get metrics catalog for a project

  Try:What metrics are available?Try:Show me the metrics catalog
• get_charts_as_code

  Get charts as code for a project

  Try:Export the charts as codeTry:Show me the code for all charts
• get_dashboards_as_code

  Get dashboards as code for a project

  Try:Export dashboards as codeTry:Show me the code for all dashboards

Comparable tools

Installation

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

npm install lightdash-mcp-server

{
  "lightdash": {
    "command": "npx",
    "args": [
      "-y",
      "lightdash-mcp-server"
    ],
    "env": {
      "LIGHTDASH_API_KEY": "<your PAT>",
      "LIGHTDASH_API_URL": "https://<your base url>"
    }
  }
}

FAQ

What is Lightdash?

Lightdash is an open-source BI platform for building and sharing analytics dashboards directly from your dbt project.

How do I get my Lightdash API key?

Your API key can be generated in Lightdash under User Settings > Personal Access Tokens.

Compare lightdash-mcp-server with