SQL फॉर्मेटर और ब्यूटिफायर - SQL क्वेरी फॉर्मेट ऑनलाइन

import { format } from 'sql-formatter';

// Format SQL
const ugly = "SELECT u.id, u.name, o.total FROM users u INNER JOIN orders o ON u.id = o.user_id WHERE o.total > 100 AND u.active = 1 ORDER BY o.total DESC LIMIT 10;";

const formatted = format(ugly, {
  language: 'mysql',
  tabWidth: 2,
  keywordCase: 'upper',
});
console.log(formatted);
// SELECT
//   u.id,
//   u.name,
//   o.total
// FROM
//   users u
//   INNER JOIN orders o ON u.id = o.user_id
// WHERE
//   o.total > 100
//   AND u.active = 1
// ORDER BY
//   o.total DESC
// LIMIT
//   10;

// Minify SQL
function minifySQL(sql) {
  return sql
    .replace(/--.*$/gm, '')
    .replace(/\/\*[\s\S]*?\*\//g, '')
    .replace(/\s+/g, ' ')
    .trim();
}

console.log(minifySQL(formatted));