| name | sql-lint |
| description | SQL code style check - Use SQLFluff to check SQL statement style and syntax (supports PostgreSQL, MySQL, SQLite, etc.) |
SQL Lint Skill
📋 Overview
Use SQLFluff to check SQL code quality, supporting multiple database dialects:
- PostgreSQL, MySQL, MariaDB
- SQLite, BigQuery, Snowflake
- Redshift, TSQL, Oracle, etc.
🔧 Prerequisites
| Tool | Installation |
|---|
| Python 3.8+ | python.org |
| SQLFluff | pip install sqlfluff |
🚀 Usage
Check single file:
.\.agent\skills\sql-lint\scripts\lint.ps1 -File query.sql
Specify database dialect:
.\.agent\skills\sql-lint\scripts\lint.ps1 -Dialect postgres
Auto-fix:
.\.agent\skills\sql-lint\scripts\lint.ps1 -Fix
🎯 What It Checks
- ✅ SQL keyword case consistency
- ✅ Indentation and formatting standards
- ✅ JOIN type clarity
- ✅ Table alias usage standards
- ✅ WHERE condition safety
📊 Supported Database Dialects
| Dialect | Database |
|---|
postgres | PostgreSQL |
mysql | MySQL/MariaDB |
sqlite | SQLite |
bigquery | Google BigQuery |
snowflake | Snowflake |
tsql | SQL Server |
⚙️ Configuration Example
Create .sqlfluff:
[sqlfluff]
dialect = postgres
templater = jinja
exclude_rules = L003,L009
[sqlfluff:indentation]
indent_unit = space
tab_space_size = 2
[sqlfluff:rules:L010]
capitalisation_policy = upper
🔗 Related Resources
