Skip to content

sqlfluff

GitHub stars GitHub release (latest SemVer) GitHub last commit GitHub commit activity GitHub contributors

sqlfluff documentation

sqlfluff - GitHub

Configuration in MegaLinter

Variable Description Default value
SQL_SQLFLUFF_ARGUMENTS User custom arguments to add in linter CLI call
Ex: -s --foo "bar"
SQL_SQLFLUFF_FILTER_REGEX_INCLUDE Custom regex including filter
Ex: (src\|lib)
Include every file
SQL_SQLFLUFF_FILTER_REGEX_EXCLUDE Custom regex excluding filter
Ex: (test\|examples)
Exclude no file
SQL_SQLFLUFF_CLI_LINT_MODE Override default CLI lint mode
- file: Calls the linter for each file
- list_of_files: Call the linter with the list of files as argument
- project: Call the linter from the root of the project
list_of_files
SQL_SQLFLUFF_FILE_EXTENSIONS Allowed file extensions. "*" matches any extension, "" matches empty extension. Empty list excludes all files
Ex: [".py", ""]
[".sql"]
SQL_SQLFLUFF_FILE_NAMES_REGEX File name regex filters. Regular expression list for filtering files by their base names using regex full match. Empty list includes all files
Ex: ["Dockerfile(-.+)?", "Jenkinsfile"]
Include every file
SQL_SQLFLUFF_PRE_COMMANDS List of bash commands to run before the linter None
SQL_SQLFLUFF_POST_COMMANDS List of bash commands to run after the linter None
SQL_SQLFLUFF_UNSECURED_ENV_VARIABLES List of env variables explicitly not filtered before calling SQL_SQLFLUFF and its pre/post commands None
SQL_SQLFLUFF_CONFIG_FILE sqlfluff configuration file nameUse LINTER_DEFAULT to let the linter find it .sqlfluff
SQL_SQLFLUFF_RULES_PATH Path where to find linter configuration file Workspace folder, then MegaLinter default rules
SQL_SQLFLUFF_DISABLE_ERRORS Run linter but consider errors as warnings false
SQL_SQLFLUFF_DISABLE_ERRORS_IF_LESS_THAN Maximum number of errors allowed 0
SQL_SQLFLUFF_CLI_EXECUTABLE Override CLI executable ['sqlfluff']

MegaLinter Flavours

This linter is available in the following flavours

Flavor Description Embedded linters Info
all Default MegaLinter Flavor 117 Docker Image Size (tag) Docker Pulls
cupcake MegaLinter for the most commonly used languages 85 Docker Image Size (tag) Docker Pulls
documentation MegaLinter for documentation projects 51 Docker Image Size (tag) Docker Pulls
dotnet Optimized for C, C++, C# or VB based projects 63 Docker Image Size (tag) Docker Pulls
dotnetweb Optimized for C, C++, C# or VB based projects with JS/TS 72 Docker Image Size (tag) Docker Pulls
go Optimized for GO based projects 53 Docker Image Size (tag) Docker Pulls
java Optimized for JAVA based projects 55 Docker Image Size (tag) Docker Pulls
javascript Optimized for JAVASCRIPT or TYPESCRIPT based projects 60 Docker Image Size (tag) Docker Pulls
php Optimized for PHP based projects 54 Docker Image Size (tag) Docker Pulls
python Optimized for PYTHON based projects 62 Docker Image Size (tag) Docker Pulls
ruby Optimized for RUBY based projects 51 Docker Image Size (tag) Docker Pulls
rust Optimized for RUST based projects 51 Docker Image Size (tag) Docker Pulls
salesforce Optimized for Salesforce based projects 54 Docker Image Size (tag) Docker Pulls
swift Optimized for SWIFT based projects 51 Docker Image Size (tag) Docker Pulls
terraform Optimized for TERRAFORM based projects 55 Docker Image Size (tag) Docker Pulls

Behind the scenes

How are identified applicable files

  • Activated only if one of these files is found: .sqlfluff
  • File extensions: .sql

How the linting is performed

  • sqlfluff is called once with the list of files as arguments (list_of_files CLI lint mode)

Example calls

sqlfluff myfile.sql
sqlfluff --config .sqlfluff myfile.sql myfile2.sql

Help content

Usage: sqlfluff [OPTIONS] COMMAND [ARGS]...

  SQLFluff is a modular SQL linter for humans.

Options:
  --version   Show the version and exit.
  -h, --help  Show this message and exit.

Commands:
  dialects  Show the current dialects available.
  fix       Fix SQL files.
  format    Autoformat SQL files.
  lint      Lint SQL files via passing a list of files or using stdin.
  parse     Parse SQL files and just spit out the result.
  render    Render SQL files and just spit out the result.
  rules     Show the current rules in use.
  version   Show the version of sqlfluff.

  Examples:

  sqlfluff lint --dialect postgres .

  sqlfluff lint --dialect postgres --rules ST05 .

  sqlfluff fix --dialect sqlite --rules LT10,ST05 src/queries

  sqlfluff parse --dialect sqlite --templater jinja src/queries/common.sql

Installation on mega-linter Docker image