← Package directory
Available on winget

Install sql-pipe

Read CSV from stdin, query with SQL, write CSV to stdout

Install with winget
winget install --id vmvarela.sql-pipe
Upgrade
winget upgrade --id vmvarela.sql-pipe
Uninstall
winget uninstall --id vmvarela.sql-pipe

About 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.24.0

What's Changed πŸš€ Features - feat: replace carquet C library with pure Zig zig-parquet (#217) @vmvarela Full Changelog: v0.23.0...v0.24.0

Read release notes

Version history

Version Updated Notes
0.24.0 Unknown What's Changed πŸš€ Features - feat: replace carquet C library with pure Zig zig-parquet (#217) @vmvarela Full Changelog: v0.23.0...v0.24.0
0.23.0 Unknown What's Changed πŸš€ Features - feat: Add --checksum flag for SHA-256 result set hashing (issue #204) (#215) @vmvarela πŸ› Bug Fixes - fix: UTF-8 console output on Windows (Issue #201) (#216) @vmvarela 🧰 Maintenance - chore(de...
0.22.0 Unknown What's Changed πŸš€ Features - feat: ponytail cleanup v0.22 β€” native REPL, fused inspect modes, -50KB binary (#213) @vmvarela Full Changelog: v0.21.0...v0.22.0
0.21.0 Unknown What's Changed πŸš€ Features - feat: support multiple --url arguments with per-URL format and headers (#211) @vmvarela Full Changelog: v0.20.0...v0.21.0
0.20.0 Unknown What's Changed πŸš€ Features - feat: Apache Parquet input support (issue #206) (#210) @vmvarela Full Changelog: v0.19.0...v0.20.0
0.19.0 Unknown What's Changed πŸš€ Features - feat: --save <file> flag to persist SQLite DB to disk (#196) (#208) @vmvarela - feat(repl): add --repl interactive mode (#199) (#209) @vmvarela Full Changelog: v0.18.1...v0.19.0
0.18.1 Unknown What's Changed πŸ› Bug Fixes - fix: c_allocator, math functions, --no-stdin, validate ragged rows, leading-zero TEXT (#195) @vmvarela Full Changelog: v0.18.0...v0.18.1
0.18.0 Unknown What's Changed πŸš€ Features - feat: add native HTTP input (#194) @vmvarela 🧰 Maintenance - chore(deps): bump KSXGitHub/github-actions-deploy-aur from 4.1.3 to 4.2.0 (#192) @dependabot[bot] Full Changelog: v0.17.1...v0.18.0
0.17.1 Unknown What's Changed - feat: add YAML input support (-I yaml) with bundled libyaml 0.2.5 Full Changelog: v0.17.0...v0.17.1
0.16.0 Unknown 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...