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.
 Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more. Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |