AnalyticsThe open-source alternative to Metabase

Ask about your CRM, Track, Books, Groups and Pulse data, or about your own Postgres or MySQL. Build a question without code, write SQL with autocomplete, or type it in plain words and read the SQL it writes. Put the answers on dashboards with filters and send them by email or to Talk.

fig. 0 · bars of a dashboard with sample data

Analytics, inside.

zerosoft.ai/app/analytics

fig. 1 · analytics, interactive viewTry Analytics

Ask your data.Share the answer.

  • Your workspace as tables

    Contacts, companies, deals, projects, issues, invoices, chats, messages and Pulse events, read-only. Each person sees only the rows they can see in each app.

  • Builder without code

    Pick a table, filter, count or sum, group by day, week, month or year, join related tables and sort. The SQL it writes is always one click away.

  • SQL editor

    Autocomplete of tables and columns, a schema browser, variables with defaults and optional filters, and results you can page through or download as CSV.

  • Ask in plain words

    Type a question and AI writes the SQL over the tables you can read. The SQL is shown before you trust the result, and it goes through the same read-only checks.

  • Dashboards

    A grid of cards with numbers, lines, bars, areas, pies and funnels, text, filters wired to each card, auto-refresh, full screen and collections to keep it tidy.

  • Share and subscribe

    Public links and iframes that never show the query, and summaries by email to your team or to a Talk channel, daily or weekly.

How it works.

  1. Pick your data

    Your workspace is ready. To add Postgres or MySQL, an admin connects it with a read-only user.

  2. Ask a question

    Use the builder, write SQL or ask in plain words. Pick the chart or let it choose one.

  3. Build a dashboard

    Add the questions you saved, wire filters and share it or subscribe your team.

Analytics next to Metabase.Our count, capability by capability.

parity with Metabase

54%of what Metabase does, by our count

Included
15
Partial
9
Missing
16

We measured 40 Metabase capabilities: each one we have scores 1, a partial one 0.5 and a missing one 0, with double weight for the core ones; this is our own assessment, checked against the code on November 8, 2026. See the changelog

  • Data sources35%
  • Questions63%
  • Visualizations55%
  • Dashboards71%
  • Sharing50%
  • Permissions and admin50%
Everything Analytics includes25

[x] Included[+] Better[~] Partial

Analytics capabilities compared with Metabase
CapabilityAnalyticsMetabase
Data sources
Your workspace data as tables BetterCRM, Track, Books, Lines and Pulse, read-only, with each app’s permissions applied per person. Metabase needs a database firstMetabase: No
PostgreSQL IncludedRead-only transaction, statement timeout, row limit, encrypted password and private addresses blockedMetabase: Yes
MySQL PartialBuilt with the same controls as PostgreSQL; not yet tested against a real MySQL serverMetabase: Yes
Schema sync PartialOn connect and with a button; no scheduled sync or field values scanMetabase: Yes
Questions
Query builder without code IncludedTable, filters, metrics, grouping by date buckets, sort, limit and joins (by keys on workspace data)Metabase: Yes
SQL editor IncludedAutocomplete of tables, columns and keywords, schema browser, Cmd+EnterMetabase: Yes
SQL variables and optional clauses IncludedText, number and date with defaults; field filters that map to a column are not builtMetabase: Yes
Ask in plain language IncludedAI writes SQL from the schema you can read and always shows it; Metabot is a paid add-onMetabase: Yes
Result caching IncludedPer person and query, 5 minutes by default; no per-question policyMetabase: Yes
Visualizations
Table, number, line, bar and area IncludedMetabase: Yes
Automatic chart choice IncludedMetabase: Yes
Pie and funnel IncludedMetabase: Yes
Formatting and series settings PartialPick the chart, x and series; no per-column formatting, goal lines or colorsMetabase: Yes
Download results PartialCSV of the rows shown (up to 2,000); no XLSX or JSONMetabase: Yes
Dashboards
Dashboard grid of cards PartialReorder and resize with buttons (keyboard friendly), text cards; no drag and drop or tabsMetabase: Yes
Dashboard filters wired to cards IncludedText, number and date ranges, to a SQL variable or a builder columnMetabase: Yes
Auto-refresh and full screen IncludedMetabase: Yes
Collections and personal collections IncludedNested collections are stored but browsed flatMetabase: Yes
Sharing
Public links and iframe embed IncludedLong random token stored hashed, revocable, calculated with the creator’s permissions, the query never reaches the browserMetabase: Yes
Dashboard subscriptions by email PartialDaily or weekly at a local hour, to people in the workspace; tested with a fake mail sender; no attachmentsMetabase: Yes
Subscriptions to a chat channel PartialTo a Talk channel (Metabase sends to Slack)Metabase: Yes
Permissions and admin
Data permissions PartialWorkspace data follows each app’s permissions; on external databases admins choose who writes SQL. No per-table or per-group rulesMetabase: Yes
Collection permissions PartialShared or personal; only the author or an admin edits. No per-group view or curate rightsMetabase: Yes
API and MCP IncludedSession or API key with bi:read and bi:write; the same operations are on the MCP serverMetabase: Yes
Open source and self-hosted IncludedMetabase: Yes

