SQL Format/Compress

Instructions & SQL Knowledge

How to use this tool

• Auto Response: Paste or modify the code in the left input box, and the system will automatically format it for you after you stop typing.
• SQL Format: Paste compact or messy SQL statements on the left, click "Format SQL" to get clearly structured SQL code with keyword highlighting and standard indentation.
• SQL Compress: Remove extra spaces, line breaks, and comments from the SQL code, compressing it into a single line, suitable for log troubleshooting or before code transmission.
• Save Locally: Click the "Save Locally" button on the right to download the formatted SQL file directly as a .sql text file.
• Drag to Adjust: You can click and drag the gray vertical bar in the middle left and right to freely adjust the width of the input and result areas.

Basic SQL Specifications

• Capitalize Keywords: Although SQL is not case-sensitive, the general industry standard is to capitalize all keywords like SELECT, FROM, WHERE, JOIN, and use lowercase for table and field names to enhance readability.
• Alignment: Complex SQL should be broken into lines according to the execution order (e.g., SELECT -> FROM -> JOIN -> WHERE -> GROUP BY -> ORDER BY), and keep appropriate indentation for AND/OR.
• String Wrapping: In standard SQL, strings should be wrapped in single quotes '...'. Double quotes "..." are usually used to escape reserved words or column/table names containing special characters in the database.