lightdash_mcp

Overview

The lightdash_mcp server provides a comprehensive interface for AI assistants to interact with Lightdash, a modern data analytics platform. It exposes tools for data catalog exploration, chart creation and management, dashboard organization, and query execution. The server supports multiple authentication methods including standard API tokens, Cloudflare Access, and Google Cloud Identity-Aware Proxy, making it suitable for various deployment scenarios.

Try asking AI

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

• list-projects

  List all available Lightdash projects

  Try:What projects are available in my Lightdash instance?Try:Show me all the projects I have access to
• get-project

  Get detailed information about a specific project

  Try:Give me details about the 'Sales Analytics' projectTry:Show me information about project UUID 3fc2835f
• list-explores

  List all available explores/tables in a project

  Try:What explores are available in the current project?Try:List all tables in the Marketing project
• get-explore-schema

  Get detailed schema for a specific explore

  Try:Show me the schema for the 'orders' exploreTry:What metrics and dimensions are available in the users table?
• create-chart

  Create a new saved chart with metric query and visualization config

  Try:Create a bar chart showing monthly salesTry:Build a line chart of user growth over time
• get-chart-details

  Get complete configuration of a specific chart

  Try:Show me the details of the 'Monthly Revenue' chartTry:What's the configuration for the customer churn visualization?
• list-dashboards

  List all dashboards in the project

  Try:What dashboards are available?Try:Show me all the dashboards in the Finance project
• create-dashboard

  Create a new dashboard (empty or with tiles)

  Try:Create a new dashboard called 'Q4 Analytics'Try:Build a dashboard with the monthly sales chart
• run-dashboard-tiles

  Execute queries for dashboard tiles (supports bulk execution)

  Try:Run all tiles on the 'Executive Dashboard'Try:Refresh the data for the 'Marketing Performance' dashboard
• create-dashboard-tile

  Add a new tile (chart, markdown, or loom) to a dashboard

  Try:Add the 'Customer Segments' chart to the main dashboardTry:Create a new markdown tile titled 'Notes'
• run-raw-query

  Execute an ad-hoc metric query against any explore

  Try:Run a query to get the top 10 customers by revenueTry:Show me the count of orders by month
• create-space

  Create a new space to organize charts and dashboards

  Try:Create a new space called 'Sales Reports'Try:Organize my charts under a 'Marketing' space

Comparable tools

Installation

pip install lightdash-mcp

{
  "mcpServers": {
    "lightdash": {
      "command": "uvx",
      "args": ["lightdash-mcp"],
      "env": {
        "LIGHTDASH_TOKEN": "ldt_your_token_here",
        "LIGHTDASH_URL": "https://app.lightdash.cloud",
        "LIGHTDASH_PROJECT_UUID": "your-project-uuid"
      }
    }
  }
}

FAQ

How do I get my Lightdash Personal Access Token?

1. Log into your Lightdash instance 2. Go to Settings → Personal Access Tokens 3. Click 'Generate new token' 4. Copy the token (starts with 'ldt_')

Can I use this MCP server with self-hosted Lightdash?

Yes, just set your LIGHTDASH_URL environment variable to your self-hosted instance URL instead of the default Cloud URL.

Compare lightdash_mcp with