AI Agent for Lightdash MCP Server
Seamlessly connect your AI assistants with Lightdash using the Lightdash MCP Server. This integration provides secure, standardized Model Context Protocol (MCP) access to Lightdash APIs, enabling tools like Claude Desktop and other MCP clients to list projects, retrieve charts, dashboards, and custom metrics, and interact programmatically with your analytics data. Unlock secure, efficient, and scalable data workflows for your organization.
Standardized MCP Access to Lightdash
Gain unified and standardized access to your Lightdash data across all projects and dashboards. The Lightdash MCP Server enables AI agents to connect via Model Context Protocol, making analytics data available programmatically to AI assistants, automated workflows, and custom dashboards.
- Unified Project Access.
- List and manage all your Lightdash projects from a single MCP-compatible interface.
- Chart & Dashboard Retrieval.
- Programmatically fetch charts and dashboards, or export them as code for automation.
- Secure API Integration.
- Connect using your Lightdash API Key, ensuring secure and authenticated data flows.
- Custom Metrics & Catalog.
- Retrieve detailed metrics and catalogs programmatically to power your AI analytics.
Flexible Transport Modes & Easy Setup
Deploy the Lightdash MCP Server using Stdio or HTTP transport modes for compatibility with your environment. Enjoy fast setup for Claude Desktop or any MCP-compatible client, with simple configuration and robust security.
- Stdio & HTTP Support.
- Choose between Stdio (default) or HTTP transport for seamless integration into diverse environments.
- Quick Installation.
- Install via Smithery CLI or npm for immediate access, with clear configuration for API keys and endpoints.
- Works with Claude Desktop.
- Optimized for Claude Desktop and compatible MCP clients for AI-driven analytics.
Developer Friendly & Open Source
Accelerate your custom analytics workflows with a developer-first, open source server. Extend, contribute, and automate your Lightdash data flows with robust scripts, examples, and community-driven improvements.
- Open Source Extensibility.
- Contribute, extend, and automate with community-driven scripts and examples.
- Dev-Friendly Scripts.
- Run, test, and fix with built-in scripts for development, linting, and building.
MCP INTEGRATION
Available Lightdash MCP Integration Tools
The following tools are available as part of the Lightdash MCP integration:
- 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.
Connect AI Assistants to Your Lightdash Data Instantly
Deploy the Lightdash MCP Server to enable seamless, standardized access to your Lightdash analytics for AI tools and assistants. Start integrating in minutes—no custom code needed.
What is Lightdash
Lightdash is an open-source business intelligence (BI) platform designed to help data teams become more productive by making analytics accessible and self-serve. Built specifically to work natively with dbt (data build tool), Lightdash empowers analysts to turn their dbt projects into full-featured BI dashboards, reports, and exploration tools without the need for traditional ETL or complex setup. The platform provides both a free self-hosted version and a cloud option, enabling organizations of all sizes to build, visualize, and share data insights with robust data governance. Lightdash supports collaborative analytics, real-time metrics, and is trusted by data-driven companies to empower business users with data without bottlenecking on engineering.
Capabilities
What we can do with Lightdash
With Lightdash, users can connect their dbt projects, create rich dashboards, and provide interactive analytics to business users. The platform enables self-serve data exploration, real-time reporting, and seamless collaboration between analysts and stakeholders, making it easier to drive data-informed decisions.
- Connect dbt projects
- Seamlessly integrate with your existing dbt models for instant analytics.
- Build dashboards
- Create, customize, and share interactive dashboards for a variety of business needs.
- Self-serve analytics
- Empower business users to explore data and generate their own insights without SQL expertise.
- Collaborate on insights
- Share, comment, and iterate on reports and dashboards with your team in real time.
- Data governance
- Maintain robust control over metrics and data definitions for consistent and reliable reporting.
How AI agents can benefit from Lightdash
AI agents can leverage Lightdash to access structured, governed, and real-time business data, enabling them to generate accurate analytics, automate reporting, and support decision-making processes. With programmatic access to Lightdash's BI capabilities, AI agents can help scale analytics operations, generate insights, and facilitate data-driven actions across organizations.