{"repo":"nao1215/sqly","free":true,"listed":false,"github":"https://github.com/nao1215/sqly","clone":"git clone https://github.com/nao1215/sqly.git","description":"executes SQL against CSV, TSV, LTSV, JSON, JSONL, Parquet, Microsoft Excel™ , ACH, and Fedwire files with shell.","language":"Go","stars":174,"topics":["command-line","command-line-tool","golang","csv","sql","sqlite3","tsv","ltsv","excel","cross-platform"],"license":"MIT","category":"cli-tools","readme_excerpt":"sqly sqly runs SQL against CSV, TSV, LTSV, JSON, JSONL, Parquet, Excel, ACH, and Fedwire files. It loads them into an in-memory SQLite3 database, so joins, CTEs, window functions, and aggregates all work — across formats, in one query. Compressed files ( .gz , .bz2 , .xz , .zst , .z , .snappy , .s2 , .lz4 ) are read transparently. Documentation: https://nao1215.github.io/sqly/ This documentation describes v1.0.0 . It carries substantial breaking changes over v0.x — classified exit codes, visible-only Excel sheets, SIGTERM 143 , multiple inputs as one atomic import, a schema-only --inspect , default-deny remote input, stdout carrying nothing but data in every machine-readable format, an export that refuses a value it cannot write rather than changing it, a shell with .header removed, .mode limited to formats a screen can show, and its history in a text file, and a text input that is not valid UTF-8 refused rather than loaded as mojibake — so read the CHANGELOG before upgrading. Try it in 30 seconds If you have Go, paste this: The file is the table: staff.csv became staff . No schema to declare, no import step. Why sqly? Pick the tool that fits the job: You want Use :-- :-- A field-oriented text processor for logs and columns awk, Miller A CSV-native SQL dialect with its own engine and cursors csvq SQL over CSV/TSV/JSON with a choice of backend engines trdsql SQL over CSV with long-standing, mature tooling q, textql SQL over files, with an interactive shell, cross-format joins,","default_branch":null,"files":null,"tree":[],"storefront":"/r/nao1215","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/nao1215/sqly/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}