Rill

Visit Tool

Rill is an open-source business intelligence tool that helps humans and AI agents build and explore dashboards. It leverages OLAP engines like ClickHouse and DuckDB for real-time performance and allows defining everything in code.

Claim this tool

3Views

At a glance

Pricing

Open Source

Free tier

Yes

API

Yes

Skill level

Technical

About

What is rill?

Rill is an open-source business intelligence tool designed for both humans and AI agents, offering the fastest way to build and explore dashboards. It's powered by OLAP engines such as ClickHouse and DuckDB, ensuring sub-second queries even with billions of rows. Rill allows users to define models, metrics, and dashboards entirely in code (YAML + SQL), enabling AI agents like Claude to author projects end-to-end. It features a semantic layer for a single source of truth, conversational BI for natural language queries, and capabilities like data profiling, incremental ingestion, and row access policies. Rill supports various data sources, including S3, GCS, and databases, and can be deployed to Rill Cloud for versioned deployments and interactive dashboards.

Best used for

Ideal for data scientists who need to build interactive dashboards, define metrics in code, and integrate AI agents for conversational BI. Especially valuable for those requiring real-time performance on large datasets and version-controlled deployments.

Common actions

build dashboards

analyze data

define metrics

explore data

integrate AI

github copilot"AI Agents"deepfakeface swappingcollaborationlow-code/no-codeautomated workflowworkflowsopen-source

Capabilities

Key features

BI-as-code (YAML + SQL)
OLAP engine integration
Semantic layer
Conversational BI
Real-time performance
Embeddable dashboards
Data profiling

Target Audience

data scientist

Integrations

s3gcsclickhouseduckdbdruidpinotmotherduckclaude+ 1 more

Pricing & Plans

Open Source

Free

FAQs

What OLAP engines does Rill support?

Rill supports OLAP engines like ClickHouse and DuckDB natively. It can also connect to external engines such as ClickHouse Cloud, Druid, Pinot, and MotherDuck, providing flexibility for various data scales and environments.

How does Rill enable AI agents for business intelligence?

Rill allows defining BI projects, dashboards, and security policies in code (YAML + SQL), which AI agents like Claude and Cursor can author end-to-end. The MCP server connects AI agents directly to the semantic layer for conversational BI.

Can Rill dashboards be embedded into other products?

Yes, Rill dashboards are embeddable. You can integrate interactive dashboards, APIs, and agent interfaces directly into your own product, offering a seamless experience for your users to explore metrics.

Trending

Subcategories trending in Data & Analytics

Business Intelligence Predictive Analytics Data Labeling & Annotation Real-Time Analytics Market Research Data Cleaning & Prep

Trending

Explore

Browse AI tools by category

Content & Design Productivity & Business Coding & Development AI Agents & Automation Research & Education Wellness & Lifestyle Career Development Marketing & Growth Data & Analytics Customer Support & CX Finance E-commerce