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