Data Visualizer
Transform query results into beautiful, insightful charts.
The Data Visualizer lets you turn raw query results into actionable insights through a variety of chart types.
Getting Started
After running any query in the Query Editor, click the Visualize button to open the Data Visualizer.
DBStudio without the help of AI automatically:
- Detects numeric vs. categorical columns.
- Suggests the best chart type for your data.
- Warns you about unique/high-cardinality columns that may not visualize well.
Chart Types
| Chart | Best For |
|---|---|
| Bar | Comparing categories |
| Line | Time series and trends |
| Area | Cumulative trends |
| Pie | Part-to-whole relationships (≤5 categories) |
| Scatter | Correlations and dot plots |
Configuration
Axis Selection
- X-Axis: Choose your categorical or time column.
- Y-Axis: Select one or more numeric columns to plot.
Color Themes
Pick from 8 built-in palettes:
- Emerald, Ocean, Sunset, Forest
- Pastel, Neon, Monochrome, Vibrant
AI Suggestions
Pro feature: The AI can suggest which columns produce the most meaningful visualizations based on data cardinality and uniqueness.
Data Export
Export your visualized data:
| Format | Tier |
|---|---|
| CSV | All |
| JSON | All |
| Excel | Pro |