prettier-plugin-sql-cst

At a glance

• Editor score
  6.1 / 10
• Pricing
  Free plan
• Best for
  Prettier users needing experimental SQL parsers
• Free plan
  Yes
• Paid from
  Free
• Supported SQL dialects
  SQLite, BigQuery, PostgreSQL, PL/pgSQL, MySQL, MariaDB
• Automatic fixes
  Yes
• Facts checked
  20 Sep 2026

• Where it wins

  • Formats SQL by expression length with casing controls
  • Supports SQLite and BigQuery parsers
  • Works with Prettier CLI and Visual Studio Code

• Where it doesn't

  • PostgreSQL, PL/pgSQL, MySQL, and MariaDB parsers are experimental
  • Requires a Prettier-based formatting workflow
  • Dialect support is narrower outside SQLite and BigQuery

Our verdict on prettier-plugin-sql-cst

prettier-plugin-sql-cst is an open-source Prettier plugin for formatting SQL files. It uses a concrete syntax tree and Prettier’s formatting algorithm to adjust layout according to expression length while preserving most syntax elements. It is aimed at developers who already use Prettier and want SQL formatting in the same workflow, particularly for SQLite and BigQuery projects.

Formatting controls extend beyond line layout. The plugin supports casing options for SQL keywords, literals, types, identifiers, and functions. It can apply canonical syntax transformations, enforce a final semicolon, and format embedded languages such as JSON and JavaScript. SQL formatting runs through the Prettier command-line tool, and the plugin works with the Prettier Visual Studio Code extension, giving it a direct fit with command-line and editor-based workflows.

The main trade-off is dialect coverage. SQLite and BigQuery are supported parsers, while PostgreSQL, PL/pgSQL, MySQL, and MariaDB parsers are experimental. That makes the plugin a focused choice for teams standardizing SQL presentation through Prettier, especially when their dialect matches the primary parser support. Teams working heavily with the experimental dialects should account for that status before making the plugin their default formatter. As an open-source project with a free plan, it offers formatting, casing, transformation, and editor integration without a paid-plan structure described here.

Your product? Our editors can test prettier-plugin-sql-cst in depth and publish a review, labelled as paid · from $149/mo →

prettier-plugin-sql-cst pricing

prettier-plugin-sql-cst fact sheet

prettier-plugin-sql-cst integrations

prettier-plugin-sql-cst lists 2 integrations on its own site.

• Prettier
• Visual Studio Code

Alternatives to prettier-plugin-sql-cst

• SQLFluffConfigurable SQL linting with autofix, templating, plugins, and CI workflows.9.4
• SSqruffA focused open-source choice for dbt teams needing linting, formatting, and CI workflows.9.1
• PpgFormatterA configurable, open-source formatter for PostgreSQL-focused SQL workflows.8.8

See all prettier-plugin-sql-cst alternatives →

Featured on iTechGuides

prettier-plugin-sql-cst is listed in our SQL Linters and Formatters directory. Add the badge to your site — it links back to this page.

<a href="https://www.itechguides.com/products/prettier-plugin-sql-cst/"><img src="https://www.itechguides.com/best/badge/prettier-plugin-sql-cst.svg" alt="Featured on iTechGuides" width="230" height="46"></a>

Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026

Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.

Last updated 7 Oct 2026 · How we research and update