Skip to main content
Get Started
Documentation

Build dashboards with SQL in Tractorscope

Tractorscope is a SQL dashboard builder for teams that want dashboards backed by explicit database queries.

Why build dashboards with SQL

SQL gives developers and data-literate teams direct control over metrics, joins, filters, and aggregation logic. It is useful when dashboards need to match application data exactly or when metrics are easier to express as queries than drag-and-drop transformations.

Workflow

  1. Connect a database.
  2. Open the chart editor.
  3. Write a SQL query or start from an AI-generated query.
  4. Run the query and inspect the result columns.
  5. Map result fields to chart settings.
  6. Save the chart to a dashboard.
  7. Add dashboard filters for viewer-controlled inputs.

Good SQL dashboard use cases

  • Internal BI dashboards from production or reporting databases
  • SaaS customer dashboards scoped by tenant filters
  • Operational reporting from application tables
  • Executive KPIs with clearly defined metric logic
  • Downloadable reports backed by SQL result sets

Query design tips

  • Return one row for KPI charts.
  • Return category and value columns for bar charts.
  • Return date and value columns for line charts.
  • Return series columns when comparing groups.
  • Keep query result shapes predictable before styling the chart.

Related docs