Coc Sqlfluff

SQLFluff (A SQL linter and auto-formatter for Humans) extension for coc.nvim
Alternatives To Coc Sqlfluff
Project NameStarsDownloadsRepos Using ThisPackages Using ThisMost Recent CommitTotal ReleasesLatest ReleaseOpen IssuesLicenseLanguage
5 months ago1mit
📝 A Repository for developers for different kinds of Programming Cheatsheets
Vim Sql Workbench174
7 months ago5gpl-3.0Vim script
SQL For Vim (provides access from VIM to any DBMS, like dbext)
2 years ago16mitVim script
An SQL wrapper for vim
Dbclass Exercises49
10 years ago1XQuery
All the Stanford DB class exercises summarized together
2 years ago10April 04, 20215mitPython
MySQL command line / text based interface client
Vim Uppercase Sql44
2 years ago5Vim script
Automatically uppercase SQL keywords as you type
10 years agoVimL
SQLComplete is a SQL code completion system using the omnifunc framework
Coc Sqlfluff24
4 days agomitTypeScript
SQLFluff (A SQL linter and auto-formatter for Humans) extension for coc.nvim
Vim Mysql Plugin19
3 months ago3apache-2.0Vim Script
VIM MySQL Plugin
Sql Heredoc.vim18
6 years ago4Vim script
Syntax highlighting for SQL heredocs.
Alternatives To Coc Sqlfluff
Select To Compare

Alternative Project Comparisons


SQLFluff (A SQL linter and auto-formatter for Humans) extension for coc.nvim



  • Lint
  • Format
  • Code Action
  • Built-in installer



:CocInstall coc-sqlfluff


Plug 'yaegassy/coc-sqlfluff', {'do': 'yarn install --frozen-lockfile'}

Detect: sqlfluff

  1. sqlfluff.commandPath setting
  2. PATH environment (e.g. system global PATH or venv, etc ...)
  3. builtin: extension-only "venv" (Installation commands are also provided)

Bult-in install

coc-sqlfluff allows you to create an extension-only "venv" and install "sqlfluff".

The first time you use coc-sqlfluff, if sqlfluff is not detected, you will be prompted to do a built-in installation.

You can also run the installation command manually.

:CocCommand sqlfluff.install

SQLFluff configuration file (setup.cfg, tox.ini, pep8.ini, .sqlfluff, pyproject.toml)

SQLFluff is able to read project-specific default values for its command line options, or from a configuration file.

SQLFluff will look for the following files in order. Later files will (if found) will be used to overwrite any vales read from earlier files.

  1. setup.cfg
  2. tox.ini
  3. pep8.ini
  4. .sqlfluff
  5. pyproject.toml


Configuration options

  • sqlfluff.enable: Enable coc-sqlfluff extension, default: true
  • sqlfluff.commandPath: The path to the sqlfluff command (Absolute path), default: ""
  • sqlfluff.builtin.pythonPath: Python 3.x path (Absolute path) to be used for built-in install, default: ""
  • sqlfluff.dialect: The dialect of SQL to lint, valid option: ["ansi", "bigquery", "clickhouse", "databricks", "db2", "exasol", "hive", "mysql", "oracle", "postgres", "redshift", "snowflake", "soql", "sparksql", "sqlite", "teradata", "tsql"], default: "ansi"
  • sqlfluff.linter.ignoreParsing: Whether the sql linter should ignore parsing errors, default: true
  • sqlfluff.lintOnOpen: Lint file on opening, default: true
  • sqlfluff.lintOnChange: Lint file on change, default: true
  • sqlfluff.lintOnSave: Lint file on save, default: true
  • sqlfluff.formatEnable: Whether the document formatter is enabled or not, default: true
  • sqlfluff.formatIgnoreStderrAlert: Ignore stderr message output when formatting is executed, e.g. Unfixable violations detected, default: true


  • sqlfluff.install: Install sqlfluff
    • It will be installed in this path:
      • Mac/Linux: ~/.config/coc/extensions/coc-sqlfluff-data/sqlfluff/venv/bin/sqlfluff
      • Windows: ~/AppData/Local/coc/extensions/coc-sqlfluff-data/sqlfluff/venv/Scripts/sqlfluff.exe
  • sqlfluff.fix: Run sqlfluff fix file
  • sqlfluff.format: Run sqlfluff format file (Available in sqlfluff v2.0.0 and later)
  • sqlfluff.showOutput: Show sqlfluff output channel

Code Actions

Example key mapping (Code Action related):

nmap <silent> ga <Plug>(coc-codeaction-line)


In the line with diagnostic message, enter the mapped key (e.g. ga) and you will see a list of code actions that can be performed.


  • Ignoring Errors for current line (-- noqa)
  • Ignoring Errors for current line (-- noqa: disable=all)
  • Ignoring Errors for current line (-- noqa: enable=all)
  • Show web documentation for {RULE_ID}




This extension is built with create-coc-extension

Popular Sql Projects
Popular Vim Projects
Popular Data Processing Categories
Related Searches

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.