fselect – find files with SQL-like queries

fselect is a command-line utility to find files with SQL-like queries.

Usage: fselect [ARGS] COLUMN[, COLUMN…] [from PATH[, PATH…]] [where EXPR] [group by COLUMN, …] [order by COLUMN (asc|desc), …] [limit N] [into FORMAT]

This is free and open source software.

Features include:

• SQL-like grammar easily understandable by humans.
• Complex queries.
• Aggregate, statistics, date, and other functions.
• Search within archives.
  • .gitignore, .hgignore, and .dockerignore support (experimental).
• Search by width and height of images, EXIF metadata.
• Search by MP3 info.
• Search by extended file attributes.
• Search by file hashes.
• Search by MIME type.
• Shortcuts to common file types.
• Interactive mode.
• Various output formatting (CSV, JSON, and others).
• Files Detected as Archives: .7z, .bz2, .bzip2, .gz, .gzip, .lz, .rar, .tar, .xz, .zip
• Files Detected as Audio: .aac, .aiff, .amr, .flac, .gsm, .m4a, .m4b, .m4p, .mp3, .ogg, .wav, .wma
• Files Detected as Book: .azw3, .chm, .djvu, .epub, .fb2, .mobi, .pdf
• Files Detected as Document: .accdb, .doc, .docm, .docx, .dot, .dotm, .dotx, .mdb, .odp, .ods, .odt, .pdf, .potm, .potx, .ppt, .pptm, .pptx, .rtf, .xlm, .xls, .xlsm, .xlsx, .xlt, .xltm, .xltx, .xps
• Files Detected as Image: .bmp, .exr, .gif, .heic, .jpeg, .jpg, .jxl, .png, .psb, .psd, .svg, .tga, .tiff, .webp
• Files Detected as Source Code: .asm, .bas, .c, .cc, .ceylon, .clj, .coffee, .cpp, .cs, .d, .dart, .elm, .erl, .go, .groovy, .h, .hh, .hpp, .java, .jl, .js, .jsp, .jsx, .kt, .kts, .lua, .nim, .pas, .php, .pl, .pm, .py, .rb, .rs, .scala, .sol, .swift, .tcl, .ts, .vala, .vb, .zig
• Files Detected as Video: .3gp, .avi, .flv, .m4p, .m4v, .mkv, .mov, .mp4, .mpeg, .mpg, .webm, .wmv
• Cross-platform software – runs under Linux, macOS, and Windows.

Website: github.com/jhspetersson/fselect
Support:
Developer: jhspetersson
License: MIT License or Apache License 2.0

fselect is written in Rust. Learn Rust with our recommended free books and free tutorials

Alternatives to find

Explore Linux
	Best Free and Open Source Software - A huge collection of recommended free and open source software covering every major category.
	In-depth Linux Software Reviews - Detailed assessments of Linux software covering features, usability and overall quality.
	The Big List of Active Linux Distros - An extensive collection of actively developed Linux distributions.
	Open Source Alternatives - Alternatives to software and services from Google, Microsoft, Apple, Adobe, IBM, Autodesk, Oracle and others.
	Essential Linux System Tools - Indispensable utilities for monitoring, maintaining and managing Linux systems.
	Linux Productivity Tools - Useful utilities for improving productivity and streamlining everyday tasks.
	Alternatives to Popular CLI Tools - Modern alternatives to familiar command-line utilities supplied with Linux systems.
	Awesome Free Linux Game Tools - Tools, utilities and companion software that improve gaming on Linux.
	Machine Learning on Linux - Machine learning and deep learning software, self-hosted applications and practical tools.
	Saving Money with Linux - Practical ways to reduce electricity consumption and lower computing costs with Linux.
	Linux Candy - Fun, entertaining and sometimes delightfully quirky software from the lighter side of Linux.