For the complete documentation index, see llms.txt.

SQL Formatter API

developer 1 credit / call v2026-04-22

Format or minify SQL with keyword casing, breaking clauses and joins onto their own lines.

One POST adds SQL Formatter to your app, site, workflow, or agent — formula, validation, edge cases, and docs already handled.

prefer a UI? Open the SQL Formatter on miniwebtool.com →

Start free — get a key → 1,000 credits · no card · 30 seconds

Endpoint

POST · 1cr
POST https://api.miniwebtool.com/v1/tools/sql-formatter/run

Request body

Field Type Req.
sql
SQL text
 str —
mode
format | minify
 str —
keyword_case
upper | lower | preserve
 str —
indent_size
spaces per level
 int —

Cost & access

  • 1 credit per successful call — failed calls refund.
  • Starts on: Free.
  • Max payload: 524288 bytes.
  • Privacy mode: no_body_logs
  • Available on: free, starter, pro, business, scale

Response envelope

{
  "request_id": "01K...",
  "tool": "sql-formatter",
  "tool_version": "2026-04-22",
  "credits_used": 1,
  "result": { ... }
}

Try it

Stored only in this browser tab. Playground test key is prefilled and only works on this page. Get a live key →
SQL text
format | minify
upper | lower | preserve
spaces per level

Get your own key

1,000 free calls/mo · no card · key arrives by email

One verification click, then your key + a ready-to-run request. No card, no spam.

Code examples

curl -X POST https://api.miniwebtool.com/v1/tools/sql-formatter/run \
  -H 'Authorization: Bearer mwt_live_YOUR_KEY' \
  -H 'Content-Type: application/json' \
  -d '{"sql":"select id, name from users where active = 1 order by name","mode":"format","keyword_case":"upper","indent_size":2}'
import requests

resp = requests.post(
    'https://api.miniwebtool.com/v1/tools/sql-formatter/run',
    headers={'Authorization': 'Bearer mwt_live_YOUR_KEY'},
    json={'sql': 'select id, name from users where active = 1 order by name', 'mode': 'format', 'keyword_case': 'upper', 'indent_size': 2},
)
resp.raise_for_status()
data = resp.json()
print(data)
const resp = await fetch(
  'https://api.miniwebtool.com/v1/tools/sql-formatter/run',
  {
    method: 'POST',
    headers: {
      'Authorization': 'Bearer mwt_live_YOUR_KEY',
      'Content-Type': 'application/json',
    },
    body: JSON.stringify({"sql":"select id, name from users where active = 1 order by name","mode":"format","keyword_case":"upper","indent_size":2}),
  }
);
const data = await resp.json();
console.log(data);
<?php
$ch = curl_init('https://api.miniwebtool.com/v1/tools/sql-formatter/run');
curl_setopt_array($ch, [
    CURLOPT_POST => true,
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_HTTPHEADER => [
        'Authorization: Bearer mwt_live_YOUR_KEY',
        'Content-Type: application/json',
    ],
    CURLOPT_POSTFIELDS => json_encode([
    'sql' => 'select id, name from users where active = 1 order by name',
    'mode' => 'format',
    'keyword_case' => 'upper',
    'indent_size' => 2
]),
]);
$resp = curl_exec($ch);
curl_close($ch);
print_r(json_decode($resp, true));
require 'net/http'
require 'json'
require 'uri'

uri = URI('https://api.miniwebtool.com/v1/tools/sql-formatter/run')
http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = (uri.scheme == 'https')

req = Net::HTTP::Post.new(uri)
req['Authorization'] = 'Bearer mwt_live_YOUR_KEY'
req['Content-Type'] = 'application/json'
req.body = {
  'sql' => 'select id, name from users where active = 1 order by name',
  'mode' => 'format',
  'keyword_case' => 'upper',
  'indent_size' => 2
}.to_json

resp = http.request(req)
puts JSON.parse(resp.body).inspect
package main

import (
  "bytes"
  "encoding/json"
  "fmt"
  "io"
  "net/http"
)

