ajitpratap0/gosqlx/sql-linting

SQL linting with GoSQLX

Input: $ARGUMENTS - SQL, a .sql file, or a rule ID to explain.

Which rules run where

L011-L030 are not returned by lint_sql or the CLI. When you spot one of those patterns yourself, cite the rule ID as guidance and say it comes from the Go library's rule set.

Rules

Full reference with examples: https://github.com/ajitpratap0/GoSQLX/blob/main/docs/LINTING_RULES.md

Steps

1. Call lint_sql with {"sql": "..."}. Each violation has rule, rule_name, severity, message, line, column and suggestion.
2. Group violations by rule, show the offending line, and give the fix. For auto-fixable rules, mention gosqlx lint --auto-fix.
3. For a rule-ID question, explain the rule from the table above and show a before/after example.

Fallback when the MCP tools are unavailable

gosqlx lint query.sql
gosqlx lint -r ./queries/            # recurse into a directory
gosqlx lint --auto-fix query.sql     # rewrites the file - only when asked
gosqlx lint --fail-on-warn query.sql # non-zero exit on warnings (CI)
gosqlx lint --max-length 120 query.sql