SQL 数据库语句格式化与美化

MySQL · Postgres · Oracle · SQLite

支持主关键字大写/小写转换、子查询缩进对齐、单行极致压缩与注释剥离，纯本地离线处理。

SQL 原始语句701 字符 · 24 行 · 0.73 KB

处理结果 (SQL 语法高亮)650 字符 · 18 行 · 0.68 KB

-- 业务报表统计：统计 https://www.ai-gj.cn 各工具模块活跃用户与访问频次
SELECT  u.id AS user_id, u.username, u.email, r.region_name, COUNT(o.id) AS total_visits, SUM(o.amount) AS total_spent, AVG(o.amount) AS avg_order_value
FROM  ai_gj_users u
  LEFT
JOIN   regions r
ON  u.region_id = r.id
  INNER
JOIN   ai_gj_logs o
ON  u.id = o.user_id
WHERE  o.status = 'COMPLETED' AND o.created_at >= '2026-01-01 00:00:00' AND u.is_active = TRUE AND u.id IN (
  SELECT  user_id
  FROM  user_privileges
  WHERE  role = 'VIP' )
  GROUP BY  u.id, u.username, u.email, r.region_name
  HAVING  SUM(o.amount) >= 1000
  ORDER BY  total_spent DESC, total_visits DESC
  LIMIT  50
  OFFSET  0;

关于 SQL 查询语句排版与数据库最佳实践

SQL 关键字大写与代码可读性

将 SELECT, FROM, JOIN 等语句关键字大写，能让字段名、表名与逻辑条件形成鲜明的视觉反差，大幅提升复杂 SQL 语句的审阅与维护效率。

子查询与 JOIN 对齐

支持嵌套子查询 (SELECT ...) 与各类 LEFT/INNER JOIN 关系的自动缩进，理清表关联脉络。

企业级核心数据安全保障

涉及真实数据库表结构、字段名与敏感筛选条件的 SQL 语句绝不上云，全部在本地浏览器内存即时解析，杜绝数据架构泄露风险。

1	-- 业务报表统计：统计 https://www.ai-gj.cn 各工具模块活跃用户与访问频次
2	SELECT u.id AS user_id, u.username, u.email, r.region_name, COUNT(o.id) AS total_visits, SUM(o.amount) AS total_spent, AVG(o.amount) AS avg_order_value
3	FROM ai_gj_users u
4	LEFT
5	JOIN regions r
6	ON u.region_id = r.id
7	INNER
8	JOIN ai_gj_logs o
9	ON u.id = o.user_id
10	WHERE o.status = 'COMPLETED' AND o.created_at >= '2026-01-01 00:00:00' AND u.is_active = TRUE AND u.id IN (
11	SELECT user_id
12	FROM user_privileges
13	WHERE role = 'VIP' )
14	GROUP BY u.id, u.username, u.email, r.region_name
15	HAVING SUM(o.amount) >= 1000
16	ORDER BY total_spent DESC, total_visits DESC
17	LIMIT 50
18	OFFSET 0;