moeryomenko/sqlcheck repository overview

⁠What Is SQLCheck?

sqlcheck automatically detects common SQL anti-patterns. Such anti-patterns often slow down queries. Addressing them will, therefore, help accelerate queries.

sqlcheck targets all major SQL dialects.

For development updates on sqlcheck and general news on next generation database systems⁠.

⁠What it can do

Right now SQLCheck can detect the following anti-patterns:

⁠Logical Database Design Anti-Patterns

• Multi-Valued Attribute⁠
• Recursive Dependency⁠
• Primary Key Does Not Exist⁠
• Generic Primary Key⁠
• Foreign Key Does Not Exist⁠
• Entity-Attribute-Value Pattern⁠
• Metadata Tribbles⁠

⁠Physical Database Design Anti-Patterns

• Imprecise Data Type⁠
• Values In Definition⁠
• Files Are Not SQL Data Types⁠
• Too Many Indexes⁠
• Index Attribute Order⁠

⁠Query Anti-Patterns

• SELECT *⁠
• NULL Usage⁠
• NOT NULL Usage⁠
• String Concatenation⁠
• GROUP BY Usage⁠
• ORDER BY RAND Usage⁠
• Pattern Matching Usage⁠
• Spaghetti Query Alert⁠
• Reduce Number of JOINs⁠
• Eliminate Unnecessary DISTINCT Conditions⁠
• Implicit Column Usage⁠
• HAVING Clause Usage⁠
• Nested sub queries⁠
• OR Usage⁠
• UNION Usage⁠
• DISTINCT & JOIN Usage⁠

⁠Application Development Anti-Patterns

• Readable Passwords⁠

⁠Usage as cli

docker run -v /path/to/sql_queries:/sql_queries -it moeryomenko/sqlcheck:latest /bin/sqlcheck -f /sql_queries/query.sql