ABACUS_

Ask a question in the console, or assemble one from the cards. A deterministic compiler writes SQL against the fixture warehouse in your browser.

how the demo works This page runs a seeded fixture warehouse in SQLite in WebAssembly. The semantic layer defines each metric once. The board sends plans to a deterministic compiler. The optional LLM can only choose semantic layer fields. Its API key stays in this tab.
fetching the warehouse…
interactive recreation of the private system, replaying recorded fixtures
DATA: bundled warehouse · 126K ROWS
bring your own warehouse
or drop .csv, .sqlite, .db here25 MB · 300,000 rows max
Your file stays in this browser.
waiting for a file
mount preview
columntypeproposed roledistinctsample values

Build a question Start with a measure.

consoleType a question, or build it on the board below.
abacus ❯
Try a verb:
measure
drop a metric card from below…
group by
optional
optional
window
loading
comparisons are available for totals only No date column is mounted. Time features are off.
＋ filter
top N 10 members
pick a measure to arm the lever
compiled SQL

Pick a measure to compile its query.

Pick a measure and the compiler writes SQL here.
① pick a measure
② Add an optional slice, or pull RUN.
Let a live LLM arrange the board
The model only arranges cards on the board. The guarded compiler still writes the SQL. Your key stays in this tab. A field outside the semantic layer is rejected.

Run an investigation Use the current measure and window.

results, newest first no saved plan
Pull the lever or run a console question. Results are filed here.
fixture parity check
Run the committed fixture questions through the browser engine. Plans must match the Python reference. Values must match to the cent.