NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
Go modules, #730 by repository stars
Latest stable
v0.55.0
Last release 20 days ago
02 Nov 2026
Ships on a steady schedule
a new release about every 1 weeks
Nearly every release is documented
notes for 57 of the last 60 stable releases
Nothing withdrawn
no release was ever pulled
6 years old
350 releases · first in 2020
Drag across the ruler to compare, or tap a release to open it.
☢️ Proprietary database functions are now invoked by prefixing the function name with an underscore. For example:
# mysql "date_format" func
$ sq '@sakila/mysql | .payment | _date_format(.payment_date, "%m")'
# Postgres "date_trunc" func
$ sq '@sakila/postgres | .payment | _date_trunc("month", .payment_date)'
sq diff: Renamed --count flag to --counts as intended.
sq diff: Renamed --count flag to --counts as intended.Your coding agent can read these notes before it upgrades. Set up the MCP server →
Nothing published for this version
The major feature is the long-gestating `sq diff`.
The major feature is the long-gestating sq diff.
sq diff compares two sources, or tables.sq inspect --dbprops is a new mode that returns only the DB properties.
Relatedly, the properties mechanism is now implemented for all four supported
DB types (previously, it was only implemented for Postgres and MySQL).sq inspect -v previously returned DB properties in a field named db_variables.
This field has been renamed to db_properties. The renaming reflects the fact
that some of those properties aren't really variables in the sense that they
can be modified (e.g. DB server version or such).db_variables (now db_properties) field has
changed. Previously it was an array of {"name": "XX", "value": "YY"} values,
but now is a map, where the keys are strings, and the values can be either
a scalar (bool, int, string, etc.), or a nested value such as an array
or map. This change is made because some databases (e.g. SQLite) feature
complex data in some property values.[777 bytes] instead of dumping
the raw bytes.--tsv) no longer has a shorthand form -T. Apparently that
shorthand wasn't used much, and -T is needed elsewhere.--xml no longer has shorthand -X. And --markdown has lost alias --md.--text, --json, etc., there is now
a --format=FORMAT flag, e.g. --format=json. This will allow sq to
continue to expand the number of output formats, without needing to have
a dedicated flag for each format.Nothing published for this version
Nothing published for this version
[#8]: Results can now be output in YAML.
Both --markdown and the alias --md are now supported.
--markdown and the alias --md are now supported.Nothing published for this version
Fixed a minor issue where sq ls -jv and sq ls -yv produced no output if config contained no explicitly set options.
sq ls -jv and sq ls -yv produced no output
if config contained no explicitly set options.Nothing published for this version
Alas, this release has several minor breaking changes ☢️.
This release significantly overhauls sq's config mechanism (#199).
For an overview, see the new config docs.
Alas, this release has several minor breaking changes ☢️.
sq config ls shows config.sq config get gets individual config option.sq config set sets config values.sq config edit edits config.
$EDITOR or $SQ_EDITOR.sq config location prints the location of the config dir.--config flag is now honored globally.$ sq config set log true
$ sq config set log.level INFO
$ sq config set log.file /var/log/sq.log
There are also equivalent flags (--log, --log.file and --log.level) and
envars (SQ_LOG, SQ_LOG_FILE and SQ_LOG_LEVEL).sq's config file (sq.yml) has changed. The config
file is automatically upgraded when using the new version.sq log file has changed. The new location
is platform-dependent. Use sq config get log.file -v to view the location,
or sq config set log.file /path/to/sq.log to set it.SQ_CONFIG replaces SQ_CONFIGDIR.SQ_LOG_FILE replaces SQ_LOGFILE.--table is renamed to --text. This is changed because while the
output is mostly in table format, sometimes it's just plain text. Thus
table was not quite accurate.sq has been
renamed from --driver to --ingest.driver. This change aligns
the naming of the ingest options and reduces ambiguity.# previously
$ cat mystery.data | sq --driver=csv '.data'
# now
$ cat mystery.data | sq --ingest.driver=csv '.data'
sq add no longer has the generic --opts x=y mechanism. This flag was
ambiguous and confusing. Instead, use explicit option flags.# previously
$ sq add ./actor.csv --opts=header=false
# now
$ sq add ./actor.csv --ingest.header=false
sq add --handle flag has been changed from -h to
-n. While this is not ideal, the -h shorthand is already in use everywhere
else as the short form of --header.# previously
$ sq add ./actor.csv -h @actor
# now
$ sq add ./actor.csv -n @actor
--pretty flag has been removed. Its only previous use was with the
json format, where if --pretty=false would output the JSON in compact form.
To better align with jq, there is now a --compact / -c flag that behaves
identically to jq.--compact / -c flag, the short form of the --csv
flag is changing from -c to -C. It's an unfortunate situation, but alignment
with jq's behavior is an overarching principle that justifies the change.The headline feature is source groups. This is the biggest change to the sq CLI in some time, and should make working with lots of sources much easier
The headline feature is source groups.
This is the biggest change to the sq CLI in some time, and should make working with lots of sources much easier.
sq now has a mechanism to group sources. A source handle can
now be scoped. For example, instead of @sakila_prod, @sakila_staging, etc,
you can use @prod/sakila, @staging/sakila. Use sq group prod to
set the active group (which sq ls respects). See docs.sq group GROUP sets the active group to GROUP.sq group returns the active group (default is /, the root group).sq ls GROUP lists the sources in GROUP.sq ls --group (or sq ls -g) lists all groups.sq mv moves/renames sources and groups.sq ls now shows the active item in a distinct color. It no longer adds
an asterisk to the active item.sq ls now sorts alphabetically when using --table format.sq ls now shows the sources in the active group only. But note that
the default active group is / (the root group), so the default behavior
of sq ls is the same as before.sq add hello.csv will now generate the handle @hello instead of @hello_csv.
On a second invocation, it will return @hello1 instead of @hello_csv_1. Why
this change? Well, with the availability of the source group mechanism, the _ character
in the handle somehow looked ugly. And more importantly, _ is a relative pain to type.sq ping has changed to support groups. Instead of sq ping --all, you can
do sq ping GROUP, e.g. sq ping /.Nothing published for this version
[#187]: For csv sources, sq will now try to auto-detect if the CSV file has a header row or not. Previously, this needed to be explicitly specified vi
#187: For csv sources, sq will now try to auto-detect if the CSV file
has a header row or not. Previously, this needed to be explicitly specified
via an awkward syntax:
$ sq add ./actor.csv --opts=header=true
This change makes working with CSV files significantly lower friction. A command like the below now almost always works as expected:
$ cat ./actor.csv | sq .data
Support for Excel/XLSX header detection is in #191.
sq is now better at detecting the (data) kind of CSV fields. It now more
accurately distinguishes between Decimal and Int, and knows how to
handle Datetime.
#189: sq now treats CSV empty fields as NULL.
[#173]: Predefined variables via --arg flag (docs): `shell $ sq --arg first TOM '.actor | .first_name == $first' `
Nothing published for this version
Nothing published for this version
Nothing published for this version
BREAKING CHANGE: The "star" version (.actor | count(*)) is no longer supported; use the naked version instead.
unique function (docs):$ sq '.actor | .first_name | unique'
This is equivalent to:SELECT DISTINCT first_name FROM actor
count_unique function (docs).$ sq '.actor | count_unique(.first_name)'
count function has been changed (docs)
.actor | count equivalent to SELECT COUNT(*) AS "count" FROM "actor"..actor | count(*)) is no longer supported; use the
naked version instead.sq token, not the SQL token.# previous behavior
$ sq '.actor | max(.actor_id)'
max("actor_id")
200
# now
$ sq '.actor | max(.actor_id)'
max(.actor_id)
200
Nothing published for this version
[#162]: group_by now accepts function arguments.
group_by now accepts function arguments.groupby to group_by to match jq.orderby to order_by to match jq.Nothing published for this version
[#160]: Use groupby() to group results. See query guide.
groupby() to group results. See query guide.Nothing published for this version
[#158]: Use orderby() to order results. See query guide.
orderby() to order results. See query guide.Nothing published for this version
[#98]: Whitespace is now allowed in SLQ selector names. You can do @sakila | ."film actor" | ."actor id".
[#153]: Improved formatting of text table with long lines.
[#15]: Column Aliases. You can now change specify an alias for a column (or column expression such as a function). For example: sq '.actor | .first_na
Nothing published for this version
Fixed typos in sq sql command help.
sq sql command help.Nothing published for this version
When a CSV source has explicit column names (via --opts cols=A,B,C), sq now verifies that the CSV data record field count matches the number of explic
--opts cols=A,B,C), sq now verifies
that the CSV data record field count matches the number of explicit columns.[#142]: Improved error handling when Postgres current_schema() is unavailable.
current_schema() is unavailable.[#144]: Handle corrupted config active source.
Nothing published for this version
sq ping now respects --json flag.
sq ping now respects --json flag.sq ping now respects --json flag.Nothing published for this version
sq ls now respects --json flag.
sq ls now respects --json flag.sq rm now respects --json flag.sq add now respects --json flag.`sq rm can delete multiple sources.sq rm doesn't print output unless --verbose.xxxxx instead of ****, to match stdlib url.URL.Redacted().--tags=netgo).Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
sq version respects --json flag.
sq version respects --json flag.sq version respects --verbose flag.sq version shows latest_version info when --verbose and there's a newer version available.sq version shows less info when --verbose is not set.Nothing published for this version
Nothing published for this version
Nothing published for this version
sq now generates manpages (and installs them).
sq now generates manpages (and installs them).Nothing published for this version
Nothing published for this version
Installer for Arch Linux, via Arch User Repository.
Nothing published for this version
Nothing published for this version
Nothing published for this version
The build pipeline now produces .apk packages for Alpine Linux, and install.sh has been updated accordingly. However, the .apk files are not yet publi
.apk packages for Alpine Linux,
and install.sh has been updated accordingly. However, the .apk files are not yet published to
a repository, so it's necessary to run apk against the downloaded .apk file (install.sh does
this for you).Nothing published for this version
Nothing published for this version
One column per quarter.