# Install fsql with Homebrew, MacPorts, Nix Search through your filesystem with SQL-esque queries. Version 0.5.2 via Homebrew; verified from local package data. ## Install ```sh sudo av install brew:fsql ``` Additional install commands: ### macOS - Homebrew (100%): ```sh brew install fsql ``` Evidence: local Homebrew formula metadata - MacPorts (94%): ```sh sudo port install fsql ``` Evidence: MacPorts ports tree: sysutils/fsql/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1 ### Linux - Nix (92%): ```sh nix profile install nixpkgs#fsql ``` Evidence: nixpkgs package indexes: pkgs/by-name/fs/fsql/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 ## Package facts - **Package key:** brew:fsql - **Package manager:** Homebrew - **Package manager page:** - **Version:** 0.5.2 - **Source summary:** Search through your filesystem with SQL-esque queries - **Homepage:** - **Repository:** - **Upstream docs:** - **License:** MIT - **Source archive:** - **Generated:** 2026-07-08T18:08:21+00:00 ## Executables - fsql (cli) - fsql (alias) ## Build dependencies - go ## Install behavior - Post-install hook: not defined - Bottle: available on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux ## Freshness - Page generated: 2026-07-08 - Package-manager version: 0.5.2 - Local data: ok - Upstream repository: https://github.com/kashav/fsql - Upstream latest detected: v0.5.2 (current) - info: No package-manager update timestamp was available. ## Project history and usage fsql is a Go command-line tool that searches a filesystem using SQL-like queries. ### Project history The fsql repository was created in 2017. Its README presents the tool as a filesystem search utility with a query language modeled on SELECT, FROM, and WHERE clauses rather than as a database server or indexer. ### Adoption history The official README documents installation from release binaries, Go source, Homebrew, and manual builds. The supplied package data also records packaging in Homebrew, MacPorts, and Nix. ### How it is used fsql accepts a query on the command line or through stdin and can also run interactively. Queries select file attributes such as name, size, time, hash, and mode from one or more filesystem paths. The README documents SQL-like operators including equality, LIKE, regular-expression matching, numeric comparisons, boolean conjunctions, negation, and output modifiers for hashes, case, paths, sizes, and times. ### Why package nerds care fsql is notable as a small package-manager-friendly CLI that puts a relational query idiom over ordinary files. Its appeal is less about infrastructure scale and more about making ad hoc filesystem inspection scriptable. ### Timeline - 2017: Public GitHub repository created. - 2017: README documented binary, Go, Homebrew, and manual installation paths. - 2024: Upstream repository metadata showed continued maintenance activity. ### Related projects - The tool sits in the same practical space as find, mdfind, and other filesystem search CLIs, but the official README frames it specifically around a SQL-esque query 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:** fsql - **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 - fsql: normalized package name match | nixpkgs package indexes: pkgs/by-name/fs/fsql/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 - MacPorts - fsql: normalized package name match | MacPorts ports tree: sysutils/fsql/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1 ## 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. - [fselect](https://www.automicvault.com/pkg/brew/fselect/) - Shares av.db curated category or tags: cli, developer-tools, file-search, filesystem, sql-like-query. - [broot](https://www.automicvault.com/pkg/brew/broot/) - Shares av.db curated category or tags: cli, developer-tools, filesystem. - [fclones](https://www.automicvault.com/pkg/brew/fclones/) - Shares av.db curated category or tags: cli, developer-tools, filesystem. - [fuzzy-find](https://www.automicvault.com/pkg/brew/fuzzy-find/) - Shares av.db curated category or tags: cli, developer-tools, file-search. - [lndir](https://www.automicvault.com/pkg/brew/lndir/) - Shares av.db curated category or tags: cli, developer-tools, filesystem. - [mpremote](https://www.automicvault.com/pkg/brew/mpremote/) - Shares av.db curated category or tags: cli, developer-tools, filesystem. - [nfd2nfc](https://www.automicvault.com/pkg/brew/nfd2nfc/) - Shares av.db curated category or tags: cli, developer-tools, filesystem. - [pipe-rename](https://www.automicvault.com/pkg/brew/pipe-rename/) - Shares av.db curated category or tags: cli, developer-tools, filesystem. - [jump](https://www.automicvault.com/pkg/brew/jump/) - Local package facts share a topical domain. Shared terms: cli, developer, developer-tools, file, filesystem. ## Combined YAML source View the package source record on GitHub. [combined/fsql.yml](https://github.com/automic-vault/db/blob/main/combined/fsql.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