منسق SQL

Make SQL Readable with Dialect-Aware تنسيقting

SQL queries from ORMs, query builders, or إنشاءd code are often crammed into single lines or تنسيقted inconsistently. Trying to review SELECT * FROM users WHERE id = 1 AND status = 'active' AND إنشاءd_at > '2024-01-01' ORDER BY name is painful. Properly تنسيقted SQL with appropriate line breaks and indentation is drastically easier to read and debug:

SELECT *
FROM users
WHERE
  id = 1
  AND status = 'active'
  AND إنشاءd_at > '2024-01-01'
ORDER BY name

This SQL تنسيقter handles the تحويلation automatically, respecting your specific SQL dialect and style preferences.

Multi-Dialect Support

SQL syntax varies by database. This تنسيقter supports:

• Standard SQL: Generic, works with most databases
• PostgreSQL: With PostgreSQL-specific syntax
• MySQL & MariaDB: MySQL/MariaDB variants
• SQLite: SQLite dialect
• T-SQL: Microsoft SQL Server
• BigQuery: Google BigQuery SQL
• Hive & Spark: Data warehouse engines
• TiDB: Distributed SQL database

Select your database, and the تنسيقter respects dialect-specific keywords and syntax.

Customizable Style Options

Keyword Case: Choose how SQL keywords are تنسيقted:

• UPPERCASE: SELECT * FROM
• lowercase: select * from
• Preserve: Keep keywords as-is in the input

Indentation Size: 2 spaces (compact) or 4 spaces (readable), matching your team's SQL style guide.

Comma Position: Decide where commas appear in SELECT lists and WHERE clauses:

• Before: Place commas at the start of each new line
• After: Place commas at the end of each line (traditional)

Common SQL Development Workflows

Code Review: Before reviewing إنشاءd or ORM-produced SQL, تنسيق it for readability. It's much easier to spot errors or optimization opportunities in تنسيقted output.

Query Debugging: When a complex query isn't returning expected results, تنسيق it to understand the structure, identify logical issues, and verify WHERE clauses and joins.

Documentation & Examples: تنسيق SQL queries before including them in documentation, README files, or tutorials. Well-تنسيقted examples are easier for others to understand and modify.

Style Consistency: Enforce consistent SQL تنسيقting across your team by using this tool as a تنسيقter before committing queries to version control.

Performance Analysis: When investigating slow queries, تنسيق them first. Well-structured SQL is easier to analyze for missing indexes, unnecessary joins, or inefficient subqueries.

SQL Migration & Refactoring: When moving queries between systems or refactoring large SQL files, تنسيق them to ensure consistency and catch issues during transition.

One-Click Copy or التحميل

تنسيقted SQL copies to your الحافظة with one click or التحميلs as a .sql file. Use it directly in your codebase, database client, or documentation.

Respects String Literals

The تنسيقter is intelligent about string content—it won't break or reتنسيق text inside quoted strings, ensuring your SQL data remains intact and correct.

100% المتصفح-Based تنسيقting

تنسيقting happens entirely in your المتصفح using the proven sql-تنسيقter library. Your queries never leave your machine, so you can safely تنسيق queries containing sensitive data or proprietary business logic.