Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Rill Metrics SQL

rilldata.com

  • Free trial
  • Windows
  • macOS
  • Linux
  • Web
  • API
  • Self-hosted
7.6 Club score Visit rilldata.com

What Rill Metrics SQL is

Rill Metrics SQL turns existing data-warehouse metrics into governed dashboards, partner embeds and context for AI agents. Metrics SQL lets users query a metrics view as a table using defined dimensions and measures, without writing aggregation logic in each query. Sources, models, metrics and dashboards are defined in SQL and YAML and can be version-controlled in Git. Dashboards provide pivot tables, time comparisons, drill-downs, scheduled reports and threshold alerts. Embedding supports iframes, JWT-secured links and a headless API, with white-label theming and partner data scoping. Documented connectors include ClickHouse, BigQuery, Databricks, Redshift, Snowflake, PostgreSQL, MySQL, S3, GCS, Azure Blob Storage, Claude, OpenAI, Gemini and Slack. Role-based access controls and YAML policies cover row- and column-level security, and Metrics SQL APIs inherit metrics-view policies. An MCP server exposes governed metrics to Claude, ChatGPT and other agents. Starter costs $20 a month per seat; Growth costs $30 a month per seat. Enterprise pricing is custom.

Who it suits

It suits data teams that define metrics in code, build embedded analytics or expose governed warehouse context to AI agents. It supports hybrid deployment across web, API, self-hosted and desktop environments.

Good to know, and what to watch

  • Queries governed metrics as tables
  • Definitions can be version-controlled in Git
  • Supports embedded analytics and partner scoping
  • Provides row- and column-level policies
  • Exposes metrics through an MCP server
  • No free plan is listed
  • Compute is billed separately
  • Windows use requires WSL
  • Enterprise pricing is custom

Enterprise

—

Starter

$20/mo

Growth

$30/mo

30-day trial

The verdict

Rill Metrics SQL connects version-controlled metric definitions with dashboards, embeds, security policies and agent access. Seat limits, separate compute billing and deployment requirements should shape evaluation.

What the maker publishes

Access controls
Rill offers role-based access controls and YAML-authored row- and column-level security policies; Metrics SQL APIs inherit metrics-view security policies. source
AI
Rill exposes its governed metrics layer through an MCP server for use by Claude, ChatGPT, and other agents. source
Compliance
The product page states that Rill has SOC 2 Type 2. source
Dashboards
Dashboards support pivot tables, time comparisons, drill-downs, scheduled reports, and threshold alerts. source
Definitions
Sources, models, metrics, and dashboards are defined in SQL and YAML and can be version-controlled in Git. source
Embedding
Rill supports iframe embeds, JWT-secured links, and a headless API, with white-label theming and partner data scoping. source
Free access
The pricing page offers a free start and says all plans include $250 usage credit; it does not state a trial duration. source
Integrations
Documented connectors include ClickHouse, BigQuery, Databricks, Redshift, Snowflake, PostgreSQL, MySQL, S3, GCS, Azure Blob Storage, Claude, OpenAI, Gemini, and Slack. source
Metrics SQL
Metrics SQL lets users query a metrics view as a table using defined dimensions and measures without writing aggregation logic in the query. source
Platform availability
Rill Developer installs on macOS and Linux; on Windows it runs through WSL, with Ubuntu 22.04 LTS verified by Rill. source
Product
Rill turns SQL into governed dashboards, partner-ready embeds, and agent-ready context on existing data warehouses. source
Support
Starter lists a 1 business day response time, Growth lists a 6 hour response time with 24/7/365 support, and Enterprise lists a 1 hour response time, SLA, and dedicated account manager. source

Checked against the maker's pages on 5 Oct 2026.