🗃️

SQL on CSV

Write real SQL queries against your CSV files locally in the browser.

How SQL on CSV Works

  • Virtual Table — Your CSV is registered as t1. Query it like any SQL table.
  • Result Cache — Query results are stored in cached_result, ensuring preview and export are always consistent.
  • Schema Awareness — Click Schema to see inferred column types. Shift+Click to insert column names directly into your query.
  • Read-Only Safety — Only SELECT/WITH/SHOW/DESCRIBE/EXPLAIN queries are allowed. Write operations are blocked at both application and engine level.
  • 100% Local — Powered by DuckDB WebAssembly. No data leaves your browser.