---
title: "Format and minify SQL."
method: POST
path: "/api/v1/sql"
tags: ["Formatters & Validators"]
---

# Format and minify SQL.

`POST /api/v1/sql`

## Request

- Base URL: `https://programmes.net`
- URL: `https://programmes.net/api/v1/sql`
- Auth: none declared

SQL Formatter. Operations: `beautify` — Beautify SQL with newlines before clauses. `minify` — Minify SQL to a single line.

## Request body

- union
  - SqlBeautify: Beautify SQL with newlines before clauses.
    - `operation` 'beautify', required
    - `input` string: The SQL to beautify.
    - `options` object
      - `uppercaseKeywords` boolean: Uppercase SQL keywords.
      - `indentSize` integer: Indent width in spaces.
      - `lineBreaksBeforeClauses` boolean: Start each clause (FROM, WHERE, …) on a new line.
  - SqlMinify: Minify SQL to a single line.
    - `operation` 'minify', required
    - `input` string: The SQL to minify.
    - `options` object
      - `uppercaseKeywords` boolean: Uppercase SQL keywords.

## Response `200`

The operation ran.

- object
  - `ok` unknown, required
  - `tool` 'sql', required
  - `operation` 'beautify' | 'minify', required
  - `result` unknown, required

## Other responses

- `400`: The request is not valid (https://programmes.net/api#invalid-request); The tool has no such operation (https://programmes.net/api#unknown-operation)
- `404`: No such tool (https://programmes.net/api#unknown-tool)
- `413`: The request or its input is too large (https://programmes.net/api#content-too-large)
- `415`: The body must be JSON (https://programmes.net/api#unsupported-media-type)
- `422`: An option is missing, of the wrong type or out of range (https://programmes.net/api#invalid-options); This call needs more CPU than one API call may use (https://programmes.net/api#refused); The operation could not process the input (https://programmes.net/api#tool-error)
- `429`: Too many requests (https://programmes.net/api#rate-limited)
- `500`: Internal error (https://programmes.net/api#internal-error)

---

[API](https://skmtc.dev/programmes/apis/programmes-net-api.md) · [All operations](https://skmtc.dev/programmes/apis/programmes-net-api/llms.txt) · [OpenAPI document](https://skmtc.dev/programmes/apis/programmes-net-api/revisions/aa939784a2e6?raw)