SQL Formatter

Formatage et embellissement de requetes SQL.

SQL a formater :

Indentation : 2 espaces 4 espaces Tab

Mots-cles : MAJUSCULES minuscules Capitalize

Virgules en fin de ligne

Formater Minifier Effacer

Resultat

Copier

Exemples

SELECT simple JOIN Sous-requete INSERT UPDATE CREATE TABLE

Bonnes pratiques SQL

Formatage recommande

SELECT
    u.id,
    u.username,
    u.email,
    COUNT(o.id) AS order_count
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
WHERE u.status = 'active'
    AND u.created_at > '2024-01-01'
GROUP BY u.id, u.username, u.email
HAVING COUNT(o.id) > 5
ORDER BY order_count DESC
LIMIT 10;

Conventions

Element	Convention	Exemple
Mots-cles	MAJUSCULES	SELECT, FROM, WHERE
Tables/Colonnes	snake_case	user_id, created_at
Alias	Court et significatif	u pour users, o pour orders
Indentation	4 espaces	Apres SELECT, WHERE, etc.
Virgules	En fin de ligne	Plus lisible pour le diff

Anti-patterns a eviter

-- MAL: SELECT *
SELECT * FROM users;

-- BIEN: Colonnes explicites
SELECT id, username, email FROM users;

-- MAL: Sans alias avec JOIN
SELECT users.id, orders.id FROM users JOIN orders ON orders.user_id = users.id;

-- BIEN: Avec alias
SELECT u.id, o.id FROM users u JOIN orders o ON o.user_id = u.id;