Skip to content
Datablare
Claude Code SaaS Revenue & growth

SaaS MRR, churn and plan mix

$458.7K MRR across 1,760 accounts, 12.8% logo churn over 12 months, MRR by plan and region, and churn month by month.

Data
Synthetic SaaS demo data (PostgreSQL)
Asked in
Claude Code
Updated
Try this on your data

1 · The brief

What Claude Code was asked

Give me a revenue dashboard for our subscriptions: current MRR, active accounts and average revenue per account, MRR over time by plan, how many accounts churn each month, our churn rate over the last 12 months, and where our MRR comes from by region.

Given exactly like this. Claude Code asked Datablare which tables it could read, wrote the SQL itself, ran each query through Datablare and built the dashboard from what came back.

2 · The dashboard

The dashboard Claude Code built

SaaS MRR, churn and plan mix dashboard: MRR by plan, MRR mix by plan, October, Accounts churned per month, MRR by region, October

Built from 5 read-only queries. Every figure on the dashboard was read from the database through Datablare; nothing was estimated or typed in.

Headline numbers (As of October 2026):

  • MRR: $458.7K (October 2026)
  • Active accounts: 1,760 (Paying in October)
  • ARPA: $261 (Average revenue per account)
  • Logo churn, 12 months: 12.8% (161 of 1,257 accounts)

What stands out:

  • MRR by plan: MRR grew from $191.4K to $458.7K since Jan ’25
  • MRR mix by plan, October: Scale is 59.0% of MRR
  • Accounts churned per month: 402 accounts churned since January 2025
  • MRR by region, October: APAC is the largest region at $104.6K

The data is a synthetic SaaS dataset made for this example, so the numbers describe no real company. The queries, the dashboard and the audit entries are real: Claude reached the database only through Datablare, read-only, and every query is on record with the question it served.

3 · What Datablare ran

5 read-only queries, nothing changed

Each query below is copied from the audit log of this run. Datablare checked that it only reads, ran it read-only, and gave only the rows to Claude Code; it never stores them.

  1. Query 1

    Current MRR, active accounts and ARPA for October 2026

    1 row · 264 ms

    SELECT round(sum(mrr), 0) AS mrr, count(DISTINCT account_id) AS active_accounts, round(sum(mrr) / count(DISTINCT account_id), 0) AS arpa
    FROM saas.mrr_monthly
    WHERE month = DATE '2026-10-01'
  2. Query 2

    Logo churn over the last 12 months among accounts active on 1 Nov 2025

    1 row · 181 ms

    SELECT count(*) FILTER (WHERE churn_date >= DATE '2025-11-01' AND churn_date < DATE '2026-11-01') AS churned,
           count(*) AS active_at_start,
           round(count(*) FILTER (WHERE churn_date >= DATE '2025-11-01' AND churn_date < DATE '2026-11-01')::numeric / count(*), 4) AS churn_rate_12m
    FROM saas.accounts
    WHERE signup_date < DATE '2025-11-01' AND (churn_date IS NULL OR churn_date >= DATE '2025-11-01')
  3. Query 3

    MRR by plan for each month since January 2025

    66 rows · 89 ms

    SELECT to_char(month, 'YYYY-MM') AS month, plan, round(sum(mrr), 0) AS mrr
    FROM saas.mrr_monthly
    WHERE month >= DATE '2025-01-01'
    GROUP BY 1, 2
    ORDER BY 1, 2
  4. Query 4

    Accounts churned per month since January 2025

    22 rows · 49 ms

    SELECT to_char(date_trunc('month', churn_date), 'YYYY-MM') AS month, count(*) AS churned_accounts
    FROM saas.accounts
    WHERE churn_date >= DATE '2025-01-01'
    GROUP BY 1
    ORDER BY 1
  5. Query 5

    Current MRR by customer region

    5 rows · 49 ms

    SELECT a.region, round(sum(m.mrr), 0) AS mrr, count(*) AS accounts
    FROM saas.mrr_monthly m
    JOIN saas.accounts a ON a.id = m.account_id
    WHERE m.month = DATE '2026-10-01'
    GROUP BY 1
    ORDER BY 2 DESC
Tables read saas.accountssaas.mrr_monthly

4 · The audit entry

Who asked what, on record

Every query is recorded with the person who asked, the question in their words and why the agent ran it. Admins see this in the audit log; nothing reaches the database without it.

How the audit log works

query_data_source

via Claude Code

Allowed
Who
The person signed in (hidden on this public page)
Question
Give me a revenue dashboard for our subscriptions: current MRR, active accounts and average revenue per account, MRR over time by plan, how many accounts churn each month, our churn rate over the last 12 months, and where our MRR comes from by region.
Intent
Current MRR, active accounts and ARPA for October 2026
Result
5 queries, 95 rows, read-only

More use cases

All examples
  • MRR movements and net revenue retention dashboard: MRR movements per month, ARPA by plan, October, Net new MRR per month
    Claude Code SaaS Revenue & growth

    MRR movements and net revenue retention

    Net revenue retention of 95.4%, $124.3K of new MRR this year and $46.7K lost to churn, with ARPA by plan.

    Updated Open

  • Account retention by plan and signup cohort dashboard: Still active, by signup quarter, How long churned accounts stayed, Churned share by region, Churned share by plan
    Claude Code SaaS Customer analytics

    Account retention by plan and signup cohort

    452 of 2,200 accounts have churned, after a median 9.0 months; Middle East churns most.

    Updated Open

  • E-commerce sales and retention dashboard dashboard: Monthly revenue, Revenue by category, 2026, Lifetime revenue per customer, by channel, Orders per month
    Claude Code E-commerce Executive overview

    E-commerce sales and retention dashboard

    ₹5.21M revenue from 11,897 orders this year, a 57.9% repeat-customer rate, and which channels bring the customers who spend most.

    Updated Open

Build this on your own data.

Connect your database, choose the tables Claude may read, and give it the same brief. Claude is connected in about two minutes.

30 minutes with the founder. Or WhatsApp / [email protected]