duckdb-wasm / local session
SELECT json_extract_string(payload, '$.type')AS type, count(*) AS eventsFROM eventsGROUP BY typeORDER BY events DESCLIMIT 10
Local SQL session
typecount
page_view18
purchase7
sign_in4
example query
LOCAL SQL WORKBENCH / CSV, JSON, PARQUET & EXCEL
Query local files with SQL.In your browser.
Use the DuckDB SQL editor to query CSV, JSON, Parquet and Excel files. Explore their structure, build reusable views, and export results.
.CSV .JSON .PARQUET EXCEL (.XLSX, .XLS)
Invite-only beta.
Raw file contents stay in your browser.
local by default
0 bytes uploaded
parquet ready
EXPLORE THE STRUCTURE
See the tables
before the query.
RawQL infers column names and types, then shows how tables connect. Use that map to decide what to query or join.
- Inferred columns and types
- Visible join relationships
- Copy column names into SQL
orders12 cols
iduuidcustomer_iduuidcreated_attimestamp
customers8 cols
iduuidemailvarcharsegmentvarchar
products15 cols
skuvarcharpricedecimalstockinteger
active join
orders.customer_id = customers.idQUERY RESULT
SAMPLE DATARevenue growth
CHARTS AND PIVOTS
Summarize query
results visually.
Build a chart or pivot from the rows returned by your query. Export the result as CSV or JSON when you are ready.
Chartcompare values
Pivotgroup rows
CSV and JSON export
RAW FILE TO REUSABLE SQL
Explore. Transform.
Reuse.
Inspect the data, write a query, then save the SQL or create a view.
01
Load local files
CSV, JSON, Parquet, or Excel. Contents stay in browser memory.
LOCAL FILES02
Explore and analyze
Inspect columns, preview tables, profile results, and write SQL.
DUCKDB SQL03
Model and export
Create views, save SQL in notebooks, and export query results.
REUSABLE SQLLOCAL PROCESSING
Your files stay on your device.
SQL runs in your browser.
RawQL reads selected files in your browser and runs DuckDB WebAssembly there. The app server does not receive the raw file contents.
0raw file bytes
uploaded
uploaded
No file upload
Imported file contents stay in browser memory for the current session.
browser sessionDuckDB in the browser
SQL runs in a WebAssembly worker on your device.
local executionExport when ready
Download query results as CSV or JSON when you choose to use them elsewhere.
CSV or JSONFREQUENTLY ASKED QUESTIONS
A few practical
details.
Where are my files processed?
Raw files are read and queried in your browser using DuckDB WebAssembly. Raw file contents are not uploaded to the RawQL server.
Which file formats can I use?
RawQL supports CSV, JSON, Parquet, and Excel (.xlsx, .xls). Legacy .xls files are converted locally before DuckDB reads them.
Can I reuse a transformation?
Save SQL in worksheets or notebooks, and create DuckDB views during the session. Download the SQL or export query results when you want to reuse them.
What are the import limits?
Import up to three files per session, with a maximum of 100 MB per file. Query performance depends on your device.
LEARN WITH SAMPLE DATA
From file to first query.
Try a small dataset, inspect its columns and write SQL you can check against an expected result.
RAWQL / INVITE-ONLY BETA
Bring a file.
Shape it with SQL.
Inspect the structure, write a transformation, and keep the SQL for later.