sql-formatter を Homebrew, Nix でインストール

プロジェクトリンク

• ホームページ

コマンドとエイリアス

• sql-formatter

プロジェクトの歴史

The project was created in 2016 and its README says it started as a port of a PHP library before diverging substantially. It grew into a multi-dialect formatter supporting engines and query languages including BigQuery, ClickHouse, DB2, DuckDB, Hive, MariaDB, MySQL, N1QL, Oracle PL/SQL, PostgreSQL, Redshift, Snowflake, Spark, SQLite, Transact-SQL, Trino, and others.

採用の歴史

SQL Formatter is primarily distributed through the JavaScript package ecosystem, with the README recommending npm, yarn, pnpm, or bun. The supplied package metadata also shows Homebrew and Nix packaging for the CLI, and the organization maintains an official VS Code extension.

使われ方

The library exposes a `format` function for applications, while the CLI installs as `sql-formatter` and can format stdin or a file. It accepts language and config options, searches for `.sql-formatter.json` in the current or parent directories, and can also use a config path or JSON string passed with `--config`.

パッケージ好きにとっての重要性

Package nerds care about SQL Formatter because it is a small, installable formatting primitive that can be embedded in editors, scripts, CI, and language tooling. Its appeal is broad dialect coverage and simple package-manager installation rather than a full SQL linting framework.

タイムライン

• 2016: GitHub repository created and v0.0.1 published.
• 2026: v15.8.2 published on GitHub releases.

Related projects

• The README credits the original PHP sql-formatter library as its starting point and links to official editor integrations, including the SQL Formatter VS Code extension.

ソース

• GitHub API repository and releases metadata for sql-formatter-org/sql-formatter, accessed 2026-07-02
• https://github.com/sql-formatter-org/sql-formatter
• https://raw.githubusercontent.com/sql-formatter-org/sql-formatter/master/package.json
• https://sql-formatter-org.github.io/sql-formatter/
• input source_facts.package-manager