Fire in da houseTop Tip:Paying $100+ per month for Perplexity, MidJourney, Runway, ChatGPT and other tools is crazy - get all your AI tools in one site starting at $15 per month with Galaxy AI Fire in da houseCheck it out free

lightdash-mcp-server

MCP.Pizza Chef: syucream

The lightdash-mcp-server is a Model Context Protocol (MCP) server that enables AI assistants to interact seamlessly with Lightdash, a modern analytics platform. By exposing Lightdash's API through the MCP standard, this server allows models to query and retrieve data about projects, spaces, and charts within a Lightdash organization. It supports tools such as listing projects, fetching project details, and enumerating spaces and charts, facilitating real-time, structured access to analytics data. This integration empowers developers to build AI-enhanced workflows and copilots that can analyze and manipulate Lightdash data securely and efficiently.

Use This MCP server To

List all projects in a Lightdash organization Retrieve detailed information about a specific project Enumerate all spaces within a Lightdash project List all charts available in a project space Enable AI assistants to query Lightdash analytics data Integrate Lightdash data into AI-driven workflows Provide real-time access to Lightdash API via MCP

README

lightdash-mcp-server

smithery badge npm version

A MCP(Model Context Protocol) server that accesses to Lightdash.

This server provides MCP-compatible access to Lightdash's API, allowing AI assistants to interact with your Lightdash data through a standardized interface.

Lightdash Server MCP server

Features

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

Quick Start

Installation

Installing via Smithery

To install Lightdash MCP Server for Claude Desktop automatically via Smithery:

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

Configuration

  • LIGHTDASH_API_KEY: Your Lightdash PAT
  • LIGHTDASH_API_URL: The API base URL

Usage

  1. Start the MCP server.

Directly:

npx lightdash-mcp-server

Or, run the installed module with node.

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

Development

Available Scripts

  • npm run dev - Start the server in development mode with hot reloading
  • npm run build - Build the project for production
  • npm run start - Start the production server
  • npm run lint - Run linting checks (ESLint and Prettier)
  • npm run fix - Automatically fix linting issues
  • npm run examples - Run the example scripts

Contributing

  1. Fork the repository
  2. Create your feature branch
  3. Run tests and linting: npm run lint
  4. Commit your changes
  5. Push to the branch
  6. Create a Pull Request

lightdash-mcp-server FAQ

How do I install the lightdash-mcp-server?
You can install it via npm using 'npm install lightdash-mcp-server'.
How does lightdash-mcp-server authenticate with Lightdash?
It uses API keys or tokens configured in the server environment to securely access Lightdash data.
Can I use lightdash-mcp-server with multiple Lightdash organizations?
Yes, it supports accessing multiple organizations by configuring the appropriate API credentials for each.
What tools does lightdash-mcp-server provide?
It offers tools like list_projects, get_project, list_spaces, and list_charts to interact with Lightdash data.
Is lightdash-mcp-server compatible with different LLM providers?
Yes, it works with any MCP-compatible LLM host, including OpenAI, Anthropic Claude, and Google Gemini.
How do I update the lightdash-mcp-server to the latest version?
Use npm to update by running 'npm update lightdash-mcp-server'.
Can I extend lightdash-mcp-server with custom tools?
Currently, it supports predefined tools, but you can contribute or fork the project to add custom functionality.
Does lightdash-mcp-server support real-time data updates?
It accesses Lightdash data via API calls, so it reflects the latest data available at request time.