GitHub - rilldata/rill: The fastest business intelligence tool for humans and agents.
Rill lets you define BI workflows—models, metrics, dashboards and access policies—in YAML and SQL, and runs queries on engines like ClickHouse or DuckDB. It adds conversational and agent-driven interfaces for natural-language querying and automated dashboard generation, with real-time performance, embeddable dashboards, and Git-backed deployments.
- Full BI stack (models, metrics, dashboards, agent config) spins up from three prompts via `rill init`, then `rill start` gives an instant local UI.
- Metrics-as-code approach: SQL models plus YAML-defined dimensions/measures let Rill generate queries on the fly, returning sub-second results even at billions of rows.
- Same semantic layer powers both natural-language conversational BI and traditional SQL-based analyst workflows.
- Deployment is Git/CI-CD native via `rill deploy`, with dashboards embeddable and metrics exposed through a REST API.
Rill packs a full BI platform into a few commands. After running curl https://rill.sh | sh to install, you type rill init and answer three prompts—project name, OLAP engine (DuckDB or ClickHouse), and agent instructions. That generates a folder with YAML definitions for your data models, metrics, dashboards and agent configs. One more command, rill start my-project, spins up a local UI you can explore immediately.
Under the hood, Rill treats your metrics as code. You define models in SQL, feed them through DuckDB or ClickHouse, then declare dimensions, measures and time grains in YAML. When you query, Rill generates the SQL on the fly and returns sub-second results even at billions of rows. You get connectors for S3, GCS, databases and more. Dashboards and conversational BI both live in the same semantic layer, so business users can ask questions in plain English while analysts extend everything with SQL. Deployments tie into Git or CI/CD pipelines via rill deploy, and you can embed dashboards or expose metrics through a simple REST API.