# Install csvq with Homebrew, apk, Nix SQL-like query language for csv. Version 1.18.1 via Homebrew; verified from local package data. ## Install ```sh sudo av install brew:csvq ``` Additional install commands: ### macOS - Homebrew (100%): ```sh brew install csvq ``` Evidence: local Homebrew formula metadata ### Linux - apk (92%): ```sh sudo apk add csvq ``` Evidence: Alpine Linux edge package indexes: csvq from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz - Nix (92%): ```sh nix profile install nixpkgs#csvq ``` Evidence: nixpkgs package indexes: pkgs/by-name/cs/csvq/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 ## Package facts - **Package key:** brew:csvq - **Package manager:** Homebrew - **Package manager page:** - **Version:** 1.18.1 - **Source summary:** SQL-like query language for csv - **Homepage:** - **Repository:** - **Upstream docs:** - **License:** MIT - **Source archive:** - **Generated:** 2026-07-08T07:18:31+00:00 ## Executables - csvq (cli) - csvq (alias) ## Build dependencies - go ## Install behavior - Post-install hook: not defined - 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 ## Freshness - Page generated: 2026-07-08 - Package-manager version: 1.18.1 - Local data: ok - Upstream repository: https://github.com/mithrandie/csvq - Upstream latest detected: v1.18.1 (current) - info: No package-manager update timestamp was available. ## 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 Notes broad file, network, media, or database tool signal. - **Geiger risk:** blue / medium - broad file, network, media, or database tool signal ## 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:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** no - **URL Keys:** head, stable ## Other Package-Manager Records - Nix - csvq: normalized package name match | nixpkgs package indexes: pkgs/by-name/cs/csvq/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 - apk - csvq - 1.18.1-r27: normalized package name match | Alpine Linux edge package indexes: csvq from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz | SQL-like query language for csv format | https://github.com/mithrandie/csvq ## Related links - [Source-control packages](https://www.automicvault.com/pkg/source-control-tools/) - Belongs to a source-control command family. - [Secret-risk packages](https://www.automicvault.com/pkg/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals. - [Terminal utility packages](https://www.automicvault.com/pkg/terminal-utilities/) - Matched terminal and command-line workflow metadata. - [Text processing packages](https://www.automicvault.com/pkg/text-processing-tools/) - Matched text, document, or structured-data processing metadata. - [go](https://www.automicvault.com/pkg/brew/go/) - Build dependency declared by Homebrew. - [csvlens](https://www.automicvault.com/pkg/brew/csvlens/) - Shares av.db curated category or tags: cli, csv, data. - [csvkit](https://www.automicvault.com/pkg/brew/csvkit/) - Shares av.db curated category or tags: cli, csv, data. - [csvtk](https://www.automicvault.com/pkg/brew/csvtk/) - Shares av.db curated category or tags: cli, csv, data. - [prqlc](https://www.automicvault.com/pkg/brew/prqlc/) - Shares av.db curated category or tags: cli, data, query-language, sql. - [qsv](https://www.automicvault.com/pkg/brew/qsv/) - Shares av.db curated category or tags: cli, csv, data. - [steampipe](https://www.automicvault.com/pkg/brew/steampipe/) - Shares av.db curated category or tags: cli, data, query, sql. - [xan](https://www.automicvault.com/pkg/brew/xan/) - Shares av.db curated category or tags: cli, csv, data. - [zsv](https://www.automicvault.com/pkg/brew/zsv/) - Shares av.db curated category or tags: cli, csv, data. - [dsq](https://www.automicvault.com/pkg/brew/dsq/) - Both packages work with overlapping file formats or content types. Shared terms: cli, csv, data, query, sql. ## Combined YAML source View the package source record on GitHub. [combined/csvq.yml](https://github.com/automic-vault/db/blob/main/combined/csvq.yml) ## Sources - Nucleus package database - Geiger risk classifier - package-page enrichment - curated package history - package version freshness - av.db category and tag curation - package relationship graph - external package-manager database matches - cross-ecosystem install command graph