sql-pipe is a command-line utility that lets you run SQL queries directly against CSV data streamed through standard input. It loads CSV data into an in-memory SQLite database, executes your query, and writes the results back out as CSV.
The project is designed for fast terminal-based data analysis without requiring a database server, schema files, or extra runtime dependencies.
This is free and open source software.
Key Features
- Reads CSV data from standard input and queries it with SQL.
- Uses an in-memory SQLite database for fast ad hoc analysis.
- Outputs query results as comma-separated values.
- Automatically detects INTEGER, REAL, and TEXT column types from input data.
- Supports custom delimiters and TSV input.
- Handles quoted column names, including names containing spaces.
- Works well in shell pipelines for multi-stage command-line data processing.
- Provides pre-built binaries for Linux, macOS, and Windows.
Website: github.com/vmvarela/sql-pipe
Support:
Developer: Victor M. Varela
License: Mozilla Public License Version 2.0
sql-pipe is written in Zig. Learn Zig with our recommended free tutorials.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.