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.
SQLCheck is free and open source software. It’s no longer maintained.
Key Features
- 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.
Website: github.com/jarulraj/sqlcheck
Support:
Developer: Joy Arulraj
License: Apache License
SQLCheck is written in C++. Learn C++ with our recommended free books and free tutorials.
Related Software
| MySQL Tools | |
|---|---|
| DBeaver | Universal database tool |
| phpMyAdmin | MySQL web administration tool |
| MySQL Workbench | Complete visual database design tool |
| mycli | Command line interface for MySQL, MariaDB, and Percona |
| gh-ost | GitHub's Online Schema Migrations for MySQL |
| Beekeeper Studio | Cross-platform SQL editor and database manager |
| usql | Command-line database client |
| sqlit | lazygit of SQL databases |
| MySQLTuner | Analyse MySQL performance and suggest configuration changes |
| Harlequin | Easy, fast, and beautiful database client for the terminal |
| DbGate | Database manager for MySQL, PostgreSQL, MongoDB |
| Percona Toolkit | Essential command-line utilities for MySQL |
| SQuirreL SQL Client | Graphical SQL client written in Java |
| Adminer | Full-featured tool for managing content in MySQL database |
| dblab | Interactive client for PostgreSQL, MySQL, SQLite3, and more |
| MyDumper | Parallel utilities for fast MySQL database backups and restores |
| Antares | SQL client based on Electron.js and Vue.js |
| XtraBackup | Backup utility for MySQL |
| innotop | Real-time, advanced investigation tool |
| Skeema | Manage MySQL and MariaDB schema changes |
| vi-sql | Terminal SQL client for browsing, querying and editing databases |
| MySQL Shell | Advanced MySQL console for scripting and database administration |
| Sequeler | Native Linux SQL client built in Vala and Gtk |
Read our verdict in the software roundup.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.