Mode vs Querybook
Mode
mode.comQuerybook
querybook.orgSide by side
| Figure | Mode | Querybook |
|---|---|---|
| Price from | Free | — |
| Free plan | Yes | — |
| Free trial | Yes | — |
| Open source | — | — |
| Web | Yes | Yes |
| Windows | Yes | — |
| macOS | Yes | — |
| Linux | Yes | — |
| API | Yes | Yes |
| Self-hosted | — | Yes |
| Plans published | 4 | 0 |
| Spec score · SQL Query Tools | 8.7 (#6) | 7.1 (#25) |
| API | Mode exposes a REST API at app.mode.com/api for queries, reports, members, workspaces and data, using GET, POST, PATCH and DELETE. | Users can create API access tokens and send them in the api-access-token request header for authentication. |
| Audience | Mode presents its platform as serving data teams and business teams, from ad hoc analysis through self-serve reporting and advanced analytics. | The site describes Querybook as a tool for engineers and data scientists. |
| Integrations | Official integrations include dbt freshness, GitHub sync, Excel, Google Sheets, local file uploads, semantic layers, Slack and webhooks. | Documented query engines include Presto, Hive, Druid, Snowflake, BigQuery, MySQL, SQLite, PostgreSQL, SQL Server, and Oracle. |
| Product | Mode describes itself as a modern business intelligence platform that brings data teams and business teams together to build analytics. | Querybook is an open-source big data IDE for discovering, creating, and sharing data analyses, queries, and tables. |
| Support | The plan comparison lists standard support for Pro and premium support for Enterprise. | The site provides a Slack community and lists [email protected] as a contact email. |
Plans
In their own words
Mode
Mode is a business intelligence platform that brings data teams and business teams together for analytics, from ad hoc analysis through self-serve reporting and advanced work. It offers a SQL editor with connected Python and R notebooks. Reports can combine explorable charts, output cells, and narrative text, while Visual Explorer supports browser exploration of more than 100,000 data points. Interactive dashboards provide drag-and-drop exploration, visualizations, custom themes, and scheduled runs. Teams can build internal data tools with HTML, CSS, JavaScript, APIs, parameters, and embedded reports. Listed integrations include dbt freshness, GitHub, Excel workbooks, Google Sheets, semantic layers, Slack, local file uploads, and webhooks. Mode connects to most major data warehouses but does not build SaaS-tool connectors. Studio supports up to three users and 10 MB per query. Pro lists 250 GB per month, 5 GB per query, and a three-user minimum; Enterprise requires at least 50 users. API and web access, scheduled queries, shared queries, SQL notebooks, and AI query assistance are listed. Data is encrypted with TLS 1.2 or higher in transit and AES-256 at rest.