Repository navigation
sqlmesh format requires DB connection #5182
Description
When using the sqlmesh CLI to format the project, it tries to connect to a DB. Given that I am using it as part of PR tests to make sure the code is properly formatted, there's no need for external connections. Would it be possible to drop this requirement?
Activity
j-hartshorn commentedon May 21, 2026
We have encountered something similar too; format is failing in CI because it's trying to authenticate with GCP. Formatting shouldn't need to connect or auth at all.
Narrow local-only state skip to format command
Narrow local-only state skip to format command
j-hartshorn commentedon Jun 12, 2026
PR #5804 makes sqlmesh
formatrunnable without a reachable state backend.Unfortunately I couldn't make the
lintcommand follow suit because it needs the remote state to resolve reference in the m multi-repo case. Details are in the PR discussion. some possible follow ups if anyone wants to take a look:lintto make it ignore state, documenting that this may cause extra linting errors to appear in the multi-repo case.