dsq

{
  "aliases": [],
  "alternatives": [],
  "build_dependencies": [
    "go"
  ],
  "categories": [],
  "caveats": null,
  "conflicts_with": [],
  "dependencies": [],
  "deprecated": 0,
  "deprecation_reason": null,
  "desc": "CLI tool for running SQL queries against JSON, CSV, Excel, Parquet, and more",
  "disable_reason": null,
  "disabled": 0,
  "enrichment_fetched_at": "2026-06-20T23:37:08+00:00",
  "first_seen": "2026-06-20T23:34:18+00:00",
  "full_name": "dsq",
  "github_default_branch": "main",
  "github_last_commit_at": "2023-09-30T14:49:59Z",
  "github_readme_excerpt": "# Not under active development\n\nWhile development may continue in the future with a different\narchitecture, for the moment you should probably instead use\n[DuckDB](https://github.com/duckdb/duckdb),\n[ClickHouse-local](https://clickhouse.com/docs/en/operations/utilities/clickhouse-local),\nor [GlareDB (based on\nDataFusion)](https://github.com/GlareDB/glaredb).\n\nThese are built on stronger analytics foundations than projects like\ndsq based on SQLite. For example, column-oriented storage and\nvectorized execution, let alone JIT-compiled expression evaluation,\nare possible with these other projects.\n\n[More here](https://twitter.com/eatonphil/status/1708130091425784146).\n\n# Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more\n\nSince Github doesn\u0027t provide a great way for you to learn about new\nreleases and features, don\u0027t just star the repo, join the [mailing\nlist](https://docs.google.com/forms/d/e/1FAIpQLSfYF3AZivacRrQWanC-skd0iI23ermwPd17T_64Xc4etoL_Tw/viewform).\n\n- [About](#about)\n- [Install](#install)\n    - [macOS Homebrew](#macos-homebrew)\n    - [Binaries on macOS, Linux, WSL](#binaries-on-macos-linux-wsl)\n    - [Binaries on Windows (not WSL)](#binaries-on-windows-not-wsl)\n    - [Build and install from source](#build-and-install-from-source)\n- [Usage](#usage)\n    - [Pretty print](#pretty-print)\n    - [Piping data to dsq](#piping-data-to-dsq)\n    - [Multiple files and joins](#multiple-files-and-joins)\n    - [SQL query from file](#sql-query-from-file)\n    - [Transforming data to JSON without querying](#transforming-data-to-json-without-querying)\n    - [Array of objects nested within an object](#array-of-objects-nested-within-an-object)\n        - [Multiple Excel sheets](#multiple-excel-sheets)\n        - [Limitation: nested arrays](#limitation-nested-arrays)\n    - [Nested object values](#nested-object-values)\n        - [Caveat: PowerShell, CMD.exe](#caveat-powershell-cmdexe)\n        - [Nested objects explained](#nested-objects-explained)\n  ",
  "github_repo": "multiprocessio/dsq",
  "github_stars": 3865,
  "github_topics": [
    "cli",
    "csv",
    "excel",
    "golang",
    "json",
    "openoffice-calc",
    "parquet",
    "sql",
    "tsv"
  ],
  "homepage": "https://github.com/multiprocessio/dsq",
  "homepage_og_description": null,
  "homepage_og_image": null,
  "homepage_title": null,
  "installs_30d": 18,
  "installs_365d": 163,
  "installs_90d": 33,
  "keg_only": 0,
  "keg_only_reason": null,
  "last_seen": "2026-06-20T23:34:18+00:00",
  "license": "Apache-2.0",
  "llm_generated_at": null,
  "llm_model": null,
  "name": "dsq",
  "oldnames": [],
  "one_liner": null,
  "optional_dependencies": [],
  "rank_30d": 7115,
  "rank_365d": 7858,
  "rank_90d": 8388,
  "raw_hash": "81299593d2ac5660",
  "recommended_dependencies": [],
  "revision": 0,
  "ruby_source_path": "Formula/d/dsq.rb",
  "tap": "homebrew/core",
  "test_dependencies": [],
  "uses_from_macos": [],
  "version_head": "HEAD",
  "version_stable": "0.23.0",
  "versioned_formulae": [],
  "why_use_this": null
}