# Install fsql with Homebrew, MacPorts, Nix

Search through your filesystem with SQL-esque queries. Version 0.5.2 via Homebrew; verified 2026-07-25. Also installable with nix: nix profile install nixpkgs#fsql.

## 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
- **Version:** 0.5.2
- **Source summary:** Search through your filesystem with SQL-esque queries
- **Homepage:** <https://github.com/kashav/fsql>
- **Repository:** <https://github.com/kashav/fsql>
- **Last updated:** 2026-07-25T20:54:35-04:00
- **Generated:** 2026-08-03T19:37:03+00:00

## Executables

- fsql (alias)

## Install behavior

- Bottle: not available

## Freshness

- Page generated: 2026-08-03
- Package-manager version: 0.5.2
## 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

- <https://api.github.com/repos/kashav/fsql>
- <https://github.com/kashav/fsql>
- <https://raw.githubusercontent.com/kashav/fsql/master/README.md>


## Security Notes

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

- **Geiger risk:** blue / medium
- broad file, network, media, or database tool signal

## 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


## Combined YAML source

View the package source record on GitHub. [combined/fsql.yml](https://github.com/mxcl/pkgdb/blob/main/combined/fsql.yml)


## Sources

- pkg.so package database
- Geiger risk classifier
- curated package history
- pkgdb category and tag curation
- external package-manager database matches
- cross-ecosystem install command graph