Query Results
Query Results
AI for Database automatically formats results based on the shape of your data. This page explains the different result formats and how to work with them.
Result Formats
Single Value: When your query returns a single number (e.g., "What is the total revenue?"), it is displayed as a prominent metric card. You can customize the label, format (currency, percentage, number), and comparison period.
Table: When your query returns multiple rows and columns, results are displayed in a sortable, filterable table. Click any column header to sort. Use the filter row to narrow results.
Chart: When AI for Database detects a natural visualization (e.g., data over time or categorical groupings), it automatically generates a chart. Supported chart types:
- Bar chart -- best for comparing categories
- Line chart -- best for trends over time
- Pie chart -- best for showing proportions
- Area chart -- best for cumulative totals over time
Click the chart type icons above the result to switch between visualizations.
Exporting Data
Click the Export button on any result to download the data:
- CSV -- comma-separated values, compatible with Excel, Google Sheets, and most tools.
- JSON -- structured data for developers and integrations.
- PNG -- export charts as images for presentations.
- Clipboard -- copy the table data to your clipboard for quick pasting.
Adding to Dashboards
Click Add to Dashboard to pin any result to a new or existing dashboard. The query will re-run automatically on the dashboard's refresh schedule, keeping the data live.
Result Limits
By default, results are limited to 10,000 rows. For larger result sets, use the Download Full Results option which streams the data to a file. You can change the default limit in Settings > Preferences.