fsql

Query your filesystem with SQL-like syntax instead of find commands

brewmacoslinux

Try with needOr install directly

About

Search through your filesystem with SQL-esque queries

fsql

find all files larger than 100 megabytes$ fsql 'select path from files where size > 100000000'

list all JavaScript files modified in the last 7 days$ fsql 'select path from files where name like "%.js" and modified > now() - interval 7 day'

find empty directories in current folder$ fsql 'select path from files where type = "dir" and size = 0'

search for Python files and sort by creation date newest first$ fsql 'select path, created from files where name like "%.py" order by created desc'

find all files by extension and count how many of each type$ fsql 'select extension, count(*) from files group by extension order by count desc'