fsql

{
  "aliases": [],
  "alternatives": [],
  "build_dependencies": [
    "go"
  ],
  "categories": [],
  "caveats": null,
  "conflicts_with": [],
  "dependencies": [],
  "deprecated": 0,
  "deprecation_reason": null,
  "desc": "Search through your filesystem with SQL-esque queries",
  "disable_reason": null,
  "disabled": 0,
  "enrichment_fetched_at": "2026-06-20T23:37:51+00:00",
  "first_seen": "2026-06-20T23:34:18+00:00",
  "full_name": "fsql",
  "github_default_branch": "master",
  "github_last_commit_at": "2024-10-08T06:28:17Z",
  "github_readme_excerpt": "# fsql [![Go](https://github.com/kashav/fsql/actions/workflows/go.yml/badge.svg)](https://github.com/kashav/fsql/actions/workflows/go.yml)\n\n\u003eSearch through your filesystem with SQL-esque queries.\n\n## Contents\n\n- [Demo](#demo)\n- [Installation](#installation)\n- [Usage](#usage)\n- [Query Syntax](#query-syntax)\n- [Examples](#usage-examples)\n- [Contribute](#contribute)\n- [License](#license)\n\n## Demo\n\n[![fsql.gif](./media/fsql.gif)](https://asciinema.org/a/120534)\n\n## Installation\n\n#### Binaries\n\n[View latest release](https://github.com/kashav/fsql/releases/latest).\n\n#### Via Go\n\n```sh\n$ go get -u -v github.com/kashav/fsql/...\n$ which fsql\n$GOPATH/bin/fsql\n```\n\n#### Via Homebrew\n\n```sh\n$ brew install fsql\n$ which fsql\n/usr/local/bin/fsql\n```\n\n#### Build manually\n\n```sh\n$ git clone https://github.com/kashav/fsql.git $GOPATH/src/github.com/kashav/fsql\n$ cd $_ # $GOPATH/src/github.com/kashav/fsql\n$ make\n$ ./fsql\n```\n\n## Usage\n\nfsql expects a single query via stdin. You may also choose to use fsql in interactive mode.\n\nView the usage dialogue with the `-help` flag.\n\n```sh\n$ fsql -help\nusage: fsql [options] [query]\n  -v  print version and exit (shorthand)\n  -version\n      print version and exit\n```\n\n## Query syntax\n\nIn general, each query requires a `SELECT` clause (to specify which attributes will be shown), a `FROM` clause (to specify which directories to search), and a `WHERE` clause (to specify conditions to test against).\n\n```console\n\u003e\u003e\u003e SELECT attribute, ... FROM source, ... WHERE condition;\n```\n\nYou may choose to omit the `SELECT` and `WHERE` clause.\n\nIf you\u0027re providing your query via stdin, quotes are **not** required, however you\u0027ll have to escape _reserved_ characters (e.g. `*`, `\u003c`, `\u003e`, etc).\n\n### Attribute\n\nCurrently supported attributes include `name`, `size`, `time`, `hash`, `mode`.\n\nUse `all` or `*` to choose all; if no attribute is provided, this is chosen by default.\n\n**Examples**:\n\nEach group features a set of equivalent clauses.\n\n```console\n\u003e\u003e\u003e SELECT name,",
  "github_repo": "kashav/fsql",
  "github_stars": 3986,
  "github_topics": [
    "find",
    "golang"
  ],
  "homepage": "https://github.com/kashav/fsql",
  "homepage_og_description": null,
  "homepage_og_image": null,
  "homepage_title": null,
  "installs_30d": 7,
  "installs_365d": 95,
  "installs_90d": 11,
  "keg_only": 0,
  "keg_only_reason": null,
  "last_seen": "2026-06-20T23:34:18+00:00",
  "license": "MIT",
  "llm_generated_at": null,
  "llm_model": null,
  "name": "fsql",
  "oldnames": [],
  "one_liner": null,
  "optional_dependencies": [],
  "rank_30d": 9497,
  "rank_365d": 9316,
  "rank_90d": 11488,
  "raw_hash": "32048e3ae8a92008",
  "recommended_dependencies": [],
  "revision": 0,
  "ruby_source_path": "Formula/f/fsql.rb",
  "tap": "homebrew/core",
  "test_dependencies": [],
  "uses_from_macos": [],
  "version_head": "HEAD",
  "version_stable": "0.5.2",
  "versioned_formulae": [],
  "why_use_this": null
}