Lightdash

Open-source BI tool built for dbt users, enabling self-serve analytics from dbt models.

MCPCLI

About Lightdash

Open-source BI tool built for dbt users, enabling self-serve analytics from dbt models. Explore how Lightdash integrates with the agentic data stack ecosystem and supports autonomous data operations.

Key Features

  • Native dbt integration (reads dbt YAML definitions and compiled manifests as Explores)
  • Semantic layer built on dbt metrics — define metrics once, use everywhere
  • Self-serve data exploration with drill-down for non-technical users
  • AI-powered natural language queries with automatic visualizations
  • Developer-first CLI workflow for compile, validate, preview, and deploy
  • Dashboard and chart embedding with expirable URLs and tokens
  • Role-based access control with user groups and personal tokens
  • SQL runner for ad-hoc data cleansing and preparation

Agent Integration

CLI — lightdash

$ npm install -g @lightdash/cli
CLI Documentation

External Links

Lightdash MCP Server

MCP server with tools for projects, spaces, charts, dashboards, metrics catalog

REST API Reference

Official OpenAPI docs for all Lightdash API endpoints with Personal Access Token auth

Lightdash AI Agents

Official page on Lightdash's AI agent capabilities built on the dbt semantic layer

CLI Reference

Official CLI docs for compile, generate, deploy, preview, validate commands

API Examples

Official repository with Python and JavaScript examples for using the Lightdash API

← Back to BI Tools