Charts, Dashboards & Insights

How Data Explorer turns query results into saved widgets, groups them into dashboards, and reopens them as first-class working tabs.

Charts from query results

Once a query returns data, you can save the current snapshot as a widget instead of treating it as a one-off result.

Dashboard tabs

Saved dashboards can be opened as dedicated workspace tabs instead of staying as temporary summary panels.

Snapshot-based widgets

Widgets currently store a result snapshot for fast revisit, which works well for lightweight reporting and short-term analysis.

Recommended workflow

Run a query

Start in the SQL editor and produce a meaningful result set.

Open the save dialog

From the results panel, choose to save into a dashboard.

Pick chart + axes

Pick bar, line, pie, donut, area, or table depending on the data.

Open the dashboard tab

The new widget appears in the dashboard you just created or selected.

Best-fit chart types

Bar / Column

Best for rankings, top lists, or comparing categories by one primary metric.

Line / Area

Best for time series, trend analysis, or metrics that change over days or months.

Pie / Donut

Use when the number of groups is small and the goal is composition, not precise category-by-category comparison.

How AI and dashboards work together

AI recommendation cards can suggest a better chart type and field mapping for your result set. You still stay in control of which widget actually gets saved into a dashboard.

Quick prompt: "Suggest the best chart for this result set and explain which fields should be on each axis."

Current limitations

Widgets currently save a data snapshot, not a scheduled live-refresh reporting pipeline.
Dashboards are currently best suited for quick analysis, internal review, and query-driven exploration.
Public dashboard sharing, scheduled reports, and embedded analytics are still future roadmap items.

A query example worth saving as a widget

Top categories by revenue

SELECT category_name, SUM(revenue) AS total_revenue

FROM sales_summary

GROUP BY category_name

ORDER BY total_revenue DESC

LIMIT 10;

This kind of query is ideal for a bar-chart widget because it has one clear category dimension and one numeric metric.

PreviousERD Diagram Next Team Workspace

Ready to explore data?

Join the community on GitHub to contribute to the smartest local database IDE.

Launch App