winget install --id vmvarela.sql-pipeAbout sql-pipe
sql-pipe reads CSV from stdin, loads it into an in-memory SQLite database, runs a SQL query, and prints the results as CSV. No server, no schema files, no setup. If you know SQL and work with CSV in the terminal, this is the tool you have been reaching for.
What's new in 0.16.0
What's Changed 🚀 Features - feat: add --completions flag for shell completion generation (#175) (#189) @vmvarela - feat: add HTML table output format (-O html) (#188) @vmvarela - feat: add SQL INSERT output format (-O sql) (#187) @vmvarela - feat: add --schema flag to print inferred CREATE TABLE DDL (#186) @vmvarela - feat: add --explain flag for query plan introspection (#185) @vmvarela - feat: add --null-value flag for custom NULL representation (#184) @vmvarela 🐛 Bug Fixes - fix: BLOB hex encoding + full Unicode width tables (#190) @vmvarela 🧰 Maintenance - refactor: deduplicate visual/source helpers, simplify fmtThousands (#182) @vmvarela ⬆️ Dependency Updates - chore(deps): bump actions/cache from 5 to 6 (#183) @dependabot[bot] Full Changelog: v0.15.0...v0.16.0
Version history
| Version | Updated | Notes |
|---|---|---|
| 0.16.0 | What's Changed 🚀 Features - feat: add --completions flag for shell completion generation (#175) (#189) @vmvarela - feat: add HTML table output format (-O html) (#188) @vmvarela - feat: add SQL INSERT output format (-O sq... | |
| 0.15.0 | Unknown | What's Changed 🚀 Features - feat: add --stats flag for column statistics (#181) @vmvarela Full Changelog: v0.14.0...v0.15.0 |
| 0.14.0 | Unknown | What's Changed 🚀 Features - feat: add Markdown table output format (-O markdown) (#179) @vmvarela 🧰 Maintenance - refactor: ponytail cleanup - remove waste and simplify (#178) @vmvarela ⬆️ Dependency Updates - chore(deps... |
| 0.13.0 | Unknown | What's Changed 🚀 Features - feat: read SQL query from file with -f/--file flag (#157) (#165) @vmvarela - feat: auto-detect input format from file extension with -I override (#164) @vmvarela Full Changelog: v0.12.0...v0.1... |
| 0.12.0 | Unknown | What's Changed 🚀 Features - feat: pretty-printed table output with auto-detected TTY (#163) @vmvarela Full Changelog: v0.11.0...v0.12.0 |
| 0.11.0 | Unknown | What's Changed 🚀 Features - feat: positional file arguments and multi-file joins (#162) @vmvarela Full Changelog: v0.10.0...v0.11.0 |
| 0.9.0 | Unknown | 🚀 Features - --disk flag — use a file-backed SQLite temp database instead of :memory:, enabling datasets larger than available RAM. Also sets PRAGMA temp_store = FILE for transient structures. (#148) - --json-path <path>... |
| 0.8.1 | Unknown | What's Changed 🐛 Bug Fixes - fix: make --xml-root and --xml-row work for XML input parsing (#140) @vmvarela Full Changelog: v0.8.0...v0.8.1 |
| 0.8.0 | Unknown | 🚀 Features - Add XML input and output format support — --input xml / --output xml (#133) - Support multi-character input delimiters — e.g. --delimiter '||' (#132) - Add --sample <n> flag for quick data preview with schem... |
| 0.7.1 | Unknown | What's Changed - chore: remove redundant in-repo Nix and AUR packaging files (#125) @vmvarela - feat(packaging): centralize package repositories by package manager (#124) @vmvarela Full Changelog: v0.7.0...v0.7.1 |
| 0.7.0 | Unknown | What's Changed 🚀 Features - feat: add JSON and NDJSON input/output format support (#118) @vmvarela - feat: add TSV input and output format support (#120) @vmvarela 🧰 Maintenance - chore: fix release-drafter duplicate ent... |
| 0.6.0 | Unknown | 🚀 Features - Add --output <file> flag to write query results to a file (#115) - Add --columns flag to list CSV input column names (#113) - Progress indicator during CSV loading (#112) - Print row count after loading CSV... |
| 0.4.1 | Unknown | What's Changed - chore(deps): bump KSXGitHub/github-actions-deploy-aur from 4.1.1 to 4.1.2 (#103) @dependabot[bot] - fix(ci): include man page in generated Homebrew formula (#101) @vmvarela - ci: fix release-drafter dupl... |
| 0.4.0 | Unknown | 🚀 Features - Add --json output flag — results as a JSON array of objects (#74) - Add Alpine Linux .apk packages to release workflow (#75) 🧰 Maintenance - Add integration tests for --delimiter, --tsv, and --header flags (... |
| 0.3.0 | Unknown | Release notes |