func main() {
  body, _ := json.Marshal(map[string]interface{}{
    "sql": "select id, name from users where active = 1 order by name",
    "mode": "format",
    "keyword_case": "upper",
    "indent_size": 2,
  })
  req, _ := http.NewRequest("POST", "https://api.miniwebtool.com/v1/tools/sql-formatter/run", bytes.NewReader(body))
  req.Header.Set("Authorization", "Bearer mwt_live_YOUR_KEY")
  req.Header.Set("Content-Type", "application/json")

  resp, err := http.DefaultClient.Do(req)
  if err != nil { panic(err) }
  defer resp.Body.Close()
  out, _ := io.ReadAll(resp.Body)
  fmt.Println(string(out))
}
import java.net.URI;
import java.net.http.*;

var client = HttpClient.newHttpClient();
var req = HttpRequest.newBuilder()
    .uri(URI.create("https://api.miniwebtool.com/v1/tools/sql-formatter/run"))
    .header("Authorization", "Bearer mwt_live_YOUR_KEY")
    .header("Content-Type", "application/json")
    .POST(HttpRequest.BodyPublishers.ofString("{\"sql\":\"select id, name from users where active = 1 order by name\",\"mode\":\"format\",\"keyword_case\":\"upper\",\"indent_size\":2}"))
    .build();

var resp = client.send(req, HttpResponse.BodyHandlers.ofString());
System.out.println(resp.body());
agents let your coding agent do it

Copy this into Claude Code, Cursor, Codex, Aider or Cline. It carries the endpoint, the full schema, a sample response, and the credit rules — so the agent wires sql-formatter up correctly without draining your key.

Free to iterate: the prompt points the agent at POST /v1/tools/sql-formatter/dry-run, which validates the request and returns the response shape for 0 credits. Only the final confirmation call is billed (1 credit).
Stable URL for this prompt: /tools/sql-formatter/prompt.md (?variant=cursor / ?variant=mcp).
Paste into Claude Code, or save as CLAUDE.md context.
Integrate the MiniWebtool SQL Formatter API into this project.

## Your task

1. Read the reference below.
2. Ask me where this belongs in the codebase if it is not obvious.
3. Write the integration in the language and style of the surrounding code:
   a small typed client function, errors handled, key read from the
   environment (never hard-coded, never committed).
4. Verify with `/dry-run` first, then exactly one live call.
5. Show me the diff and the live result.

## Credit budget — follow these exactly

This API is metered. A live call costs 1 credit; the free tier
includes 1,000 credits per month. Burning them during integration is the
single most common way to waste this key.

1. **Do all wiring against `/dry-run`, which costs 0 credits.** It validates the
   payload for real and returns a sample result with the exact response shape.
   Iterate there until your request builds and your parsing works.
2. **Make at most ONE live `/run` call** — a single end-to-end confirmation once
   dry-run passes. Print the result, then stop.
3. **Never call the API from unit tests, examples, or a retry loop.** Assert
   against the sample response captured from `/dry-run` instead.
4. **On 4xx, fix the payload — do not retry.** The error body is RFC 7807
   `application/problem+json` and says exactly what is wrong.
5. **On 429, honour `Retry-After`** and back off; do not tighten the loop.
6. **Read `X-MWT-Credits-Remaining`** on every response. If it drops below 50,
   stop making live calls and tell me.
7. If the integration needs repeated calls at runtime, **cache by input** — this
   tool is deterministic, so the same input always returns the same output.

## The API

**SQL Formatter** — Format or minify SQL with keyword casing, breaking clauses and joins onto their own lines.

- Live endpoint: `POST https://api.miniwebtool.com/v1/tools/sql-formatter/run` — costs 1 credit
- Dry run: `POST https://api.miniwebtool.com/v1/tools/sql-formatter/dry-run` — costs 0 credits, same auth and validation
- Auth: `Authorization: Bearer <MINIWEBTOOL_API_KEY>`
- Content type: `application/json`
- Tool version: `2026-04-22` (output shape is stable within a major version)
- Full machine-readable spec: `https://api.miniwebtool.com/v1/openapi.json`

### Request body

| field | type | required | notes |
|---|---|---|---|
| `sql` | str | no | SQL text (default `select id, name from users where active = 1 order by name`) |
| `mode` | str | no | one of: format, minify — format \| minify (default `format`) |
| `keyword_case` | str | no | one of: upper, lower, preserve — upper \| lower \| preserve (default `upper`) |
| `indent_size` | int | no | spaces per level (default `2`) |

