options.md

Options

All options are set per file glob using Prettier's overrides key.

---

sqlKeywordCase

Controls the case of SQL keywords (SELECT, FROM, WHERE, JOIN, etc.).

Value	Description
lower (default)	All keywords lowercase
upper	All keywords uppercase
preserve	Keywords emitted as-is from the formatter's internal representation (currently uppercase)

lower (default)

select
  id,
  title
from books
where price < 50;

upper

SELECT
  id,
  title
FROM books
WHERE price < 50;

Example configuration

// prettier.config.js
export default {
  plugins: ['prettier-plugin-postgresql'],
  overrides: [
    {
      files: '*.sql',
      options: {
        parser: 'pgsql',
        sqlKeywordCase: 'upper',
      },
    },
  ],
};

---

sqlDensity

Controls whitespace density.

Value	Description
standard (default)	Single FROM table and single WHERE predicate stay inline; AND/OR conditions indent
compact	Same as standard (reserved for further compaction in future)
spacious	Every clause indents, even single predicates

---

sqlCommaStyle

Controls where commas appear in column and value lists.

Value	Description
trailing (default)	Comma at end of line
leading	Comma at start of next line

trailing (default)

select
  id,
  title,
  price
from books
where price < 50;

leading

select
  id
  , title
  , price
from books
where price < 50;

---

Prettier's printWidth

Prettier's standard printWidth option (default 80) is respected. Column lists, JOIN conditions, and inline expressions wrap to new lines when the line would exceed the print width.

---

Full Configuration Example

// prettier.config.js
export default {
  plugins: ['prettier-plugin-postgresql'],
  overrides: [
    {
      files: ['*.sql', '*.pgsql'],
      options: {
        parser: 'pgsql',
        printWidth: 100,
        sqlKeywordCase: 'lower',
        sqlDensity: 'standard',
        sqlCommaStyle: 'trailing',
      },
    },
  ],
};