Suggestions appear as you type. Use the up and down arrows to choose one and Enter to open it.

This page's audience our own tag's counts — open to see them
–Visits
–Page views
–Clicks to vendors
–Time on page
–Reading now
Clicks to vendors, by tool
  • –
Top countries
  • –
Devices
  • –

– · visits, page views and clicks counted by our own tag, which counts more than our checked analytics; every figure rounded down · how we count

Prettier SQL review

Free#8 of 25 in SQL Linters and Formatters

A flexible open-source SQL formatter for Prettier workflows, not a verified linter.

8.0/10Editor score
Visit Prettier SQL
Prettier SQL8.0 Visit Prettier SQL

Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026

Prettier SQL is an open-source plugin for formatting SQL files through Prettier, with support for SQL embedded in JavaScript tagged template literals. It is aimed at developers and teams already using Prettier who want SQL formatting within the same local workflow. The plugin can use sql-formatter or node-sql-parser and supports language and database options including PostgreSQL, MySQL, BigQuery, Snowflake, SQLite, Trino, and others. It runs from the Prettier command line and can be installed through npm or Yarn.

Its strongest fit is configuration depth. Published options cover keyword, datatype, function, and identifier casing, along with indentation, operator newlines, expression width, and query spacing. Configuration works through Prettier configuration files, and the category specifications show automatic fixing and config-file support. For mixed-language codebases, prettier-plugin-embed adds formatting for SQL-in-JS tagged template literals, while the available parser choices provide flexibility across supported dialects and databases.

The main boundary is scope: Prettier SQL is positioned as a formatter rather than a complete SQL quality or governance tool. There is no verified linting, custom-rule, or CI feature set, so teams seeking those capabilities should consider a product with explicit support for them. Choose Prettier SQL when free, local, configurable formatting and Prettier ecosystem compatibility matter most. It is less suitable when SQL linting, organization-specific rules, or dedicated continuous-integration workflows are central requirements.

Prettier SQL pros and cons

  • Where it wins
    • Free, open-source formatting across many SQL dialects
    • Formats SQL-in-JS tagged template literals through prettier-plugin-embed
    • Detailed controls for casing, indentation, spacing, and layout
  • Where it doesn't
    • No verified linting or custom-rule support
    • No verified CI features
    • Requires a self-hosted local Prettier setup

Prettier SQL fact sheet, pricing and score →

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 · How we research and update