Regex Tester
Test a JavaScript regular expression against your text and see every match with its index, length and capture groups. Flags i, m, s and u.
Developer Reference
5 tools
Which Developer Reference tool do you need?
| Tool | What it answers |
|---|---|
| Regex Tester | Type a regular expression and some test text, and the tester lists every match with its start index, length and capture groups. |
| SQL Beautifier | Paste a query and the beautifier puts each clause (SELECT, FROM, WHERE, GROUP BY, ORDER BY) on its own line, lists columns one per line and starts every… |
| SQL Formatter | Paste a query and the formatter puts SELECT, FROM, WHERE, JOIN, GROUP BY and ORDER BY on their own lines, indents what follows, and breaks columns and AND… |
| SQL Minifier | Paste a query and the minifier removes line and block comments, collapses every run of spaces, tabs and newlines, and drops spaces around commas, brackets and operators. |
| SQL Query Generator | Pick a statement type and dialect, then type the table, columns and values. |
All tools
SQL Minifier
Compress SQL queries by removing — and /* */ comments and extra whitespace, while quoted strings, identifiers and optimizer hints stay untouched.
SQL Query Generator
Build SELECT, INSERT, UPDATE and DELETE statements for MySQL, PostgreSQL or SQL Server, with correct identifier quoting and escaped string values.
SQL Formatter
Format SQL with one clause per line, indented columns and conditions, subqueries nested a level deeper, and keywords in upper, lower or original case.
SQL Beautifier
Reformat cramped SQL with one clause per line, indented column lists and subqueries, and keywords set to upper or lower case. Strings and comments stay intact.