Skip to main content

dbt-native dashboarding

A lightweight dashboard layer for analytics engineers

Built for dbt and powered by ggsql. Compile SQL visualisations into static dashboards, no BI server required.

Start with the quickstartBrowse examples
dbtModel pipeline
models/fct_revenue.sqltarget/manifest.json
->
codeCharts as code
visualisations/revenue.ggsqldashboards/executive.yml
->
siteStatic dashboard

No BI server required

Developer workflow

From dbt model to publishable dashboard

1

Build dbt models

Run dbt seed, run, build, or compile so the manifest and warehouse tables are available.

2

Write ggsql

Keep chart SQL next to the dbt project and map result columns to visual roles.

3

Render charts

Generate compiled SQL plus SVG, PNG, and optional Vega-Lite JSON artifacts.

4

Export a site

Publish the generated dashboard folder to any static host or CI artifact store.

Documentation

Find the right entry point quickly

Quickstart

Run the included dbt project and export your first static dashboard.

Command reference

See every CLI command, option, and common workflow.

Technical guide

Understand parsing, dbt artifact resolution, rendering, and export paths.

AI context

Use the docs index and prompts as a starting point for coding agents.

Integrations

Connect dbt-charts to CI, static hosting, and future orchestration workflows.

Migration placeholder

Track the future path for moving Looker dashboards into dbt-charts.

Examples gallery

Use small projects as patterns

Each example includes seeds, dbt models, ggsql visualisations, dashboard YAML, and repeatable commands. Use them as starting points for your own analytics project.

Open gallery
Simple dbtA compact revenue dashboard and chart syntax sampler.Sales dashboardMonthly revenue, channel mix, and regional sales.Product analyticsActive users, activation rate, and plan behavior.Finance metricsBookings, expense share, and gross margin signals.

AI context and agents

Make the project easier for coding assistants to understand

The docs include an AI context section, an llms.txt placeholder, and a future skills placeholder for Codex, Claude, or other coding agents that can help users generate visualisations and dashboards from dbt models.

curl https://dbtcharts.pages.dev/llms.txtuv run dbt-charts doctor --project-dir examples/simple_dbtuv run dbt-charts render --project-dir examples/simple_dbt