Metabase alternative zerosoft Analytics, open source.
Analytics does the core of what Metabase does. It runs on your server for $0 under AGPLv3, or on zerosoft Cloud with a free plan and usage-based pricing, with no charge per seat. By our count it covers 54% of the 40 Metabase capabilities we measure.
What you get
- PostgreSQLRead-only transaction, statement timeout, row limit, encrypted password and private addresses blocked
- Query builder without codeTable, filters, metrics, grouping by date buckets, sort, limit and joins (by keys on workspace data)
- SQL editorAutocomplete of tables, columns and keywords, schema browser, Cmd+Enter
- Table, number, line, bar and area
- Dashboard filters wired to cardsText, number and date ranges, to a SQL variable or a builder column
- Public links and iframe embedLong random token stored hashed, revocable, calculated with the creator’s permissions, the query never reaches the browser
- SQL variables and optional clausesText, number and date with defaults; field filters that map to a column are not built
- Ask in plain languageAI writes SQL from the schema you can read and always shows it; Metabot is a paid add-on
What Analytics adds
- 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
What is still missing
Capabilities Metabase has that Analytics lacks or only covers in part. Vote on the public board for the ones you need.
- BigQuery, Snowflake, Redshift and others missing
- MySQL partialBuilt with the same controls as PostgreSQL; not yet tested against a real MySQL server
- Dashboard grid of cards partialReorder and resize with buttons (keyboard friendly), text cards; no drag and drop or tabs
- Data permissions partialWorkspace data follows each app’s permissions; on external databases admins choose who writes SQL. No per-table or per-group rules
- Usage analytics and audit log missing
- Row-level sandboxing by group missing
- Alerts when a question crosses a goal missing
- Signed embedding (JWT) with locked parameters missing
- Click behavior and cross-filtering missing
- Combo, scatter, waterfall, gauge and progress missing
- Maps missing
- Pivot tables missing
- Revision history missing
- Drill-through by clicking a chart missing
- Saved SQL snippets missing
- Custom columns and expressions missing
- Models and metrics missing
- Upload CSV as a table missing
- SSH tunnels missing
- Schema sync partialOn connect and with a button; no scheduled sync or field values scan
- Formatting and series settings partialPick the chart, x and series; no per-column formatting, goal lines or colors
- Download results partialCSV of the rows shown (up to 2,000); no XLSX or JSON
- Dashboard subscriptions by email partialDaily or weekly at a local hour, to people in the workspace; tested with a fake mail sender; no attachments
- Subscriptions to a chat channel partialTo a Talk channel (Metabase sends to Slack)
- Collection permissions partialShared or personal; only the author or an admin edits. No per-group view or curate rights
Price
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.
$0 on your server (AGPLv3). On zerosoft Cloud: free plan, then usage. Seats are not billed.
Moving from Metabase
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.
Guides and posts
- Link analytics without cookies: what one HTTP request tells usLink counts clicks with no cookies, no JavaScript and no fingerprinting. Everything comes from the request the browser already sends.
- What zerosoft collects, and what it doesn'tLink stores the country, referrer and device of a click, never the IP address or a cookie. What we record, what we leave out, and why.