Logo
Deploy Now

SaaS Alternative

Looker Power BI Tableau

Categories

Developer Tools Analytics Dashboard Business Intelligence Data Visualization

Stars

6,067

Forks

767

Watchers

34

Developer links

Last Updated: 08-21-2026 01:54 PM (UTC)

LightDash

With 5,600+ GitHub stars and deep dbt integration, Lightdash is the open-source Agentic BI platform that treats analytics like software — defining metrics, dimensions, joins, permissions, and caching in a governed context layer that powers dashboards, AI agents, data apps, embedded analytics, and MCP server endpoints simultaneously. The dbt Write-Back feature lets business users create custom metrics and models in the UI, then automatically generates pull requests in GitHub or GitLab so every change flows through code review and CI validation before reaching production. Context-specific AI analysts automatically select relevant models and metrics, build queries, and present insights in plain English, while row-level security, user attributes, and customer-facing permissions ensure data governance at every layer. The platform connects to BigQuery, Snowflake, Redshift, Databricks, PostgreSQL, Trino, and ClickHouse through warehouse adapters, with the TypeScript monorepo built on React, Mantine, Vite, and TanStack Query on the frontend plus Node.js, Express, Knex, and PostgreSQL on the backend. Data teams build analytics with coding agents, preview changes from the CLI, validate in CI pipelines, and review charts and dashboards in pull requests — making the entire analytics lifecycle version-controlled and reproducible. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. MIT licensed.

LightDash
LightDash
LightDash
LightDash
LightDash

Benefits

  • dbt-Native Analytics as Code
  • Define metrics, dimensions, and joins in your existing dbt project with Git-based version control, CI/CD validation, and pull request review for every analytics change.
  • AI-Powered Self-Service Analytics
  • Context-specific AI analysts automatically select relevant models and metrics, build queries from plain English questions, and present insights without requiring SQL knowledge.
  • Multi-Warehouse Data Access
  • Connect to BigQuery, Snowflake, Redshift, Databricks, PostgreSQL, Trino, and ClickHouse through native warehouse adapters with unified metric definitions across all sources.
  • Enterprise Data Governance
  • Enforce row-level security, user attributes, and customer-facing permissions with a governed context layer controlling all data access across dashboards, agents, and embedded analytics.

Features

  • dbt Write-Back
  • Create custom metrics and models in the UI and automatically push changes to your dbt project as GitHub or GitLab pull requests for governed deployment.
  • Context Layer
  • Define metrics, dimensions, joins, descriptions, caching, and access rules once to power dashboards, AI agents, data apps, and embedded analytics simultaneously.
  • Agentic BI
  • AI agents with context-specific model awareness build queries, present data insights, and enable business users to explore analytics in natural language.
  • Developer CLI
  • Build analytics with coding agents, preview chart changes from the terminal, validate in CI pipelines, and ship dashboards through standard Git workflows.
  • Embedded Analytics
  • Embed governed dashboards and data apps into customer-facing products with SDKs, user attributes, and row-level security maintaining access controls.