SkillAgentSearch skills...

Zfind

search for files (even inside tar/zip/7z/rar) using a SQL-WHERE filter

Install / Use

/learn @laktak/Zfind
About this skill

Quality Score

0/100

Supported Platforms

Universal

README

zfind

{ repos & mirrors: github.com/laktak/zfind, codeberg.org/laktak/zfind }

zfind allows you to search for files, including inside tar, zip, 7z and rar archives. It makes finding files easy with a filter syntax that is similar to an SQL-WHERE clause. This means, if you know SQL, you don't have to learn or remember any new syntax just for this tool.

Basic Usage & Examples

zfind <where> [<path>...]

Examples

# find files smaller than 10KB, in the current path
zfind 'size<10k'

# find files in the given range in /some/path
zfind 'size between 1M and 1G' /some/path

# find files modified before 2010 inside a tar
zfind 'date<"2010" and archive="tar"'

# find files named foo* and modified today
zfind 'name like "foo%" and date=today'

# find files that contain two dashes using a regex
zfind 'name rlike "(.*-){2}"'

# find files that have the extension .jpg or .jpeg
zfind 'ext in ("jpg","jpeg")'

# find directories named foo and bar
zfind 'name in ("foo", "bar") and type="dir"'

# search for all README.md files and show in long listing format
zfind 'name="README.md"' -l

# show results in csv format
zfind --csv
zfind --csv-no-head

Where Syntax

  • AND, OR and () parentheses are logical operators used to combine multiple conditions. AND means that both conditions must be true for a row to be included in the results. OR means that if either condition is true, the row will be included. Parentheses are used to group conditions, just like in mathematics.

Example: '(size > 20M OR name = "temp") AND type="file"' selects all files that are either greater than 20 MB in size or are named temp.

  • Operators =, <>, !=, <, >, <=, >= are comparison operators used to compare values and file properties. The types must match, meaning don't compare a date to a file size.

Example: 'date > "2020-10-01"' selects all files that were modified after the specified date.

  • LIKE, ILIKE and RLIKE are used for pattern matching in strings.
    • LIKE is case-sensitive, while ILIKE is case-insensitive.
    • The % symbol is used as a wildcard character that matches any sequence of characters.
    • The _ symbol matches any single character.
    • RLIKE allows matching a regular expression.

Example: '"name like "z%"' selects all files whose name starts with 'z'.

  • IN allows you to specify multiple values to match. A file will be included if the value of the property matches any of the values in the list.

Example: '"type in ("file", "link")' selects all files of type file or link.

  • BETWEEN selects values within a given range (inclusive).

Example: '"date between "2010" and "2011-01-15"' means that all files that were modified from 2010 to 2011-01-15 will be included.

  • NOT is a logical operator used to negate a condition. It returns true if the condition is false and vice versa.

Example: '"name not like "z%"', '"date not between "2010" and "2011-01-15"', '"type not in ("file", "link")'

  • Values can be numbers, text, date and time, TRUE and FALSE
    • dates have to be specified in YYYY-MM-DD format
    • times have to be specified in 24h HH:MM:SS format
    • numbers can be written as sizes by appending B, K, M, G and T to specify bytes, KB, MB, GB, and TB.
    • empty strings and 0 evaluate to false

Properties

The following file properties are available:

| name | description | |-------------|-------------------------------------------------------------------| | name | name of the file | | path | full path of the file | | container | path of the container (if inside an archive) | | size | file size (uncompressed) | | date | modified date in YYYY-MM-DD format | | time | modified time in HH-MM-SS format | | ext | short file extension (e.g., txt) | | ext2 | long file extension (two parts, e.g., tar.gz) | | type | file, dir, or link | | archive | archive type: tar, zip, 7z, rar or empty |

Helper properties

| name | description | |-------------|-------------------------------------------------------------------| | today | today's date | | mo | last monday's date | | tu | last tuesday's date | | we | last wednesday's date | | th | last thursday's date | | fr | last friday's date | | sa | last saturday's date | | su | last sunday's date |

Supported archives

| name | extensions | |-------------|-------------------------------------------------------------------| | tar | .tar, .tar.gz, .tgz, .tar.bz2, .tbz2, .tar.xz, .txz | | zip | .zip | | 7zip | .7z | | rar | .rar |

Note: use the flag -n (or --no-archive) to disable archive support. You can also use 'not archive' in your query but this still requires zfind to open the archive.

Actions

zfind does not implement actions like find, instead use xargs -0 to execute commands:

zfind --no-archive 'name like "%.txt"' -0 | xargs -0 -L1 echo

zfind can also produce --csv (or --csv-no-head) that can be piped to other commands.

Configuration

Set the environment variable NO_COLOR to disable color output.

Installation

Install/Update Binaries

curl https://laktak.github.io/zfind.sh|bash

This will download the zfind binary for your OS/Platform from the GitHub releases page and install it to ~/.local/bin. You will get a message if that's not in your PATH.

You probably want to download or view the setup script before piping it to bash.

If you prefer you can download a binary from github.com/laktak/zfind/releases manually and place it in your PATH.

Prereleased versions can be found directly on the GitHub Action. Click on the latest ci action and look for prerelease-artifacts at the bottom.

Homebrew (macOS and Linux)

For macOS and Linux it can also be installed via Homebrew:

brew install zfind

Arch Linux

zfind is available in the AUR as zfind:

paru -S zfind

Build from Source

Building from the source requires Go.

  • Either install it directly
go install github.com/laktak/zfind/cmd/zfind@latest
  • or clone and build
git clone https://github.com/laktak/zfind
zfind/scripts/build
# output is here:
zfind/zfind

zfind as a Go module

zfind is can also be used in other Go programs.

go get github.com/laktak/zfind

The library consists of two main packages:

  • filter: provides functionality for parsing and evaluating SQL-where filter expressions
  • find: implements searching for files and directories.

For more information see the linked documentation on pkg.go.dev.

View on GitHub
GitHub Stars403
CategoryData
Updated1mo ago
Forks7

Languages

Go

Security Score

100/100

Audited on Feb 26, 2026

No findings