Example request body:

```json
{
  "sql": "select id, name from users where active = 1 order by name",
  "mode": "format",
  "keyword_case": "upper",
  "indent_size": 2
}
```

### Response envelope

```json
{
  "request_id": "req_01H…",
  "tool": "sql-formatter",
  "tool_version": "2026-04-22",
  "credits_used": 1,
  "result": {
    "mode": "format",
    "output": "SELECT id, name\nFROM users\nWHERE active = 1\nORDER BY name",
    "keyword_case": "upper",
    "indent_size": 2,
    "line_count": 4,
    "token_count": 13,
    "statement_count": 1,
    "input_bytes": 57,
    "output_bytes": 57
  }
}
```

`result` holds the tool output. Errors come back as
`application/problem+json` with `type`, `title`, `status`, and `detail`.

### Getting a key

If `MINIWEBTOOL_API_KEY` is not already in the environment, stop and ask me for
one — do not sign up, scrape, or guess a key. Free keys: https://api.miniwebtool.com/dashboard/
Paste into Codex, Aider, Cline, or any coding agent.
Integrate the MiniWebtool SQL Formatter API into this project.

## Your task

1. Read the reference below.
2. Ask me where this belongs in the codebase if it is not obvious.
3. Write the integration in the language and style of the surrounding code:
   a small typed client function, errors handled, key read from the
   environment (never hard-coded, never committed).
4. Verify with `/dry-run` first, then exactly one live call.
5. Show me the diff and the live result.

## Credit budget — follow these exactly

This API is metered. A live call costs 1 credit; the free tier
includes 1,000 credits per month. Burning them during integration is the
single most common way to waste this key.

1. **Do all wiring against `/dry-run`, which costs 0 credits.** It validates the
   payload for real and returns a sample result with the exact response shape.
   Iterate there until your request builds and your parsing works.
2. **Make at most ONE live `/run` call** — a single end-to-end confirmation once
   dry-run passes. Print the result, then stop.
3. **Never call the API from unit tests, examples, or a retry loop.** Assert
   against the sample response captured from `/dry-run` instead.
4. **On 4xx, fix the payload — do not retry.** The error body is RFC 7807
   `application/problem+json` and says exactly what is wrong.
5. **On 429, honour `Retry-After`** and back off; do not tighten the loop.
6. **Read `X-MWT-Credits-Remaining`** on every response. If it drops below 50,
   stop making live calls and tell me.
7. If the integration needs repeated calls at runtime, **cache by input** — this
   tool is deterministic, so the same input always returns the same output.

## The API

**SQL Formatter** — Format or minify SQL with keyword casing, breaking clauses and joins onto their own lines.

- Live endpoint: `POST https://api.miniwebtool.com/v1/tools/sql-formatter/run` — costs 1 credit
- Dry run: `POST https://api.miniwebtool.com/v1/tools/sql-formatter/dry-run` — costs 0 credits, same auth and validation
- Auth: `Authorization: Bearer <MINIWEBTOOL_API_KEY>`
- Content type: `application/json`
- Tool version: `2026-04-22` (output shape is stable within a major version)
- Full machine-readable spec: `https://api.miniwebtool.com/v1/openapi.json`

### Request body

| field | type | required | notes |
|---|---|---|---|
| `sql` | str | no | SQL text (default `select id, name from users where active = 1 order by name`) |
| `mode` | str | no | one of: format, minify — format \| minify (default `format`) |
| `keyword_case` | str | no | one of: upper, lower, preserve — upper \| lower \| preserve (default `upper`) |
| `indent_size` | int | no | spaces per level (default `2`) |

Example request body:

```json
{
  "sql": "select id, name from users where active = 1 order by name",
  "mode": "format",
  "keyword_case": "upper",
  "indent_size": 2
}
```

### Response envelope

```json
{
  "request_id": "req_01H…",
  "tool": "sql-formatter",
  "tool_version": "2026-04-22",
  "credits_used": 1,
  "result": {
    "mode": "format",
    "output": "SELECT id, name\nFROM users\nWHERE active = 1\nORDER BY name",
    "keyword_case": "upper",
    "indent_size": 2,
    "line_count": 4,
    "token_count": 13,
    "statement_count": 1,
    "input_bytes": 57,
    "output_bytes": 57
  }
}
```

