# jhspetersson/fselect

Find files with SQL-like queries

Repository: https://github.com/jhspetersson/fselect
Canonical: https://ross.abutalabs.com/products/fselect
Homepage: https://fselect.rocks
Language: Rust
License: Apache-2.0
License Family: permissive
Topics: find, files, filesystem, query, cli, sql-like, tool, utility, rust, sql, hacktoberfest, command-line
Last push: 2026-08-16T20:18:34+00:00

## Health v2 (maintenance only)
Score: 91/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 98, release rhythm 78, longevity 100
- inputs: {"age_days": 3141, "days_push": 17, "days_rel": 66, "gap_med": 48, "n_releases_24m": 12}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 4458, forks 86 (observed 2026-08-28T04:08:50.651988+00:00)

## What it is
fselect is a Rust command-line utility that lets users find files using SQL-like queries instead of cryptic find flags. It supports aggregate functions, subqueries, media metadata search, archive inspection, and multiple output formats like CSV and JSON.

## Use cases
- find files with sql-like queries
- search files by size larger than 1gb
- find images by exif metadata like camera model or gps
- search mp3 files by artist or bitrate
- query files inside zip archives
- get statistics like count and average size of files in a directory
- respect gitignore when searching files
- output file search results as json or csv

## When to choose
- you find find's flag syntax hard to remember and prefer SQL-like queries
- you need to filter files by rich metadata such as EXIF, audio tags, hashes, or MIME type
- you want aggregate statistics or subqueries comparing files across directories
- you need structured output (CSV, JSON, HTML) for downstream tools

## When to avoid
- you need a POSIX-standard find replacement for scripts that must be portable
- you only need simple filename globbing where ls or find suffice
- you need real SQL against a database rather than a filesystem query tool

## Facets
- artifact type: cli-tool
- maturity: active
- function: search-engine, cli, developer-tools
- domain: files, developer-tools
- platform: windows, cli, cross-platform
- tags: sql-like-queries, file-search, find-alternative, rust, exif, audio-metadata, archive-search, gitignore, command-line, linux, macos

## Member repositories
- jhspetersson/fselect (main) score 91

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:50.651988+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T18:20:43.515728+00:00, confidence not recorded.
  - readme: https://github.com/jhspetersson/fselect (fetched 2026-08-28T04:08:50.651988+00:00, sha 175a31f5ea64)
  - homepage: https://fselect.rocks (fetched 2026-08-29T09:07:31.369367+00:00, sha 2ed92c2b60ba)
  - registry_crates: https://crates.io/api/v1/crates/fselect (fetched 2026-08-29T09:07:31.379172+00:00, sha 8e4c91a5d7a8)
- Data as of 2026-08-30T08:39:29.467469+00:00.