lightdash_mcp

概述

lightdash_mcp 服务器为 AI 助手提供与 Lightdash 现代数据分析平台的全面接口。它支持数据目录探索、图表创建和管理、仪表板组织以及查询执行等功能。服务器支持多种身份验证方法，包括标准 API 令牌、Cloudflare 访问和 Google Cloud 身份感知代理，适用于各种部署场景。

试试问 AI

装完之后，这里有 5 个你可以让 AI 做的事：

• list-projects

  List all available Lightdash projects

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

  Get detailed information about a specific project

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

  List all available explores/tables in a project

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

  Get detailed schema for a specific explore

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

  Create a new saved chart with metric query and visualization config

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

  Get complete configuration of a specific chart

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

  List all dashboards in the project

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

  Create a new dashboard (empty or with tiles)

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

  Execute queries for dashboard tiles (supports bulk execution)

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

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

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

  Execute an ad-hoc metric query against any explore

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

  Create a new space to organize charts and dashboards

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

可对比工具

安装

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

如何获取我的 Lightdash 个人访问令牌？

1. 登录您的 Lightdash 实例 2. 转到 设置 → 个人访问令牌 3. 点击 '生成新令牌' 4. 复制令牌（以 'ldt_' 开头）

我可以将此 MCP 服务器与自托管 Lightdash 一起使用吗？

是的，只需将您的 LIGHTDASH_URL 环境变量设置为您的自托管实例 URL，而不是默认的云 URL。

lightdash_mcp 对比