Where we go further

  • Your workspace data as tablesCRM, Track, Books, Lines and Pulse, read-only, with each app’s permissions applied per person. Metabase needs a database first
Still missing (16)

Metabase has these and we don't yet. If you need one, vote for it on the public board.

Metabase at list price.Against $0 on your server.

Today you pay

Metabase
By plan Metabase Cloud: a monthly price plus each extra user
10 people
see Metabase pricing / year

Metabase open source is free if you host it yourself; Metabase Cloud charges per month plus per user. We could not verify every current price, so check metabase.com/pricing. Analytics on your server costs $0 plus your database.

With zerosoft

$0
Analytics on your server
$0
10 people / year
$0
License
AGPLv3

Price = cost × 3.Both numbers in plain sight.

On your server, zerosoft costs $0. On zerosoft Cloud every workspace gets a free monthly plan, and above it we charge usage at three times what it costs us to serve.

  1. $0

    Self-host it

    / month, on your server

    The core is AGPLv3, with every core feature. Run it on your server and change it however you like. There is no trial and no license key.

  2. Free

    zerosoft Cloud

    / to start · then usage-based

    We run it: login, backups, updates and uptime. Every workspace starts on a free plan, then pays for usage: clicks, bookings, emails and storage. Seats are not billed, and AI is billed by tokens.

  3. Let's talk

    Enterprise

    / commercial license + support

    A commercial license with direct support from the team, on your servers or in our cloud. SSO/SAML, audit logs, custom roles and white-label are in development.

Usage on zerosoft Cloud

What is charged above the plan, per workspace per month. First what it costs us, then what you pay.

zerosoft Cloud usage above the plan, per workspace per month
ResourceIncluded per monthCharged perOur costYour price (× 3)
Link clicks25,000 clicks100,000 clicks$0.83$2.50
Bookings50 bookings1,000 bookings$4.00$12.00
Emails sent150 emails1,000 emails$1.00$3.00
Storage0.5 GB1 GB per month$0.17$0.50
  • Seats are not charged: adding people to the team does not change the bill.
  • AI is billed per token, at the provider's price × 1.2.
  • A paid workspace has a $5 monthly minimum, credited to usage.
  • Infrastructure costs measured on October 12, 2026 and rounded to the cent.

Analytics questions.Migration, limits and API.

Which data can it read?

Your zerosoft workspace (CRM, Track, Books, Groups and Pulse) and PostgreSQL or MySQL databases an admin connects. BigQuery, Snowflake and other engines are not supported yet.

Can a question change my data?

No. Workspace tables are read through a whitelist of read-only SQL. External databases run each query in a read-only transaction with a time limit, one statement at a time. Still, connect with a database user that can only read.

Who sees what?

Each person sees the workspace rows they can see in each app: CRM visibility, private Track projects, Books roles and Groups chats. Personal collections stay private. On an external database, admins decide if members can write SQL or only use the builder.

How does asking in plain words work?

AI gets the names of the tables and columns you can read, never the rows, and writes one SELECT. You see the SQL and can edit it. It needs AI turned on in the workspace.

What is missing compared to Metabase?

Maps, pivot tables, drill-through by clicking a chart, alerts on a question, models and metrics, row-level sandboxing by group, signed JWT embedding and more database engines. The parity table above has the full list.