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

@mukundakatta/sqlfmt-mcp v latest — SQL formatting via MCP

Install: npm install @mukundakatta/sqlfmt-mcp Transport: stdio (node node_modules/@mukundakatta/sqlfmt-mcp/src/index.js) Tools: 2 — format_sql, list_dialects

Tool: format_sql

Returns: { formatted, dialect, line_count }

Tool: list_dialects

No params. Returns { dialects: ["sql","bigquery","db2","db2i","duckdb","hive","mariadb","mysql","n1ql","plsql","postgresql","redshift","singlestoredb","snowflake","spark","sqlite","tidb","transactsql","trino"] }

Key gotchas

• Tool name is `format_sql` not format — calling format returns unknown-tool error
• Invalid SQL is returned unchanged — no error thrown, just the original string with line_count: 1
• CTE formatting is excellent — properly nests WITH subqueries with correct indentation
• First call ~90ms (JIT), subsequent calls 23–30ms
• `keyword_case: "upper"` is default — keywords auto-uppercased unless you pass "lower" or "preserve"
• BigQuery backtick-quoted table names preserved correctly
• CREATE TABLE columns properly indented with constraints on same line