https://community.databricks.com/t5/data-engineering/looking-for-cli-based-sql-formatter-for-databricks-alternative/m-p/136061#M50476 <DIV class=""><DIV class=""><P>I'm looking for a SQL formatter (CLI) for two different contexts within Databricks.</P><P>1. SQL queries in .sql files - What tool does Databricks use by default to format SQL?</P><P>2. %sql magic cells in notebooks (.ipynb files) - What tool does Databricks use by default to format SQL in %sql cells?</P><P>Databricks currently appears to use gethue/sql-formatter for both contexts, but I have some concerns with this tool:<BR />- The project hasn't been updated in four years.<BR />- It doesn't properly support %sql cells in .ipynb notebooks. I'm sure there are custom customizations, especially for #2.<BR />- I don't want to rely on an unmaintained tool.</P><P>What I'm looking for:</P><P>I'm looking for an alternative tool that meets the following criteria:<BR />- Officially provided by Databricks or Databricks Labs<BR />- Supports both .sql files and %sql cells in .ipynb<BR />- Available as a CLI command or installable package (e.g., for CI/CD pipelines)</P><P>Does Databricks or Databricks Labs provide such a tool? If not, are there any officially recommended commands or packages that meet these requirements?</P><P>I'd appreciate any guidance.</P></DIV></DIV> Sun, 26 Oct 2025 09:30:55 GMT Lenoq 2025-10-26T09:30:55Z https://community.databricks.com/t5/data-engineering/looking-for-cli-based-sql-formatter-for-databricks-alternative/m-p/136061#M50476 <DIV class=""><DIV class=""><P>I'm looking for a SQL formatter (CLI) for two different contexts within Databricks.</P><P>1. SQL queries in .sql files - What tool does Databricks use by default to format SQL?</P><P>2. %sql magic cells in notebooks (.ipynb files) - What tool does Databricks use by default to format SQL in %sql cells?</P><P>Databricks currently appears to use gethue/sql-formatter for both contexts, but I have some concerns with this tool:<BR />- The project hasn't been updated in four years.<BR />- It doesn't properly support %sql cells in .ipynb notebooks. I'm sure there are custom customizations, especially for #2.<BR />- I don't want to rely on an unmaintained tool.</P><P>What I'm looking for:</P><P>I'm looking for an alternative tool that meets the following criteria:<BR />- Officially provided by Databricks or Databricks Labs<BR />- Supports both .sql files and %sql cells in .ipynb<BR />- Available as a CLI command or installable package (e.g., for CI/CD pipelines)</P><P>Does Databricks or Databricks Labs provide such a tool? If not, are there any officially recommended commands or packages that meet these requirements?</P><P>I'd appreciate any guidance.</P></DIV></DIV> Sun, 26 Oct 2025 09:30:55 GMT https://community.databricks.com/t5/data-engineering/looking-for-cli-based-sql-formatter-for-databricks-alternative/m-p/136061#M50476 Lenoq 2025-10-26T09:30:55Z https://community.databricks.com/t5/data-engineering/looking-for-cli-based-sql-formatter-for-databricks-alternative/m-p/136083#M50481 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/194425">@Lenoq</a>&nbsp;,</P><P>As far as I know, currently there is no tool that meets your given criteria by databricks/labs. The closest that I can see is the tool you gave as an example, but as you said its not that good. what I would do maybe is an intermedial option with&nbsp;sqlfluff that would format the sql queries,&nbsp;however, it would need some extra handling to strip or ignore %sql magic lines when used on notebook content.<BR /><BR />Best, Ilir</P> Sun, 26 Oct 2025 15:01:34 GMT https://community.databricks.com/t5/data-engineering/looking-for-cli-based-sql-formatter-for-databricks-alternative/m-p/136083#M50481 ilir_nuredini 2025-10-26T15:01:34Z