sq
An open-source command-line tool to inspect, query, join, import and export data across databases and files.
These buttons open the developer's own site, repository or store listing in a new tab. wares.gg does not host downloads.
1 more ways to get sq
Package managers
- Homebrew
brew install sq
About sq
sq is a data wrangling tool for the terminal, described as jq for databases and documents. Its query language, SLQ, allows one-liners that select tables and columns from a source such as a Postgres database.
It can diff database tables, show schema metadata as JSON for piping into jq, and import data such as an Excel worksheet into a Postgres table while trying to preserve data types. It installs via Homebrew, Scoop, an install script and apt, yum, apk and pacman packages.
Strengths
- One query syntax across databases and document files
- Imports Excel sheets into database tables
- Diffs table metadata and row values
- JSON output that pipes cleanly into jq
Limitations
- Its SLQ query language has to be learned alongside SQL
- Command-line only, with no graphical interface
Details
- Pricing
- FreeFree and open source.
- License
- Open source, license not stated
- Developer
- Neil O'Toole
- Platforms
- Windows, macOS, Linux, Command line
- How it runs
- Downloadable app
- Account
- Not required
- Works offline
- Yes
- Best suited for
- Developers who move and compare data between databases from the terminal
- Categories
- CLI tools, Database tools
- Last verified
- Added
- Provenance
- Facts checked against the developer's own pages and store listings, 1 sources on file.
Alternatives to sq
Compare allSoftware that can replace sq for an important use case, and what changes if you switch.
usql
Use one command-line interface for many database systems.
usql gives one command-line interface across many database systems using ordinary SQL instead of the SLQ language, but it lacks sq's import, join and diff features.
trdsql
Query structured files with SQL from the command line.
trdsql runs plain SQL over structured files from the command line under MIT, focusing on file querying rather than moving and comparing data between databases.
sq as an alternative
Listings that name sq as an alternative.
sqlite-utils
A Python command-line tool and library for creating, querying and transforming SQLite databases.
sq imports and exports data across databases and files, including Excel into tables, but uses its own SLQ query language and is not a Python library.
Similar software
Related functionality, not necessarily a direct replacement.
VisiData
An interactive terminal multitool for exploring, cleaning and converting tabular data in many formats.
DuckDB
In-process analytical database that queries CSV, JSON and Parquet directly.
Harlequin
A SQL IDE that runs in the terminal, with adapters for DuckDB, SQLite, Postgres and more.
dblab
An open-source terminal UI client for browsing and querying PostgreSQL, MySQL, SQLite and other databases.
