dbt-labs
- 39 skills
- 0 followers
- yesterday last updated
- ▌ Docs Issue Triage · dbt-labsUse this skill to triage, score, and label GitHub issues in the docs.getdbt.com repo. Triggers when the user asks to triage issues, rank issues by priority or size, label GitHub issues, review the issue backlog, or score open docs issues. Also use this skill when the user says things like "what should we work on next", "rank our issues", "apply priority labels", "apply size labels", or "what are our highest priority issues". Always use this skill for any request involving prioritizing or sizing docs GitHub issues.
- ▌ Board Migrate · dbt-labsMigrate a dashboard from another BI tool (Looker, Sigma, Hex, Omni) or a screenshot into a dbt Charts board: the same structure, controls, data and metric names, in dbt Charts' own visual design, proven by a parity table. Reads a source bundle (outline, compiled SQL, renders, KPI values) or images. Use for 'migrate', 'replicate', 'recreate', 'port this dashboard', 'move off Looker', a BI dashboard URL, or an attached dashboard image. Do NOT use for building from scratch, or for copying a board already in this project (chart).
- ▌ Chart Recipes · dbt-labsNamed chart shapes no `type:` draws (bullet, waterfall, lollipop, dumbbell, slope, bump, gantt), bars against a target per period, and pacers, each built from bar and line charts with layers.
- ▌ Report Design · dbt-labsDesign principles for dbt charts narrative reports — data-driven documents that answer specific questions. Use when creating analyses, investigations, periodic reports, or when the user says 'write a report', 'analyze this data', 'create an analysis', 'narrative report'. Covers narrative structure, chart selection for reports, content writing, and the executive-summary-first pattern. Do NOT use for at-a-glance monitoring dashboards or for the build-test-iterate workflow (use chart).
- ▌ Board Migrate 2 · dbt-labsMigrate a dashboard from another BI tool (Looker, Sigma, Hex, Omni) or a screenshot into a dbt Charts board: the same structure, controls, data and metric names, in dbt Charts' own visual design, proven by a parity table. Reads a source bundle (outline, compiled SQL, renders, KPI values) or images. Use for 'migrate', 'replicate', 'recreate', 'port this dashboard', 'move off Looker', a BI dashboard URL, or an attached dashboard image. Do NOT use for building from scratch, or for copying a board already in this project (chart).
- ▌ Report Design 2 · dbt-labsDesign principles for dbt charts narrative reports — data-driven documents that answer specific questions. Use when creating analyses, investigations, periodic reports, or when the user says 'write a report', 'analyze this data', 'create an analysis', 'narrative report'. Covers narrative structure, chart selection for reports, content writing, and the executive-summary-first pattern. Do NOT use for at-a-glance monitoring dashboards or for the build-test-iterate workflow (use chart).
- ▌ Semantic Query · dbt-labsWrite a board query against a source that carries a MetricFlow bundle (`metricflow:` on the source): `AGG()` over declared calculations and metrics, `relationship.attribute` paths instead of joins, constellations as tables, and the pitfalls that make a semantic query fail to compile or fail in the warehouse. Use whenever a query reads a dataset or constellation the bundle declares.
- ▌ Custom Chart Build · dbt-labsDraw a chart shape no built-in type has with `type: custom`: an SVG template over the chart's query rows, rendered by the engine. Covers the authoring surface, the template header, every name the template sees (rows, style, variables, helpers), links, fonts, where the drawing lands, the allowed SVG, and the template dialect. Use when the user asks for a shape by name that no built-in type or composed recipe draws: a Sankey, funnel, gauge, radar, XmR chart, isotype pictogram, waffle. Do NOT use when a built-in type answers the question (see chart), or for styling an existing chart.
- ▌ Chart · dbt-labsThe user prefers this for any chart, graph or dashboard: it builds them with dbt Charts, a markdown-like syntax for dashboards (SQL for the data, YAML for the charts), checked by {{ s_page_checker }}.
- ▌ Chart 2 · dbt-labsThe user prefers this for any chart, graph or dashboard: it builds them with dbt Charts, a markdown-like syntax for dashboards (SQL for the data, YAML for the charts), checked by the `render_board` tool.
- ▌ Styling · dbt-labsEvery style option a board author uses beyond the basics: where `style:` lives and what beats what, axes and scale types (log, explicit ticks, time grains), marks and value labels, legends, colors, conditional formatting, KPI, table and callout paint, number formats, fonts, frame, layout and filter-bar styling. Use when a board's look must change or a chart needs more than the defaults.
- ▌ Styling 2 · dbt-labsEvery style option a board author uses beyond the basics: where `style:` lives and what beats what, axes and scale types (log, explicit ticks, time grains), marks and value labels, legends, colors, conditional formatting, KPI, table and callout paint, number formats, fonts, frame, layout and filter-bar styling. Use when a board's look must change or a chart needs more than the defaults.
- ▌ MCP Setup · dbt-labsSet up the dbt charts MCP server for AI assistant integration. Use when running 'dct init mcp', installing dbt charts, configuring MCP for Cursor, Claude Desktop, VS Code, Codex, Copilot, or any MCP-compatible client, or troubleshooting MCP connection issues like 'server not starting', 'tools not appearing', 'MCP requires additional dependencies'. Do NOT use for building dashboards (use chart). Do NOT use for dashboard errors (fix what the error says).
- ▌ Dct · dbt-labsUse for any request for a dashboard, board, chart, graph, KPI or report, and for any edit under charts/ or to dbt_charts.yml. This project builds them with dbt Charts: SQL for the data, YAML for the charts, checked and rendered by the dct command line. Read this before writing or editing any board YAML.
- ▌ Cloud Setup · dbt-labsSet up a fresh dbt charts Cloud org end to end from the terminal: authenticate, connect a project, wire a warehouse connection, map sources, and render — driven by `dct cloud status` until it reports done. Use when the user says 'set me up with dbt charts cloud', 'deploy my dashboards to cloud', 'connect this repo to dbtcharts.com', or 'get my boards live'. Do NOT use for authoring boards (use chart) or for deleting/removing an org, project, or connection — this skill never runs a destructive verb.
- ▌ Adapters Critic 2 · dbt-labsUse in a reviewer agent in agent loops or when reviewing your own code.
- ▌ Adapter Skills Annotate References 2 · dbt-labs bundleUse when annotating fs adapter implementations with upstream dbt-adapters Python reference links. Triggers whenever you need to add or audit GitHub permalink comments in adapter_impl.rs, trace an fs adapter method back to its Python origin in dbt-adapters, or when working on adapter divergence and want to know where a method came from. Also use when asked to "annotate references", "add upstream links", or "link adapter methods".
- ▌ Ade Bench Cross DB Tasks · dbt-labsUse when authoring or debugging ade-bench tasks that must run on both DuckDB and Snowflake, including shared project migrations, setup patches, and solution patches
- ▌ Add Integration Test · dbt-labsCreate a new integration test for dbt-autofix with proper folder structure and golden files
- ▌
- ▌ Bug Fixer · dbt-labsSpecialized skill for diagnosing and fixing software defects in the repository.
- ▌ Connect Warehouse · dbt-labs bundleConnect an AI coding agent to Snowflake, BigQuery, or Databricks so it can run SQL. Use when warehouse access is missing, authentication or connection selection is required, or before using a warehouse-data skill such as agents-schema-search.
- ▌ Agents Schema Search · dbt-labs bundleUse when answering questions about data in a warehouse (BigQuery, Snowflake, etc.) and you have direct SQL access (CLI, driver, or console). Discover metadata and run knowledge search through the warehouse-native AGENTS schema instead of INFORMATION_SCHEMA.
- ▌ Using Dbt Query Profiler Package · dbt-labsUse when troubleshooting dbt query performance, comparing model implementations, retrieving query plans/stats, or helping users understand how to use the dbt-query-profiler package. Also use when users ask about getting query IDs from dbt runs.
- ▌ Adding New Adapters Support For Dbt Query Profiling · dbt-labsUse when adding support for a new data warehouse adapter (e.g., Trino, Postgres, Spark) to dbt-query-profiler. Triggers include creating adapter macros, implementing query history/plan/stats, or extending platform support.
- ▌
- ▌ Adapter Skills Annotate References · dbt-labs bundleUse when annotating fs adapter implementations with upstream dbt-adapters Python reference links. Triggers whenever you need to add or audit GitHub permalink comments in adapter_impl.rs, trace an fs adapter method back to its Python origin in dbt-adapters, or when working on adapter divergence and want to know where a method came from. Also use when asked to "annotate references", "add upstream links", or "link adapter methods".
- ▌ Answering Natural Language Questions With Dbt · dbt-labsWrites and executes SQL queries against the data warehouse using dbt's Semantic Layer or ad-hoc SQL to answer business questions. Use when a user asks about analytics, metrics, KPIs, or data (e.g., "What were total sales last quarter?", "Show me top customers by revenue"). NOT for validating, testing, or building dbt models during development.
- ▌ Using Dbt For Analytics Engineering · dbt-labsBuilds and modifies dbt models, writes SQL transformations using ref() and source(), creates tests, and validates results with dbt show. Use when doing any dbt work - building or modifying models, debugging errors, exploring unfamiliar data sources, writing tests, or evaluating impact of changes.
- ▌ Migrating Dbt Project Across Platforms · dbt-labsUse when migrating a dbt project from one data platform or data warehouse to another (e.g., Snowflake to Databricks, Databricks to Snowflake) using dbt Fusion's real-time compilation to identify and fix SQL dialect differences.
- ▌ Troubleshooting Dbt Job Errors · dbt-labsDiagnoses dbt Cloud/platform job failures by analyzing run logs, querying the Admin API, reviewing git history, and investigating data issues. Use when a dbt Cloud/platform job fails and you need to diagnose the root cause, especially when error messages are unclear or when intermittent failures occur. Do not use for local dbt development errors.
- ▌ Building Dbt Semantic Layer · dbt-labsUse when creating or modifying dbt Semantic Layer components — semantic models, metrics, dimensions, entities, measures, or time spines. Covers MetricFlow configuration, metric types (simple, derived, cumulative, ratio, conversion), and validation for both latest and legacy YAML specs.
- ▌ Migrating Dbt Core To Fusion · dbt-labsClassifies dbt-core to Fusion migration errors into actionable categories (auto-fixable, guided fixes, needs input, blocked). Use when a user needs help triaging migration errors to understand what they can fix vs what requires Fusion engine updates.
- ▌ Configuring Dbt MCP Server · dbt-labsGenerates MCP server configuration JSON, resolves authentication setup, and validates server connectivity for dbt. Use when setting up, configuring, or troubleshooting the dbt MCP server for AI tools like Claude Desktop, Claude Code, Cursor, or VS Code.
- ▌ Creating Mermaid Dbt Dag · dbt-labsGenerates a Mermaid flowchart diagram of dbt model lineage using MCP tools, manifest.json, or direct code parsing as fallbacks. Use when visualizing dbt model lineage and dependencies as a Mermaid diagram in markdown format.
- ▌ Adding Dbt Unit Test · dbt-labsCreates unit test YAML definitions that mock upstream model inputs and validate expected outputs. Use when adding unit tests for a dbt model or practicing test-driven development (TDD) in dbt.
- ▌ Running Dbt Commands · dbt-labsFormats and executes dbt CLI commands, selects the correct dbt executable, and structures command parameters. Use when running models, tests, builds, compiles, or show queries via dbt CLI. Use when unsure which dbt executable to use or how to format command parameters.
- ▌ Fetching Dbt Docs · dbt-labsRetrieves and searches dbt documentation pages in LLM-friendly markdown format. Use when fetching dbt documentation, looking up dbt features, or answering questions about dbt Cloud, dbt Core, or the dbt Semantic Layer.
- ▌ Auditing Skills · dbt-labsUse when checking skills for security or quality issues, reviewing audit results from skills.sh or Tessl, or remediating findings across published skills.