← All Tools

🗂 SQL Formatter

Format and beautify your SQL queries.

All processing happens locally in your browser. No data is sent to any server. GDPR/DORA compliant.

SQL Quick Reference

Basic Clauses

  • SELECT - Choose columns
  • FROM - Specify table
  • WHERE - Filter rows
  • ORDER BY - Sort results
  • GROUP BY - Aggregate
  • HAVING - Filter groups

Join Types

  • INNER JOIN - Match both
  • LEFT JOIN - All left + match
  • RIGHT JOIN - All right + match
  • FULL JOIN - All from both
  • CROSS JOIN - Cartesian

Common Functions

  • COUNT(), SUM()
  • AVG(), MIN(), MAX()
  • COALESCE(), NULLIF()
  • CONCAT(), SUBSTRING()
  • NOW(), DATE()

Best Practices

  • Use meaningful aliases
  • Avoid SELECT *
  • Index frequently filtered columns
  • Use parameterized queries
  • Comment complex logic