Ask a question. Scout finds the answer and shows you where it looked.

An AI data analyst I built from scratch, so anyone can ask the data a question and check the answer for themselves.

Year
2026
Category
AI
Stack
Next.js · TypeScript · SQLite · OpenAI
Scout answering a question about expense vs plan, with KPIs, a chart and its sources

01 · The problem

Waiting on analysts, or trusting a black box.

Most people can’t query the data themselves, so every question becomes a request and a wait. The analysts who answer them become the bottleneck, and simple questions sit in a queue behind hard ones.

AI chat tools promise instant answers, but they don’t know which tables matter or what a metric means in your business. They answer confidently either way, and you can’t tell which answers to trust.

02 · What Scout does

Plain-English questions, answers you can check.

Ask Scout a business question the way you would ask a colleague. It finds the right data, runs the numbers and answers with the key figures, charts and a short written explanation, plus a “Where it looked” strip on every answer.

The public demo runs on a fictional sample company with Cloud and Retail businesses, is read-only and has a daily limit.

03 · Why you can trust it

Every answer shows its working.

  • Numbers come from checked queries

    Code runs every query and checks it before it touches the data. The AI model writes the explanation; it never makes up a figure.

  • It shows where it looked

    Every answer says which tables it read, which definitions it used and why it picked them, with the query itself one click away.

  • One meaning per metric

    Terms like “expense vs plan” are defined once and reused everywhere, so the same question always means the same thing.

  • It asks instead of guessing

    When a question could mean two things, Scout asks which one you meant rather than quietly picking one.

04 · Under the hood: the harness

The AI model is the engine; the harness is everything around it.

Scout’s harness is the code that decides what the model sees, what it is allowed to do and how its work gets checked. Business knowledge lives in small markdown files: tables, metric definitions and “skills” that describe how to answer a kind of question. For each question the harness loads only the files it needs, so a large knowledge base costs little to route through.

  1. 01

    Question

    A business question in plain English.

  2. 02

    Skill loading

    Code picks the one skill and the few files the question needs. The model only breaks ties.

  3. 03

    Query generation

    Each query is built from the skill’s plan and the table’s documented columns.

  4. 04

    Validation

    A guard allows one SELECT on one loaded table, with no joins, before anything runs.

  5. 05

    Answer + sources

    KPIs, charts and a written answer, with the skill, tables and queries behind it.

The data comes back first; then one model call writes the narrative and picks the views. If its plan fails the checks, one repair call gets a second try, and anything still failing falls back to the skill’s default views with a note.

05 · The stack

  • Next.js
  • TypeScript
  • node:sqlite
  • Markdown knowledge files
  • OpenAI gpt-4.1 (Anthropic supported)
  • Vitest
  • Docker on a VPS, behind nginx
Try Scout ↗