SQL WORKSPACE · SQLITE
Query editor
Ask questions of your data. Turn results into something you can act on.
Active database
Demo SQLite
In-browser SQLite engine
Available tables
4
Ready to query
Saved queries
0
Stored on this device
DATA EXPLORER
4 TABLESDemo SQLiteCONNECTED
Choose a table to preview its columns and row count.
Ctrl / ⌘ + Enter to run
SQLite is ready. Run the starter query or write your own.
Query results
No query has been run yetYour results will appear hereRun a SQL query to see rows from your database.
Chart axes are inferred from your query result. Switch to Chart to explore the output visually.
This static edition runs SQLite locally in your browser. Query results and imported files are not uploaded. The Analyst home →
YOUR LIBRARY
Saved queries
Reuse useful SQL without starting from scratch.
No saved queries yetSave a query from the editor and it will appear here.
REPORTING
Dashboards
Keep useful query views together in a lightweight dashboard.
No dashboards yetRun a query and choose “Add to dashboard” to save a result view.
CONNECTIONS
Data sources
Connect a local SQLite database or bring in a CSV file.
▣
Demo SQLiteBuilt-in sample database · SQLite · Connected in this browser
Connected▧
Import SQLite databaseOpen an existing .db or .sqlite file in this browser session.
⇧
Import CSV as a tableUpload a CSV file and QueryNest will create a table you can query.
↓
Download SQLite databaseExport the current database, including tables you imported.
ⓘ
Local-first data handlingYour database is held in browser memory for this session. Imported files are not sent to The Analyst.