install

Additional install commands

macOS

Homebrewverified · 100%

brew install fsql

local Homebrew formula metadata

MacPortsverified · 94%

sudo port install fsql

MacPorts ports tree · sysutils/fsql/Portfile · source: api.github.com

Linux

Nixverified · 92%

nix profile install nixpkgs#fsql

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

overview

Package summary

Search through your filesystem with SQL-esque queries

Project links

Commands and aliases

fsql

history

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 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 6 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
`fsql`	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 version0.5.2

manager updated

local dataok

upstreamcurrent

latest detectedv0.5.2

https://github.com/kashav/fsql

infoNo package-manager update timestamp was available.low confidence

install metadata

Package metadata

Package key	brew:fsql
Version	0.5.2
Package manager	Homebrew
Package manager page	https://formulae.brew.sh/formula/fsql
Homepage	https://github.com/kashav/fsql
Repository	https://github.com/kashav/fsql
Upstream docs	https://github.com/kashav/fsql#readme
License	MIT
Source archive	https://github.com/kashav/fsql/archive/refs/tags/v0.5.2.tar.gz
Build dependencies	go
Bottle	available (on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, 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	fsql
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%

fsql

nix profile install nixpkgs#fsql

normalized package name match
Matched by: Fsql

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

MacPorts95%

fsql

sudo port install fsql

normalized package name match
Matched by: Fsql

MacPorts ports tree · api.github.com · MacPorts ports tree: sysutils/fsql/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1

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/fsql.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 fsql with Homebrew, MacPorts, Nix