`result` holds the tool output. Errors come back as
`application/problem+json` with `type`, `title`, `status`, and `detail`.

### Getting a key

If `MINIWEBTOOL_API_KEY` is not already in the environment, stop and ask me for
one — do not sign up, scrape, or guess a key. Free keys: https://api.miniwebtool.com/dashboard/
Save as .cursor/rules/miniwebtool-sql-formatter.mdc
---
description: MiniWebtool SQL Formatter API — usage and credit budget
globs:
alwaysApply: false
---

# MiniWebtool SQL Formatter API

## The API

**SQL Formatter** — Format or minify SQL with keyword casing, breaking clauses and joins onto their own lines.

- Live endpoint: `POST https://api.miniwebtool.com/v1/tools/sql-formatter/run` — costs 1 credit
- Dry run: `POST https://api.miniwebtool.com/v1/tools/sql-formatter/dry-run` — costs 0 credits, same auth and validation
- Auth: `Authorization: Bearer <MINIWEBTOOL_API_KEY>`
- Content type: `application/json`
- Tool version: `2026-04-22` (output shape is stable within a major version)
- Full machine-readable spec: `https://api.miniwebtool.com/v1/openapi.json`

### Request body

| field | type | required | notes |
|---|---|---|---|
| `sql` | str | no | SQL text (default `select id, name from users where active = 1 order by name`) |
| `mode` | str | no | one of: format, minify — format \| minify (default `format`) |
| `keyword_case` | str | no | one of: upper, lower, preserve — upper \| lower \| preserve (default `upper`) |
| `indent_size` | int | no | spaces per level (default `2`) |

Example request body:

```json
{
  "sql": "select id, name from users where active = 1 order by name",
  "mode": "format",
  "keyword_case": "upper",
  "indent_size": 2
}
```

### Response envelope

```json
{
  "request_id": "req_01H…",
  "tool": "sql-formatter",
  "tool_version": "2026-04-22",
  "credits_used": 1,
  "result": {
    "mode": "format",
    "output": "SELECT id, name\nFROM users\nWHERE active = 1\nORDER BY name",
    "keyword_case": "upper",
    "indent_size": 2,
    "line_count": 4,
    "token_count": 13,
    "statement_count": 1,
    "input_bytes": 57,
    "output_bytes": 57
  }
}
```

`result` holds the tool output. Errors come back as
`application/problem+json` with `type`, `title`, `status`, and `detail`.

### Getting a key

If `MINIWEBTOOL_API_KEY` is not already in the environment, stop and ask me for
one — do not sign up, scrape, or guess a key. Free keys: https://api.miniwebtool.com/dashboard/

## Credit budget — follow these exactly

This API is metered. A live call costs 1 credit; the free tier
includes 1,000 credits per month. Burning them during integration is the
single most common way to waste this key.

1. **Do all wiring against `/dry-run`, which costs 0 credits.** It validates the
   payload for real and returns a sample result with the exact response shape.
   Iterate there until your request builds and your parsing works.
2. **Make at most ONE live `/run` call** — a single end-to-end confirmation once
   dry-run passes. Print the result, then stop.
3. **Never call the API from unit tests, examples, or a retry loop.** Assert
   against the sample response captured from `/dry-run` instead.
4. **On 4xx, fix the payload — do not retry.** The error body is RFC 7807
   `application/problem+json` and says exactly what is wrong.
5. **On 429, honour `Retry-After`** and back off; do not tighten the loop.
6. **Read `X-MWT-Credits-Remaining`** on every response. If it drops below 50,
   stop making live calls and tell me.
7. If the integration needs repeated calls at runtime, **cache by input** — this
   tool is deterministic, so the same input always returns the same output.
Skip the HTTP client — connect the agent directly.
Add the MiniWebtool MCP server to this project, then use the
`sql-formatter` tool from it.

Server URL: https://api.miniwebtool.com/v1/mcp
Transport: HTTP (Streamable HTTP / JSON-RPC 2.0)
Auth header: `Authorization: Bearer <MINIWEBTOOL_API_KEY>`

