---
title: "Query Results - Documentation"
description: "Understand result formats including tables, charts, and single values. Export data as CSV, JSON, or to dashboards."
canonical: "https://www.aifordatabase.com/docs/query-results/"
---

# Query Results

beginner 4 min read

## 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**.

Source: https://www.aifordatabase.com/docs/query-results/