Analyse data
Totals, rankings, comparisons and checks over every row, from one structured query.
- How do I get monthly totals from daily data with AI?
Ask your AI to group the rows by month and sum the value column, and give it a database to do it in. Over MCP it sends one structured query (group by the month, sum the...
- How do I find the top 10 customers by revenue with AI?
Have your AI group the orders by customer, sum the revenue, sort it descending and keep ten rows. With a database behind it that's one query over every order, so the ranking is...
- How do I calculate totals by week?
Group by a week column and sum. In the demo every order carries `order_week` (ISO weeks such as `2025-W10`), so your AI asks for revenue and order counts per week in one query...
- How do I compare two time periods in one query?
Filter to both periods and group by the period as well as what you're comparing. Your AI asks for revenue by region for 2024 and 2025 in one query and gets a row per region and...
- How do I calculate an average per group?
Ask for the average of the value column grouped by the category you care about. Your AI sends `avg` with a group-by and gets one exact average per group, here the average order...
- How do I find duplicate rows in a large table?
Count rows per key and look for counts above one. Your AI groups by the id column, counts, and sorts the counts descending: any id with a count of 2 or more is duplicated. On a...
- How do I see which rows changed between two versions of a table?
Read both versions at once with `AS OF ALLVERSIONS BETWEEN` the two dates, group by the row's key, and keep the keys whose values differ (`MIN(x) <> MAX(x)`) or that appear in...
- How do I find the min and max per group?
Ask for `min` and `max` of the column with a group-by. Your AI gets the lowest and highest value per group in one query, here the smallest and largest order per product...