fsql is a command-line tool that lets you search your filesystem using SQL-like queries.
The tool solves the problem of making filesystem searches more expressive and composable than traditional find commands. Rather than learning find's syntax with its various flags and options, fsql lets you write queries with SELECT, FROM, and WHERE clauses. You specify which file attributes to display, which directories to search, and what conditions files must match. The query language supports pattern matching on filenames using both glob-style wildcards and regular expressions, size and time comparisons, file mode checks, and hash computation and comparison. Multiple conditions can be combined with AND, OR, and NOT operators, with parentheses for explicit precedence control.
fsql suits developers and system administrators who frequently need to locate files matching complex criteria. It works well for one-off searches where you want to filter by multiple attributes at once, such as finding recently modified files above a certain size or files matching a regex pattern in specific directory trees. The tool accepts queries via stdin or interactive mode, making it usable both in scripts and at the command line. Source paths support environment variables, tildes, and glob patterns, and you can exclude directories with a leading hyphen.
The project maintains active continuous integration with automated testing on code changes. Development activity shows consistent engagement with the codebase through regular updates and maintenance of the build pipeline.
