What Mode is
Mode is a business intelligence platform for data and business teams, covering work from ad hoc analysis to self-serve reporting and advanced analytics. Its SQL editor is paired with connected Python and R notebooks. Reports can combine explorable charts, output cells, and written explanations. Visual Explorer supports browser-based exploration of more than 100,000 data points, while interactive dashboards offer drag-and-drop exploration, visualizations, custom themes, and scheduled runs. Teams can build internal data tools using 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 connectors to SaaS tools. Studio is listed for up to three users and limits queries to 10 MB each. Pro lists 250 GB per month, a 5 GB per-query limit, and a three-user minimum; Enterprise has a 50-user minimum. Mode offers API and web access, scheduled queries, team query sharing, SQL notebooks, and AI query assistance. Its stated security measures include TLS 1.2 or higher for data in transit and AES-256 for data at rest.
Who it suits
Mode is aimed at data and business teams that need analysis, reporting, dashboards, or internal data tools. Its SQL editor and connected Python and R notebooks can serve analysts, while interactive reports support business users exploring results.
Good to know, and what to watch
- SQL editor works with Python and R notebooks.
- Reports combine charts, output cells, and narrative.
- Visual Explorer handles more than 100,000 data points in a browser.
- Supports interactive dashboards and scheduled runs.
- Encrypts data in transit and at rest, according to Mode.
- Studio is limited to three users.
- Studio queries are limited to 10 MB each.
- Pro requires at least three users.
- Enterprise requires at least 50 users.
Plans
Every plan and priceEnterprise
Pro
Studio
Free plan
The verdict
Mode brings SQL, notebooks, reporting, dashboards, and custom data tools into one analytics platform. Check the user minimums and query limits for the listed plans before deciding whether they fit your team.
What the maker publishes
- Acquisition news
- ThoughtSpot announced completion of its $200 million cash-and-equity acquisition of Mode Analytics on July 19, 2023. source
- Analysis tools
- Mode provides a SQL editor and connected Python and R notebooks for analysis. source
- API
- Mode exposes a REST API at app.mode.com/api for queries, reports, members, workspaces and data, using GET, POST, PATCH and DELETE. source
- API authentication
- API access uses token-based basic authentication; workspace and member tokens are documented, while personal tokens were scheduled for deprecation on February 28, 2025. source
- Audience
- Mode presents its platform as serving data teams and business teams, from ad hoc analysis through self-serve reporting and advanced analytics. source
- Bridge security
- The Bridge tunnel is encrypted and does not cache database credentials, queries or query results. source
- Browser support
- Mode supports current desktop Chrome, Firefox, Safari and Edge on macOS and Windows, while mobile and tablet browsers are not fully supported. source
- Cells
- Notebooks provide code and Markdown cells. source
- Company identity
- Crunchbase lists the legal name as Mode Analytics, Inc., an active private company acquired by ThoughtSpot. source
- Company size
- Crunchbase places Mode Analytics in the 51–100 employee range, while LinkedIn lists a 51–200 company-size band. source
- Custom data apps
- Mode supports building internal data tools with HTML, CSS, JavaScript, APIs, parameters, and embedded reports. source
- Custom visualizations
- Users can create visualizations with Python, R or custom JavaScript such as D3. source
- Dashboards
- Mode supports interactive dashboards with drag-and-drop explorations, visualizations, custom themes, and scheduled runs. source
- Dashboards and reports
- Reports can combine SQL results, charts, notebook outputs, themes and shareable dashboards. source
- Data sources
- Mode lists warehouse connections including Amazon Redshift, BigQuery, Databricks, Snowflake, PostgreSQL, MySQL, Oracle, SQL Server, Trino and Vertica. source
- Discovery API
- The read-only Discovery API is restricted to Enterprise workspaces and exposes metadata for reports, collections, queries and charts. source
- Documentation
- Mode maintains a public help center, developer portal, API reference, API cookbook and Mode University learning resources. source
- Execution
- Cells can be run individually or all together. source
- Founded
- 2013 source
- Founded and headquarters
- Mode was founded in 2013 in San Francisco, California. source
- Free plan
- Yes source
- Free tier limits
- Mode Studio notebook has 4 GB RAM and 1 CPU. source
- Headquarters
- San Francisco, California, United States source
- Import
- Existing .ipynb notebooks can be imported up to 25 MB. source
Checked against the maker's pages on 18 Nov 2026.