Mode
mode.com
What it is
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.
Spec sheet
- What it does
- Mode is a collaborative analytics platform combining SQL, Python, R, visual analysis, dashboards and reporting.Read 14 Oct 2026 · mode.com
- Product
- Mode describes itself as a modern business intelligence platform that brings data teams and business teams together to build analytics.Read 29 Sep 2026 · mode.com
- Audience
- Mode presents its platform as serving data teams and business teams, from ad hoc analysis through self-serve reporting and advanced analytics.Read 29 Sep 2026 · mode.com
- Free plan
- YesRead 20 Sep 2026 · mode.com
- API
- Mode exposes a REST API at app.mode.com/api for queries, reports, members, workspaces and data, using GET, POST, PATCH and DELETE.Read 14 Oct 2026 · mode.com
- Integrations
- Official integrations include dbt freshness, GitHub sync, Excel, Google Sheets, local file uploads, semantic layers, Slack and webhooks.Read 14 Oct 2026 · mode.com
- Security
- Mode states that data in transit is encrypted with TLS 1.2 or higher and data at rest with AES-256.Read 29 Sep 2026 · mode.com
- Support
- The plan comparison lists standard support for Pro and premium support for Enterprise.Read 29 Sep 2026 · mode.com
- Headquarters
- San Francisco, California, United StatesRead 28 Sep 2026 · mode.com
- Founded
- 2013Read 28 Sep 2026 · mode.com
- Acquisition news
- ThoughtSpot announced completion of its $200 million cash-and-equity acquisition of Mode Analytics on July 19, 2023.Read 14 Oct 2026 · thoughtspot.com
- Analysis tools
- Mode provides a SQL editor and connected Python and R notebooks for analysis.Read 29 Sep 2026 · mode.com
- 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.Read 14 Oct 2026 · mode.com
- Bridge security
- The Bridge tunnel is encrypted and does not cache database credentials, queries or query results.Read 14 Oct 2026 · mode.com
- Browser support
- Mode supports current desktop Chrome, Firefox, Safari and Edge on macOS and Windows, while mobile and tablet browsers are not fully supported.Read 14 Oct 2026 · mode.com
- Company identity
- Crunchbase lists the legal name as Mode Analytics, Inc., an active private company acquired by ThoughtSpot.Read 14 Oct 2026 · crunchbase.com
- Company size
- Crunchbase places Mode Analytics in the 51–100 employee range, while LinkedIn lists a 51–200 company-size band.Read 14 Oct 2026 · crunchbase.com
- Custom data apps
- Mode supports building internal data tools with HTML, CSS, JavaScript, APIs, parameters, and embedded reports.Read 29 Sep 2026 · mode.com
- Custom visualizations
- Users can create visualizations with Python, R or custom JavaScript such as D3.Read 14 Oct 2026 · mode.com
- Dashboards
- Mode supports interactive dashboards with drag-and-drop explorations, visualizations, custom themes, and scheduled runs.Read 29 Sep 2026 · mode.com
- Dashboards and reports
- Reports can combine SQL results, charts, notebook outputs, themes and shareable dashboards.Read 14 Oct 2026 · mode.com
- Data sources
- Mode lists warehouse connections including Amazon Redshift, BigQuery, Databricks, Snowflake, PostgreSQL, MySQL, Oracle, SQL Server, Trino and Vertica.Read 14 Oct 2026 · mode.com
- Discovery API
- The read-only Discovery API is restricted to Enterprise workspaces and exposes metadata for reports, collections, queries and charts.Read 14 Oct 2026 · mode.com
- Documentation
- Mode maintains a public help center, developer portal, API reference, API cookbook and Mode University learning resources.Read 14 Oct 2026 · mode.com
- Founded and headquarters
- Mode was founded in 2013 in San Francisco, California.Read 14 Oct 2026 · crunchbase.com
- Integrated notebooks
- Every report can include an integrated Python or R notebook with movable code and markdown cells.Read 14 Oct 2026 · mode.com
- Licence
- The terms grant only a limited, revocable, non-exclusive right to use the service and prohibit reverse engineering, indicating proprietary software.Read 14 Oct 2026 · mode.com
- Limit: learning curve
- Reviewers report that nontechnical users often need instruction and that advanced filtering, drilldowns and report organization can be difficult.Read 14 Oct 2026 · trustradius.com
- Limit: performance and scale
- Reviewers describe slow refreshes or queries on large datasets and say the product is less suitable for massive enterprise workloads.Read 14 Oct 2026 · trustradius.com
- Limit: pricing and support experience
- Reviewers describe Mode as expensive for larger teams and report renewal negotiations with substantial proposed price increases.Read 14 Oct 2026 · trustradius.com
- Limit: visualization gaps
- Reviewers cite limited chart types, missing map or clustered-stacked-bar options, and weaker dashboard customization than some competitors.Read 14 Oct 2026 · capterra.co.uk
- Praise: analytics flexibility
- Reviewers value combining SQL with Python or R, visual exploration, customizable dashboards and database connectivity.Read 14 Oct 2026 · g2.com
- Praise: usability and collaboration
- Reviewers repeatedly praise quick SQL analysis, intuitive interfaces, report sharing, dashboards and collaboration.Read 14 Oct 2026 · trustradius.com
- Privacy and compliance
- Mode states GDPR commitments, provides a data-processing agreement and describes AWS hosting and AWS SOC/ISO assurances.Read 14 Oct 2026 · mode.com
- Rating on Capterra
- 4.6 out of 5 from 89 reviewsRead 14 Oct 2026 · capterra.co.uk
- Rating on G2
- 4.5 out of 5 from 330 reviewsRead 14 Oct 2026 · g2.com
- Rating on Gartner Peer Insights
- 4.6 out of 5 from 6 ratingsRead 14 Oct 2026 · gartner.com
- Rating on GetApp
- 4.6 out of 5 from 89 reviewsRead 14 Oct 2026 · getapp.com
- Rating on Software Advice
- 4.6 out of 5 from 89 reviewsRead 14 Oct 2026 · softwareadvice.com
- Rating on TrustRadius
- 8.1 out of 10 from 18 reviews and ratingsRead 14 Oct 2026 · tr-web.stage.trustradius.com
- Reporting
- Users can create reports with explorable charts, output cells, and narrative writeups.Read 29 Sep 2026 · mode.com
- SDK examples
- The developer reference provides examples and client guidance for cURL, Ruby, Python and JavaScript.Read 14 Oct 2026 · mode.com
- Security controls
- Mode states that it uses TLS 1.2 or newer in transit, AES-256 encryption at rest, least-privilege permissions, MFA and managed production access controls.Read 14 Oct 2026 · mode.com
- Self-hosting
- Mode is delivered as a hosted service; its Bridge connector can be installed on customer-controlled Linux, macOS or Windows hosts and in Docker.Read 14 Oct 2026 · mode.com
- Slack integration
- Mode can send scheduled reports to Slack and unfurl shared charts and query results in conversations.Read 14 Oct 2026 · mode.com
- SQL editor
- The platform provides a SQL editor for querying connected databases and iterating on results.Read 14 Oct 2026 · mode.com
- Studio limits
- Studio is listed for up to three users and limits queries to 10 MB each.Read 29 Sep 2026 · mode.com
- System requirements
- Supported Bridge hosts include macOS 10.11 or later and Windows 10 or Windows Server 2012 R2 or later; Linux distributions are also documented.Read 14 Oct 2026 · mode.com
- Usage scale
- Mode says its platform runs more than 5 million queries per day and is used by 50% of Fortune 500 companies.Read 14 Oct 2026 · mode.com
- Visual exploration
- Visual Explorer lets users examine data interactively in the browser, including datasets with more than 100,000 points.Read 14 Oct 2026 · mode.com
- Warehouses
- Mode says it connects to most major data warehouses and does not build connectors to SaaS tools.Read 29 Sep 2026 · mode.com
Plans and prices
Strong points and limits
Strong points
- SQL editor with connected Python and R notebooks
- Interactive dashboards with scheduled runs
- Internal data apps support HTML, CSS, and JavaScript
- Connects to most major data warehouses
- TLS 1.2-plus and AES-256 encryption
Limits
- Studio is limited to three users
- Studio queries are limited to 10 MB
- Pro requires at least three users
- Enterprise requires at least 50 users
Who it suits
Mode suits data and business teams handling analysis, reporting, dashboards, and internal data applications. Its plan limits and user minimums matter when choosing between Studio, Pro, and Enterprise.
Verdict
Mode combines notebook-based analysis, reporting, dashboards, and programmable internal tools in a cloud platform. The free Studio plan has explicit user and query limits, while larger plans specify capacity or minimum users rather than published prices.
Where Specifiction places it
- Bi Platforms#4 of 298.6
- Business Analytics#4 of 268.7
- Business Intelligence Tools#14 of 898.8
- Business Intelligence & Analytics - Enterprise Software#5 of 298.6
- SQL Query Tools#6 of 318.7
- Dashboards#7 of 308.6
- Data Analytics Software#11 of 348.5