sq
A command-line tool that provides jq-style access to structured data sources like SQL databases, CSV, and Excel files.
What is sq?
sq is a command-line data wrangling tool that treats diverse data sources—including SQL databases and document formats like CSV, Excel, and JSON—as queryable SQL databases. It enables users to inspect, query, join, and transform data across these sources with a unified interface, streamlining data operations without switching between different tools. The tool describes itself as the 'lovechild of sql+jq,' combining SQL's query power with jq's flexibility for structured data.
Data engineers, analysts, and developers who need to query, join, and transform data across multiple formats (e.g., SQL databases, CSV, Excel, JSON) from the command line. It is particularly useful for those performing data integration, migration, or inspection tasks in environments like Kubernetes, local development, or scripting pipelines.
Developers choose sq for its ability to perform cross-source joins (e.g., joining a CSV file with a Postgres table) and its support for multiple output formats (JSON, Excel, CSV, HTML, etc.), eliminating the need for separate tools. Its unique selling point is treating disparate data sources as unified SQL databases, offering a cohesive command-line experience with features like data diffing, result insertion into databases, and UNIX pipe integration.
Overview
sq data wrangler
Use Cases
Best For
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.
