Format SQL across 19 dialects (PostgreSQL, MySQL, BigQuery, Snowflake, Spark, etc.) with keyword case and indentation control via @mukundakatta/sqlfmt-mcp (npx)

{
  "server": "@mukundakatta/sqlfmt-mcp",
  "transport": "stdio",
  "calls": [
    {
      "tool": "format_sql",
      "args": {
        "sql": "select id,name,email from users where active=1 order by name limit 10"
      },
      "result": {
        "formatted": "SELECT
  id,
  name,
  email
FROM
  users
WHERE
  active = 1
ORDER BY
  name
LIMIT
  10",
        "dialect": "sql",
        "line_count": 12
      },
      "ms": 16
    },
    {
      "tool": "format_sql",
      "args": {
        "sql": "select u.name,count(o.id) as order_count... group by u.name having count(o.id)>5",
        "dialect": "postgresql"
      },
      "result_preview": "SELECT u.name, count(o.id) AS order_count... INNER JOIN... GROUP BY... HAVING... ORDER BY revenue DESC",
      "ms": 28
    },
    {
      "tool": "format_sql",
      "args": {
        "sql": "insert into products... on duplicate key update...",
        "dialect": "mysql"
      },
      "result_preview": "INSERT INTO products (sku, name, price, stock) VALUES (...) ON DUPLICATE KEY UPDATE...",
      "ms": 18
    },
    {
      "tool": "format_sql",
      "args": {
        "sql": "select... rank() over(partition by department order by salary desc)...",
        "dialect": "bigquery"
      },
      "result_preview": "RANK() OVER (PARTITION BY department ORDER BY salary DESC)",
      "ms": 18
    },
    {
      "tool": "format_sql",
      "args": {
        "sql": "with monthly_sales as (...) select... growth_pct",
        "dialect": "snowflake"
      },
      "result_preview": "WITH monthly_sales AS (...) SELECT month, total, round(...) AS growth_pct",
      "ms": 24
    },
    {
      "tool": "format_sql",
      "args": {
        "sql": "create table if not exists events...; create index...",
        "dialect": "sqlite"
      },
      "result_preview": "CREATE TABLE IF NOT EXISTS events (...); CREATE INDEX idx_events_type ON events (type)",
      "ms": 5
    },
    {
      "tool": "format_sql",
      "args": {
        "sql": "SELECT * FROM users WHERE id IN (1,2,3)",
        "keyword_case": "lower"
      },
      "result": {
        "formatted": "select
  *
from
  users
where
  id in (1, 2, 3)",
        "dialect": "sql",
        "line_count": 6
      },
      "ms": 0
    },
    {
      "tool": "format_sql",
      "args": {
        "sql": "select a,b,c from t where x > 1 and y < 2",
        "tab_width": 4
      },
      "result_preview": "4-space indentation applied",
      "ms": 1
    },
    {
      "tool": "list_dialects",
      "args": {},
      "result": {
        "dialects": ["sql", "bigquery", "db2", "db2i", "duckdb", "hive", "mariadb", "mysql", "n1ql", "plsql", "postgresql", "redshift", "singlestoredb", "snowflake", "spark", "sqlite", "tidb", "transactsql", "trino"]
      },
      "ms": 1
    },
    {
      "tool": "format_sql",
      "args": {
        "sql": "select t.id,exploded.tag from events t lateral view explode(split(t.tags,',')) exploded as tag",
        "dialect": "spark"
      },
      "result_preview": "LATERAL VIEW EXPLODE (split(t.tags, ',')) exploded AS tag",
      "ms": 11
    }
  ],
  "success_rate": "10/10 (100%)",
  "p50_ms": 5,
  "max_ms": 28
}