Skip to content

Sql Formatter API

POST https://api.findutils.com/api/tools/sql-formatter/execute

Format (beautify) or minify a SQL query and return the result with lint warnings. Format mode puts each clause (SELECT, FROM, WHERE, JOIN, ...) on its own line, uppercases keywords, and indents by the chosen width; dialect adds MySQL, PostgreSQL, or SQLite keywords. Warnings flag unmatched parentheses, unclosed strings, empty clauses, and a missing final semicolon.

Request body

application/json
  • sql

    string required

    The SQL text to format or minify.

  • mode

    string optional

    format = beautify, minify = one line without comments. Default: format. One of format · minify. Default "format".

  • indent

    integer optional

    Spaces per indentation level in format mode (1-8). Default: 2. Default 2.

  • dialect

    string optional

    SQL dialect for keyword recognition. Default: standard. One of standard · mysql · postgresql · sqlite. Default "standard".

Example arguments

Verified
{
  "sql": "select id, name from users where id = 1;"
}