SQL-pipe – Query CSV streams with SQLite syntax (written in Zig)
SQL queries on CSV streams—instant, zero-setup alternative to awk and sqlite3 boilerplate.
Lightweight SQL query runner with GUI and CLI support. Execute queries from files, handle retries, and export results to Excel/CSV. Comes with a demo SQLite database and sample queries.
Exports straight from .sql to XLSX/CSV with sensible niceties — template-aware Excel exports, CSV profiles (delimiter/encoding/quoting/date formats), retry handling for deadlocks, and a demo SQLite so you can try it immediately. It’s not trying to be a BI stack; it’s focused on the boring but painful task of re-running queries and producing predictable spreadsheets. If you want multi-step ETL, dashboards, or semantic modeling, this isn’t it — but for quick, repeatable reports it’s pragmatic and usable out of the box.
Analysts, ops/reporting engineers, small internal teams, non-technical users who need repeatable exports
kkr-query2xlsx runs SQL (GUI or CLI) and exports results to:
* XLSX (supports templates - useful for formatting / existing sheets) * CSV (custom delimiters / encodings)
It includes a SQLite demo, so you can try it without any database setup. MIT-licensed.
Windows build: https://github.com/kkrysztofczyk/kkr-query2xlsx/releases Feedback/bugs (please avoid sensitive data): https://github.com/kkrysztofczyk/kkr-query2xlsx/issues/new/c...
SQL queries on CSV streams—instant, zero-setup alternative to awk and sqlite3 boilerplate.
1.3MB WASM database beats DuckDB 5x on 10M row analytics, runs in Cloudflare Workers.
WASM engine handles millions of rows when Excel chokes on large files.
MCP server for spreadsheets when every other AI tool sends your data to the cloud.
SQL joins on CSV files without Pandas—but you need Tabularis to use it.
DuckDB-Wasm runs SQL queries on dropped files directly in your browser, no server needed.