sql-lint

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

🚀 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

⚙️ 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

• SQLFluff Documentation
• SQL Style Guide