sqlfluff/sqlfluff

Features

• SQL Parsers - Provides a multi-dialect parser that converts SQL scripts into structured trees to validate syntax and identify logical components.
• SQL Formatters - Automatically corrects indentation, capitalization, and whitespace in SQL files for consistent visual style.
• Code Formatting and Linting - Automatically corrects style and structural violations to align SQL code with configured standards.
• Templated SQL Analyzers - Parses and lints SQL files containing macros or placeholders before they are rendered by a template engine.
• Static Template Analysis - Evaluates files containing placeholders or macros using dummy parameters to validate style and correctness.
• Templated SQL Validators - Checks the syntax and style of SQL files containing macros or placeholders before they are rendered into final queries.
• Query Style Standardizers - Enforces consistent naming conventions, aliasing standards, and structural patterns to improve the maintainability of shared database scripts.
• SQL Abstract Syntax Tree Parsing - Converts SQL code into abstract syntax trees to enable programmatic analysis and rendering in various formats.
• Template-Aware Parsing - Processes files containing format strings to lint the underlying code before it is rendered.
• Automated Tree Transformations - Applies programmatic edits, inserts, or deletions to a structured tree to correct rule violations.
• Style Guide Enforcers - Employs a rule-based engine to standardize capitalization, aliasing, and layout conventions across large database codebases.
• Template Analysis - Processes templates through various engines to map linting issues back to original source positions.
• SQL Templating Engines - Processes SQL files through a templater to produce the final rendered output.
• SQL Dialect Adapters - Swaps parser logic based on the selected SQL variety to handle varying syntax rules and keywords across dialects.
• SQL Converters - Converts code from format strings into valid SQL to enable analysis for linting errors.
• SQL Query Structure Validators - Detects structural issues such as unused common table expressions, redundant statements, and ambiguous groupings.
• Template Source Mappers - Tracks the position of elements through the templating process to map linting errors back to the original source file.
• Casing Standards - Ensures consistent casing for keywords, unquoted identifiers, function names, and data types.
• AST-Based Refactorers - Modifies the internal parse tree to apply automated fixes and renders the result back into formatted source code.
• Coding Standards Enforcement - Enforces project guidelines regarding how tables and columns are aliased using explicit keywords.
• Plugin Architectures - Integrates custom linting rules and templating engines through a defined hook-based plugin architecture.
• Rule-Based Plugin Systems - Provides a standard interface for creating modular, toggleable linting rules via a plugin system.
• Dummy-Parameter Renderers - Processes templated SQL using placeholder values to validate syntax before execution in a real environment.
• Database Tools - Modular SQL linter and auto-formatter.
• Code Review Tools - Configurable linter for SQL code and ELT applications.
• Developer Tools - SQL linter that supports dbt and Jinja.
• SQL Analysis and Linting - Configurable SQL linter with support for multiple dialects.

Star history