sql-lint

sql-lint documentation

• Version in MegaLinter: 1.0.0
• Visit Official Web Site
• See How to configure sql-lint rules
  • If custom .sql-config.json config file is not found, .sql-config.json will be used
• See Index of problems detected by sql-lint

Configuration in MegaLinter

• Enable sql-lint by adding SQL_SQL_LINT in ENABLE_LINTERS variable
• Disable sql-lint by adding SQL_SQL_LINT in DISABLE_LINTERS variable

Variable	Description	Default value
SQL_SQL_LINT_ARGUMENTS	User custom arguments to add in linter CLI call Ex: -s --foo "bar"
SQL_SQL_LINT_FILTER_REGEX_INCLUDE	Custom regex including filter Ex: (src\|lib)	Include every file
SQL_SQL_LINT_FILTER_REGEX_EXCLUDE	Custom regex excluding filter Ex: (test\|examples)	Exclude no file
SQL_SQL_LINT_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	file
SQL_SQL_LINT_FILE_EXTENSIONS	Allowed file extensions. "*" matches any extension, "" matches empty extension. Empty list excludes all files Ex: [".py", ""]	[".sql"]
SQL_SQL_LINT_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_SQL_LINT_PRE_COMMANDS	List of bash commands to run before the linter	None
SQL_SQL_LINT_POST_COMMANDS	List of bash commands to run after the linter	None
SQL_SQL_LINT_CONFIG_FILE	sql-lint configuration file name Use LINTER_DEFAULT to let the linter find it	.sql-config.json
SQL_SQL_LINT_RULES_PATH	Path where to find linter configuration file	Workspace folder, then MegaLinter default rules
SQL_SQL_LINT_DISABLE_ERRORS	Run linter but consider errors as warnings	false
SQL_SQL_LINT_DISABLE_ERRORS_IF_LESS_THAN	Maximum number of errors allowed	0

IDE Integration

Use sql-lint in your favorite IDE to catch errors before MegaLinter !

	IDE	Extension Name	Install
	vim	ale	Visit Web Site

MegaLinter Flavours

This linter is available in the following flavours

	Flavor	Description	Embedded linters	Info
	all	Default MegaLinter Flavor	101
	documentation	MegaLinter for documentation projects	42
	dotnet	Optimized for C, C++, C# or VB based projects	50
	go	Optimized for GO based projects	44
	java	Optimized for JAVA based projects	44
	javascript	Optimized for JAVASCRIPT or TYPESCRIPT based projects	51
	php	Optimized for PHP based projects	46
	python	Optimized for PYTHON based projects	50
	ruby	Optimized for RUBY based projects	43
	rust	Optimized for RUST based projects	43
	salesforce	Optimized for Salesforce based projects	45
	swift	Optimized for SWIFT based projects	43
	terraform	Optimized for TERRAFORM based projects	48

Behind the scenes

How are identified applicable files

• File extensions: .sql

How the linting is performed

• sql-lint is called one time by identified file

Example calls

sql-lint myfile.sql

sql-lint --config .sql-config.json myfile.sql

Help content

Usage: sql-lint [options]

Lint sql files and stdin for errors, oddities, and bad practices.

Options:
  -V, --version                output the version number
  --fix [string]               The .sql string to fix (experimental and alpha)
  -d, --driver <string>        The driver to use, must be one of ['mysql',
                               'postgres']
  -v, --verbose                Brings back information on the what it's linting
                               and the tokens generated
  --format <string>            The format of the output, can be one of
                               ['simple', 'json'] (default: "simple")
  --host <string>              The host for the database connection
  --user <string>              The user for the database connection
  --password <string>          The password for the database connection
  --port <string>              The port for the database connection
  --config <string>            The path to the configuration file
  --ignore-errors <string...>  The errors to ignore (comma separated)
  -h, --help                   display help for command

Installation on mega-linter Docker image

• NPM packages (node.js):
  • sql-lint