dsq
A command-line tool for running SQL queries against JSON, CSV, Excel, Parquet, and other structured data files.
What is dsq?
dsq is a command-line tool that allows users to run SQL queries directly against structured data files like JSON, CSV, Excel, and Parquet. It solves the problem of needing to import data into a database before querying, enabling quick data exploration and transformation from the terminal.
Data analysts, developers, and system administrators who work with multiple data formats and need to quickly query or transform files without setting up a full database.
Developers choose dsq for its simplicity, broad file format support, and the ability to use familiar SQL syntax for ad-hoc data analysis, making it a versatile alternative to format-specific tools or heavier database solutions.
Overview
Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.
Use Cases
Best For
- Querying CSV or JSON files with SQL without importing them into a database
- Joining data from different file formats (e.g., CSV with JSON) in a single SQL query
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
