Analyze SQL queries for anti-patterns and performance issues.
npx skills add https://github.com/abdullah1854/ClaudeSuperSkills --skill sql-analyzer
Please help me install this Agent Skill. Skill: sql-analyzer Source: https://github.com/abdullah1854/ClaudeSuperSkills/tree/main/sql-analyzer Command: npx skills add https://github.com/abdullah1854/ClaudeSuperSkills --skill sql-analyzer
Analyzes SQL queries for anti-patterns and performance issues.
Analyze a sample SQL query to surface issues and improvement points.
High-intent search queries and answers about installing and using this skill.
SQL anti-pattern detection identifies performance issues like SELECT *, missing WHERE clauses on UPDATE/DELETE, leading wildcard LIKE, and ORDER BY ordinal. The analyzer scans queries across MSSQL, PostgreSQL, and MySQL, computes a complexity score, and returns a prioritized report with recommended fixes.
Yes. The analyzer is designed for development, code review, and automated CI pipeline integration. It produces structured reports with prioritized issues, making it suitable for catching anti-patterns before deployment.
The analyzer applies to MSSQL, PostgreSQL, and MySQL query dialects. It detects common anti-patterns and optimization opportunities across these database systems.
Yes. Beyond anti-pattern detection, the analyzer recommends potential indexing improvements to optimize query performance.
The analyzer detects SELECT * usage, missing WHERE clauses on UPDATE/DELETE operations, leading wildcard LIKE patterns, and ORDER BY ordinal references. It computes a complexity score and flags issues with recommended fixes.
mymx2Parse SQL statements into a Concrete Syntax Tree preserving comments and whitespace.
Monsoft-SolutionsAudit websites for crawlability, indexation, and on-page SEO issues.
HieubkavAnalyze database indexes and query execution plans to recommend optimizations.
bcastelinoAnalyze SQL query execution plans and design indexing strategies.
