Форматер SQL

SQL is often written on one line or copied out of an ORM log - it technically runs, but it is not readable. As soon as more than one JOIN, a subquery or a nested WHERE comes in, you lose the thread. The SQL Formatter breaks your query into its parts and reassembles it cleanly: keywords uppercased, each main clause on its own line, consistent indentation for nested parts.

The formatter understands dialects. You choose between PostgreSQL, MySQL, SQLite and MSSQL, and the tokenizer recognises the keywords valid for each. That matters because the dialects differ in reserved words and subtleties - a query meant for Postgres is formatted as Postgres too, not by a generic one-size-fits-all scheme.

Conversely you can also minify a query when you want it compact in a config, a script or a single line of an application. Nicely formatted becomes compact at the press of a button and back again - whatever you need at the moment.

Beyond pure formatting, the tool analyses your query. The query analysis shows you, for example, how many JOINs are in play and how deeply your subqueries are nested - a good first hint at why a query might be complicated or slow. Error detection looks for typical pitfalls like unbalanced brackets and reports them before you send the query to the database.

So you do not start with an empty field, the formatter ships a large collection of ready example queries, grouped by theme and in the Werkzeu.ge spirit with a German bureaucratic flavour. That way you immediately see what a formatted query should look like, and you have material to try out the dialects, the analysis and the error detection.

Everything runs entirely client-side. No SQL leaves your browser - no query, no schema name, no table content is sent to a server or stored. Especially with SQL that reveals internal structures or data, that is the right way. No account, no signup, no data leaving your device.