Skip to main content
Get Started
Documentation

Build dashboards with AI in Tractorscope

Tractorscope includes AI-assisted chart creation so teams can move from a business question to a working SQL chart faster.

How AI chart building helps

AI chart creation can inspect the selected database schema, generate a SQL query, choose an initial chart type, and create a starting point for the chart configuration. You can then inspect and edit the SQL before saving the chart.

Good prompts

  • Show monthly revenue for the last 12 months.
  • Compare active customers by plan.
  • List open support tickets by priority and owner.
  • Show daily signups and activation rate.
  • Create a KPI for total sales this month.
  • Show churned accounts by cancellation reason.

Recommended workflow

  1. Choose the database connected to the right data.
  2. Describe the metric or question in plain language.
  3. Review the generated SQL.
  4. Run the query and check the result shape.
  5. Adjust the chart type and field mapping.
  6. Save the chart to a focused dashboard.

Best practices

  • Treat generated SQL as a draft.
  • Use clear business terms and date ranges in prompts.
  • Review joins, filters, and aggregation logic.
  • Rename charts and fields so dashboard viewers understand them.
  • Use SQL docs when the chart needs precise query control.

Related docs