format my sql

Inject parameters into raw SQL and format the result — CLI & web tool.

# one query
sqlformat "SELECT * FROM t WHERE id = ?" "[42]"

# batch from file (pairs: SQL line, params line)
cat queries.txt | sqlformat > formatted.sql

Install

sudo npm install -g format-my-sql

or via npx:

npx -p format-my-sql sqlformat "SELECT * FROM t WHERE id = ?" "[42]"

Placeholder styles

| Style | Example | Params | |-------|---------|--------| | ? | WHERE id = ? | [1] | | $1 | WHERE id = $1 | [1] | | :name | WHERE id = :id | {"id":1} |

Web

Client-side only, no backend → formatmysql.vercel.app

License

MIT