dbt Charts: Open-source YAML for AI-generated dashboards
Declarative language brings governance to AI-built analytics
1AI analytics governance gap
Current AI-generated dashboards create maintenance headaches by producing scattered HTML/CSS/JS files. dbt Charts solves this with a unified YAML format that keeps all dashboard logic in one auditable file. The language works natively with SQL queries while adding visualization controls, enabling teams to maintain governance as AI agents handle more dashboard creation.
2BI's evolution to code
BI tools historically bundled all data functions until the modern data stack unbundled them. dbt Charts continues this trend by extracting visualization from BI UIs into code. This shift aligns with AI agents' strengths in code rather than GUI interaction. The solution combines SQL for data logic with YAML for presentation in a Git-friendly format.
3Core language features
dbt Charts uses extensible YAML with variables, queries and charts sections. It supports 16 chart types with 1,100+ configuration options. Styles cascade through inheritance from boards to themes. The CLI renders to multiple formats (SVG, HTML, PDF) and serves folders as sites. Layouts maintain cohesion through calculated spacing and sizing rules developed with data visualization experts.
4dbt integration advantages
When used with dbt, charts live alongside models in Git, enabling coordinated changes. Queries reference models via ref() with manifest validation. Planned Semantic Layer integration will allow direct metric usage. This tight coupling catches breaking changes in CI before production deployment, creating a robust change management workflow for analytics.
5Validation and feedback systems
The language includes strict validation for both YAML structure and SQL queries. Visualization-specific checks flag issues like bandwidth overflow or column misalignment before rendering. These guardrails create a tight feedback loop for AI agents, reducing blind spots in automated dashboard generation while maintaining design consistency.
6Hosted platform capabilities
dbtCharts.com provides the remaining BI functions: hosting, access control and UI. It adds conversational analytics with warehouse access controls, visual editing, version history and permissioned sharing. All changes sync back to the open YAML format in Git, preventing platform lock-in while enabling non-technical collaboration.
7Design philosophy
The system prioritizes cohesive visual language over typical dashboard grids. Working with data visualization expert RJ Andrews, the team developed spacing and layout rules that avoid common BI tool compromises. The result achieves publication-quality data graphics while remaining machine-generatable and maintainable as code.
8Future of collaborative analytics
dbt Charts represents a fundamental shift in dashboard creation, optimized for human-AI collaboration. By moving visualization into code where agents excel while maintaining governance and design integrity, it solves key friction points in self-service analytics. The open-source approach ensures the solution evolves with community needs as AI transforms data work.
Original article: Hacker News: Front Page — dbt Charts: Open-source YAML for AI-generated dashboards