Garage Door OS Docs
Reporting & Admin

Data Explorer

Run saved queries and explore business data.
5 min read

Data Explorer

Overview

Data Explorer lets authorized users query business tables, explore columns, and run saved queries—power user reporting beyond fixed report screens.

How to access

Data Explorer (/data-explorer) from the main menu
Enable/disable toggle: Settings → Integrations → Data Explorer (admin).

What you can do today

  • Browse available tables exposed by API.
  • Inspect column metadata per table.
  • Run queries with filters (UI varies by version—table picker + conditions).
  • Admin can enable/disable feature for the business under Integrations.
Requires reports:view permission (menu visibility).

Prerequisites

  • Data Explorer enabled under Settings → Integrations.
  • reports:view (or admin) permission.
  • Understanding of your data model—queries can return large result sets.

Step-by-step

Enable (admin)

  1. Settings → Integrations → Data Explorer.
  2. Turn Enabled on → Save.

Run a query

  1. Data Explorer → select a table.
  2. Choose columns/filters in the builder UI.
  3. Run → review results grid.
  4. Export if export action is available.

Safe exploration tips

  1. Start with narrow date filters.
  2. Avoid exporting PII unnecessarily—follow company policy.
  3. Use fixed Reports for standard KPIs; explorer for ad hoc questions.

Current limitations

  • Config-gated — off by default for many businesses.
  • Not full SQL text editor for all users—capabilities may be constrained vs raw SQL clients.
  • Write/update queries are not supported—read-only exploration.
  • Query performance on very large tables may require admin-tuned limits.

Roadmap

  • Saved queries shared per role.
  • Scheduled query email delivery.
  • AI natural language → safe query builder.

Related features