Claude Code:

```bash
claude mcp add --transport http miniwebtool https://api.miniwebtool.com/v1/mcp \
  --header "Authorization: Bearer $MINIWEBTOOL_API_KEY"
```

Or add it to the MCP config file your client uses:

```json
{
  "mcpServers": {
    "miniwebtool": {
      "type": "http",
      "url": "https://api.miniwebtool.com/v1/mcp",
      "headers": { "Authorization": "Bearer ${MINIWEBTOOL_API_KEY}" }
    }
  }
}
```

Once connected, `tools/list` exposes `sql-formatter` with its JSON Schema, so you can
call it directly instead of writing an HTTP client.

## Credit budget — follow these exactly

This API is metered. A live call costs 1 credit; the free tier
includes 1,000 credits per month. Burning them during integration is the
single most common way to waste this key.

1. **Do all wiring against `/dry-run`, which costs 0 credits.** It validates the
   payload for real and returns a sample result with the exact response shape.
   Iterate there until your request builds and your parsing works.
2. **Make at most ONE live `/run` call** — a single end-to-end confirmation once
   dry-run passes. Print the result, then stop.
3. **Never call the API from unit tests, examples, or a retry loop.** Assert
   against the sample response captured from `/dry-run` instead.
4. **On 4xx, fix the payload — do not retry.** The error body is RFC 7807
   `application/problem+json` and says exactly what is wrong.
5. **On 429, honour `Retry-After`** and back off; do not tighten the loop.
6. **Read `X-MWT-Credits-Remaining`** on every response. If it drops below 50,
   stop making live calls and tell me.
7. If the integration needs repeated calls at runtime, **cache by input** — this
   tool is deterministic, so the same input always returns the same output.
how-to call sql-formatter
  1. Get an API key
    Get an API key. Sign up free for a bearer token. 1,000 credits/month, no card.
  2. Assemble the JSON body
    Required fields: . See the Request body table above for the full schema.
  3. POST to https://api.miniwebtool.com/v1/tools/sql-formatter/run
    Headers: Authorization: Bearer <key> and Content-Type: application/json. Copy-paste snippets in 7 languages are under Code examples.
  4. Parse the response
    Envelope: {request_id, tool, tool_version, credits_used, result}. The typed output lives in result.
faq frequently asked
What does the SQL Formatter API do?+

Format or minify SQL with keyword casing, breaking clauses and joins onto their own lines. Use it to add this utility without rebuilding formulas, validation, examples, and documentation.

How much does one call to SQL Formatter cost?+

1 credit per successful call. Failed calls (validation errors, 5xx) don't bill.

What parameters does the SQL Formatter API require?+

Required fields: (none). Full schema at /v1/openapi.json.

Is the SQL Formatter API deterministic?+

Yes — same input, same output, forever. Tool version 2026-04-22; output shape is stable within a major version.

Can an AI agent call the SQL Formatter API?+

Yes. Connect to https://api.miniwebtool.com/v1/mcp over the Model Context Protocol. The agent discovers `sql-formatter` with its JSON Schema automatically, so the model can plan while MiniWebtool handles the exact tool result.

What format does the API return?+

JSON with a stable envelope: `{request_id, tool, tool_version, credits_used, result}`. Errors are RFC 7807 `application/problem+json`.

mcp use from an AI agent

Every endpoint on this site is also exposed via the Model Context Protocol at https://api.miniwebtool.com/v1/mcp. Claude, Cursor, and any MCP-capable agent can discover this tool (sql-formatter) and its JSON Schema automatically — no client codegen. 

# List tools the agent can call
curl -s https://api.miniwebtool.com/v1/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/list"}' \
 | jq '.result.tools[] | select(.name=="sql-formatter")'
see-also related developer tools
JSON Formatter/Validator
Validate, beautify, minify, or repair JSON with precise error positions, size s…
JSON Schema Generator
Infer a JSON Schema (2020-12, 2019-09, or draft-07) from a sample document, wit…
UUID Validator/Decoder
Validate and decode UUIDs: version, variant, field breakdown, v1/v7 timestamps …
cURL Command Builder
Assemble a shell-safe curl command from method, URL, query parameters, headers,…