SQL Enlight Code Quality for Azure DevOps

SQL Enlight integrates T-SQL static code analysis into Azure DevOps pipelines, helping teams detect issues early, enforce standards, and improve SQL code quality.

Key Features

• Analyze .sql files with 300+ built-in rules
• Detect performance, maintainability, and best-practice issues
• Support custom rules and templates
• Enrich analysis with database metadata
• Apply quality gates to control build outcomes
• Publish analysis reports as build artifacts
• View reports in Azure DevOps build tab and hub
• Pull request integration:
  • PR status updates
  • Summary comments
  • Inline comments on changed lines

Task Versions

• v0 � Classic analysis task
• v1 � Enhanced task with PR integration and quality gate support

Usage

1. Add the SQL Enlight task to your pipeline
2. Configure optional settings:
   • file filters
   • rules or templates
   • analysis context or connection string
   • quality gate
3. Run the pipeline
4. Review results in:
   • logs
   • artifacts
   • SQL Enlight build tab
   • pull request comments

Analysis Context

You can improve analysis accuracy by providing:

• analysis context file, or
• database connection string

Pull Request Integration

The enhanced task can automatically:

• publish PR status
• add summary comments
• create inline issue comments

Links

• https://sqlenlight.com/azure-devops/
• https://sqlenlight.com/support