Skip to main content
Docs/Data Insights
DocsData Insights
Pro

Data Insights

Ask natural-language questions about your app data and get back charts, tables, and time series. Backed by your relational schema and rate-limited per user.

Data Insights requires a Pro or Business plan.

Asking a Question

1

Open the Insights panel

From the app editor sidebar, open Insights. The panel shows a prompt input and a history of recent queries.
2

Type a question

Be concrete: name the entities and the time window. "Orders by status for the last 30 days" beats "show me data".
3

Review the result

You get the raw data table, the suggested chart, and the query that ran. If the chart is not what you want, switch chart types from the result toolbar.

How It Works

The flow is straightforward:

  1. Your question + the app schema is sent to the LLM provider for translation into a parameterized read query.
  2. The query runs against your app's PostgreSQL tables via DataConnect. Only SELECT-style operations are permitted; writes are blocked.
  3. Results are aggregated server-side and returned with a visualization spec (chart type, axes, group keys).
  4. The panel renders the chart and table; you can pivot, change chart type, or copy the underlying query.
Insights operates on your schema as defined in the Database. The cleaner your schema (good table names, descriptive columns, foreign keys), the more accurate translation gets.

Visualization

The translation step suggests a chart based on the shape of the result: bar charts for categorical breakdowns, line charts for time series, single-stat cards for scalar answers, tables for unbounded rows.

Save useful queries to the Insights history so teammates can re-run them without re-typing. Each saved query shows the original question, the suggested chart, and the last-run time.

Limits

  • 30 queries per user per app per hour.
  • 1 credit per query, charged to the user who ran it.
  • Read-only: INSERT / UPDATE / DELETE are blocked at translation time.
  • Editor or owner role required.

For automated reports rather than ad-hoc questions, pair Insights with a Scheduled Agent that runs the same query on a cron and emails the result.

FAQs

What kinds of questions can I ask?▾
Anything that can be answered by querying your app's data: counts, sums, breakdowns, time series, comparisons. "How many sign-ups by week this quarter?" "Top 10 customers by spend?" "Order count by status today?" The system translates the question into a query, runs it, and returns the data plus a visualization spec.
Does it ever modify my data?▾
No. Data Insights is read-only by design. Queries are SELECT-style only; INSERT, UPDATE, and DELETE are blocked at translation time.
How does it decide which chart to draw?▾
The translation step returns both the data and a visualization spec (chart type, axes, grouping). The frontend renders the suggested chart, but you can override the type from the result panel.
How is it billed?▾
Standard AI proxy credit applies (1 credit per query). The translation step uses the LLM provider configured for the DATA_INSIGHTS task.
Why am I rate-limited?▾
Each user can run 30 Data Insights queries per app per hour. The limit prevents accidental loops and keeps query costs predictable. If you need more, contact support.

Ready to build?

Create your first app for free, no credit card required.

App Auth (End-Users)CSV Import