coc-sql

A practical first workflow

Choose coc-sql for formatting SQL text and checking whether its syntax can be parsed. Its formatter and parser do not connect to your database. A clean diagnostic list does not prove that a table exists, that a query has the right permissions, or that running it is safe.

Format a small query, then check syntax

Install with :CocInstall coc-sql. Save the following as example.sql and confirm :set filetype? reports sql:

Run :CocCommand sql.Format. The query should be laid out across clauses with indentation; exact keyword casing depends on your format options. No database or users table is required for this text-only operation. Review the edit before saving.

For a separate parser check, temporarily remove users after from and inspect :CocDiagnostics, then restore the original query. If the project uses dialect-specific syntax, set sql.database to the appropriate supported dialect before treating a parser message as a database error.

If formatting works but syntax messages do not update, inspect sql.lintOnOpen, sql.lintOnChange and sql.lintOnSave. If your save action produces competing edits, choose one formatting provider. A project .sql-formatter.json takes precedence over sql.formatOptions; sql.database selects the lint dialect. Check the formatter’s own language option when the formatting dialect also needs to change.

Checked against the 0.15.0 configuration and upstream implementation. Expected formatting and parser results are example checks, not a recorded database execution.

Site-authored guidance reviewed on 2026-09-11. Content sources and maintainers · Choose extension responsibilities