dsq ☆
« Back to VersTracker
Description:
CLI tool for running SQL queries against JSON, CSV, Excel, Parquet, and more
Type: Formula  |  Latest Version: 0.23.0@0  |  Tracked Since: Dec 17, 2025
Links: Homepage  |  formulae.brew.sh
Category: Developer tools
Tags: sql data-analysis cli json csv etl
Install: brew install dsq
About:
dsq is a command-line interface tool that allows users to run SQL queries directly on various data file formats including JSON, CSV, Excel, and Parquet. It works by automatically converting input files into a temporary SQLite database, enabling complex data analysis without manual preprocessing. This streamlines data inspection and transformation workflows for developers and data analysts.
Key Features:
  • Supports multiple file formats: JSON, CSV, Excel, Parquet, and more
  • Automatic schema detection and temporary database creation
  • Standard SQL syntax support via SQLite engine
  • Zero-configuration setup and lightweight execution
Use Cases:
  • Quickly querying large JSON API response files without parsing
  • Performing ad-hoc analysis on CSV data exports
  • Joining data across different file formats
Alternatives:
  • q – Similar SQL-on-files tool but with different syntax and format support
  • csvkit – CSV-specific toolkit with broader CSV manipulation features
License: Apache-2.0
Bottles available for: arm64_tahoe, arm64_sequoia, arm64_sonoma, arm64_ventura, arm64_monterey, arm64_big_sur, sonoma, ventura, monterey, big_sur, catalina, arm64_linux, x86_64_linux
Version History
Detected Version Rev Change Commit
Sep 13, 2025 3:47pm 0 VERSION_BUMP 256cb4fe
Sep 12, 2024 8:07am 0 VERSION_BUMP ba7ea61b
Nov 24, 2022 3:29am 0 VERSION_BUMP 42ac3e35
« Back to VersTracker  |  Browse Packages  |  About