Lint a SQL file on disk, honoring any .sqlfluff / pyproject.toml config found by walking up from the file's directory.

Args: path: Path to the SQL file to lint. config_path: Optional path to an extra config file to layer on top of whatever is discovered by walking the directory tree.

Fix a SQL file on disk, honoring discovered .sqlfluff config.

Args: path: Path to the SQL file to fix. write: If True, overwrite the file in place with the fixed SQL. If False (default), just return the fixed SQL without touching the file. config_path: Optional path to an extra config file to layer on top of whatever is discovered by walking the directory tree.

Parse a SQL file on disk and return its parse tree, honoring discovered .sqlfluff config.

Args: path: Path to the SQL file to parse. config_path: Optional path to an extra config file to layer on top of whatever is discovered by walking the directory tree.

Lint a raw SQL string using an explicitly specified dialect.

Args: sql: The SQL text to lint. dialect: SQLFluff dialect name, e.g. "ansi", "bigquery", "snowflake", "postgres". See sqlfluff.list_dialects() for the full set. rules: Optional list of rule codes/names to restrict linting to.

Fix a raw SQL string using an explicitly specified dialect and return the fixed SQL text (does not touch any file).

Args: sql: The SQL text to fix. dialect: SQLFluff dialect name, e.g. "ansi", "bigquery", "snowflake", "postgres". rules: Optional list of rule codes/names to restrict fixing to.

Parse a raw SQL string using an explicitly specified dialect and return its parse tree.

Args: sql: The SQL text to parse. dialect: SQLFluff dialect name, e.g. "ansi", "bigquery", "snowflake", "postgres".

List the SQL dialects SQLFluff supports (for use with lint_sql / fix_sql / parse_sql).

Clear SQLFluff's internal config-file cache.

SQLFluff caches the contents of .sqlfluff / pyproject.toml / setup.cfg / tox.ini files it reads while walking up a directory tree (keyed by file path, for the lifetime of this server process). If you edit a config file on disk while this server is running, the *_file tools may keep returning results based on the old contents until this cache is cleared. Call this tool after editing any SQLFluff config file to force the next lint_file / fix_file / parse_file call to re-read it from disk.