OQL Tester 🧪

OQL Tester is an interactive tool to write, validate, and visualize OQL queries. It provides syntax hints, autocompletions, and quick ways to share and export query results.

Keyboard Shortcuts

Speed up editing and testing with these shortcuts.

macOS

Shortcut Action Notes
Cmd + / Comment/Uncomment a line Works on one or more selected lines
Cmd + Enter Execute query Runs selected lines if highlighted
Option + Down Move line down Helpful for rearranging code
Ctrl + Option + G Highlight all matches Useful for replacing text across query
Ctrl + Shift + U Convert text to lowercase Helps with reformatting
Ctrl + Space Open OQL hints Shows auto-completions

Windows

Shortcut Action Notes
Ctrl + / Comment/Uncomment a line Works on one or more selected lines
Ctrl + Enter Execute query Runs selected lines if highlighted
Alt + Down Move line down Helpful for rearranging code
Ctrl + Alt + G Highlight all matches Useful for replacing text across query
Ctrl + Shift + U Convert text to lowercase Helps with reformatting
Ctrl + Space Open OQL hints Shows auto-completions

Toolbar

  • Refresh → Re-run the current OQL query.
  • Add to Dashboard → Create a new dashboard module with the query.
  • Share → Generate a shareable URL with the full query (great for Slack).
  • Full-screen → Expand results for easier viewing.
  • Visualization dropdown → Choose how to display results (table, line chart, column chart, etc.).
  • Save → Store queries locally in browser.
  • Open → Load saved queries.
  • Export → Download query results as CSV.

Tip

  • Hover over colored UUIDs to see the associated metric or line name.
  • Red UUIDs indicate items that could not be resolved.
  • Typing a metric or line names triggers OQL hints, which can be selected to auto-replace with the correct UUID.

Query History

OQL Tester tracks your recent queries. Clicking on a query in history reloads it into the editor for quick re-execution.

For each query, the history shows:

  • Execution time
  • Row count
  • Status (only on failure)