Skip to content

SKILL.md

Latest commit

 

History

History
83 lines (59 loc) · 1.68 KB

SKILL.md

File metadata and controls

83 lines (59 loc) · 1.68 KB
Raw
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