install

Additional install commands

macOS

Homebrewverified · 100%

brew install csvq

local Homebrew formula metadata

Linux

Alpine Linux apkverified · 92%

sudo apk add csvq

Alpine Linux edge package indexes · csvq · source: dl-cdn.alpinelinux.org

Nixverified · 92%

nix profile install nixpkgs#csvq

nixpkgs package indexes · pkgs/by-name/cs/csvq/package.nix · source: api.github.com

overview

Package summary

SQL-like query language for csv

Project links

Commands and aliases

csvq

history

Project history and usage

csvq is a Go command-line tool that brings a SQL-like query language to CSV and related text formats. It supports reading, updating, deleting, transactions, procedures, an interactive shell, and exports to formats such as JSON and text tables.

Project history

The official changelog marks version 1.0.0, released on September 19, 2017, as the first general release. Subsequent releases expanded the language and format surface, including analytic-function behavior, Go modules, JSON support, fixed-length input, JSON Lines output, and later Go 1.18 dependency updates.

Adoption history

The upstream README documents installation by release archive, Go install, Ubuntu PPA, Arch AUR packages, and Homebrew. That spread reflects csvq's role as a portable single-binary data tool rather than a library that must be embedded into an application.

How it is used

csvq is aimed at one-time queries and routine processing over data sizes that fit in memory and are comparable to spreadsheet workloads. The README explicitly warns that it is not optimized for very large data because query execution keeps data in memory and does not use indexes or query planning.

Why package nerds care

For package users, csvq occupies the SQL-on-flat-files niche: more expressive than simple cut/filter tools, lighter to install than a database, and useful in scripts when CSV, TSV, fixed-width, JSON, or JSON Lines files need ad hoc querying.

Timeline

2017: Version 1.0.0 first general release.
2018: Version 1.3.0 enhanced JSON support; version 1.5.0 added fixed-length format support.
2022: Version 1.16.0 added JSON Lines and BOX export formats.
2023: Version 1.18.x updated dependencies and required Go 1.18 or later.

Related projects

The README links csvq-driver for executing csvq statements in Go and a csvq Emacs extension, showing a small ecosystem around the command language.

Sources

security posture

Risk level: blue

broad file, network, media, or database tool signal.

Risk classifier

blue risk · medium confidence · tool

Why

broad file, network, media, or database tool signal

Signals

text:sql

Install behavior

No Homebrew post-install hook is recorded in formula metadata.
Homebrew bottle metadata is available for 12 platform targets.
Build metadata lists 1 build dependencies.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

executables

Installed executables

Command	Kind	Exposure	Note
`csvq`	cli	global executable

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-07-08

manager version1.18.1

manager updated

local dataok

upstreamcurrent

latest detectedv1.18.1

https://github.com/mithrandie/csvq

infoNo package-manager update timestamp was available.low confidence

install metadata

Package metadata

Package key	brew:csvq
Version	1.18.1
Package manager	Homebrew
Package manager page	https://formulae.brew.sh/formula/csvq
Homepage	https://mithrandie.github.io/csvq
Repository	https://github.com/mithrandie/csvq
Upstream docs	https://mithrandie.github.io/csvq
License	MIT
Source archive	https://github.com/mithrandie/csvq/archive/refs/tags/v1.18.1.tar.gz
Build dependencies	go
Bottle	available (on arm64_big_sur, arm64_linux, arm64_monterey, arm64_sequoia, arm64_sonoma, arm64_tahoe, arm64_ventura, big_sur, monterey, sonoma, ventura, x86_64_linux)
Homebrew post-install	not defined
Service	none declared

registry facts

Source database details

Source Database	Homebrew formula API
Tap	homebrew/core
Full Name	csvq
Version Scheme	0
Revision	0
Head Version	HEAD
Bottle Stable Root URL	https://ghcr.io/v2/homebrew/core
Deprecated	no
Disabled	no
Keg Only	no
URL Keys	head stable

source database matches

Other package-manager records

Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.

Nix95%

csvq

nix profile install nixpkgs#csvq

normalized package name match
Matched by: Csvq

nixpkgs package indexes · api.github.com · nixpkgs package indexes: pkgs/by-name/cs/csvq/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1

apk95%

csvq 1.18.1-r27

SQL-like query language for csv format

https://github.com/mithrandie/csvq

sudo apk add csvq

License: MIT
Architecture: x86_64
Source Package: csvq
1 dependencies
1 provides
normalized package name match
Matched by: Csvq

Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: csvq from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz

package graph

Links come from deterministic package relationships, av.db category and tag curation, ecosystem matches, and package hub membership.

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Combined YAML source

View the package source record on GitHub.

combined/csvq.yml

Used sources

Geiger risk classifier
Nucleus package database
av.db category and tag curation
cross-ecosystem install command graph
curated package history
external package-manager database matches
package relationship graph
package version freshness
package-page enrichment

Install csvq with Homebrew, apk, Nix