SQLCheck
github.com
- Free plan
- Windows
- macOS
- Linux
What SQLCheck is
SQLCheck is a free command-line tool that detects common SQL anti-patterns associated with slower queries. It organizes findings into logical database design, physical database design, query, and application development categories. Users provide a SQL file name and can inspect all patterns, medium- and high-risk patterns, or high-risk patterns only. Color and verbose modes are available for output. The project says it targets all major SQL dialects and specifically lists Microsoft SQL Server, MySQL, Oracle, PostgreSQL, and SQLite3. Downloads include Debian, RPM, macOS DMG, Windows EXE, and ZIP packages; source builds require g++ 4.9 or later and CMake. The v1.3 release notes include line numbers and a status code of 1 when anti-patterns are found. SQLCheck does not automatically fix findings, and the project documents file-based command-line use rather than a hosted service, graphical interface, API, or mobile app. It is licensed under Apache-2.0, and the README welcomes contributions through issues, pull requests, and documentation improvements.
Who it suits
SQLCheck suits developers and database teams comfortable analyzing SQL files from a command line. It is available on Linux, macOS, and Windows.
Good to know, and what to watch
- Free command-line utility with no paid tiers stated.
- Offers all-pattern and risk-level filtering.
- Packages listed for Linux, macOS, and Windows.
- Supports several named SQL dialects.
- Does not automatically fix detected anti-patterns.
- No editor extensions or configuration file.
- No hosted service or graphical interface is described.
Plans
Every plan and priceSQLCheck
Free plan
Getting started
- Open the SQLCheck GitHub repository
- Download the package for Debian, RPM, macOS DMG, Windows EXE or ZIP
- On Windows, run the executable from a terminal such as cmd.exe
- Build from source with g++ 4.9 or later and CMake if needed
- Pass a SQL file name to the command line
- Choose all, medium/high-risk or high-risk checks and enable color or verbose output
Limits to check
The tool analyzes SQL files from the command line and does not automatically repair findings. No usage quotas or paid tiers are stated.
The Club's review
SQLCheck is a free, open-source command-line scanner for SQL anti-patterns, best suited to developers who review SQL files across different database systems. Its risk filters make it useful for focused checks, but it reports findings rather than fixing them, so it is not a substitute for an editor or SQL development environment.
Overview
SQLCheck looks for common SQL anti-patterns that can slow queries, grouping them across logical and physical database design, queries, and application development. That reach can help surface issues beyond query wording alone, while its file-based terminal workflow keeps the tool narrowly focused.
The project targets major SQL dialects, including Microsoft SQL Server, MySQL, Oracle, PostgreSQL, and SQLite3. It is licensed under Apache-2.0, and the project welcomes contributions through issues, pull requests, and documentation improvements.
Key features
- Risk-level selection: Run checks for all anti-patterns, medium- and high-risk patterns, or high-risk patterns only. This gives developers a way to narrow a scan to more serious risks, though deciding which findings matter in a particular database remains the user's job.
- File-based scanning: Supply a SQL file name on the command line. The v1.3 release adds line numbers and returns status code 1 when anti-patterns are found, making it easier to locate findings and for scripts to respond to them.
- Color and verbose modes: These output options let users choose a more visual or more detailed terminal report, without adding an editor interface.
- Install or build locally: Downloads include Debian, RPM, macOS DMG, Windows EXE, and ZIP packages. Users building from source need g++ 4.9+ and CMake; that flexibility suits users comfortable with command-line installation, but adds setup work for others.
SQLCheck is a standalone utility: its documented workflow does not include integrations with other products. It also has no automatic fixes, editor extensions, configuration file, hosted service, graphical interface, API, or mobile app, so users seeking those capabilities should look elsewhere.
Pricing
SQLCheck is free: the SQLCheck plan costs nothing. It is an open-source command-line tool with no paid tiers or usage limits stated. That makes it straightforward to adopt for individual use or team evaluation, but there is no paid tier to add service or workflow features.
Platforms
SQLCheck supports Linux, macOS, and Windows. The README provides packages for each platform, including a Windows executable intended to run from a terminal such as cmd.exe. This is a practical fit for users comfortable with terminal workflows on desktop systems, not for those who need a browser-based or mobile tool.
Who it's for
SQLCheck is a reasonable choice for developers and database practitioners who want a free, cross-platform scan of SQL files and a way to filter findings by risk. Its category coverage can serve as a focused review aid across several database systems. It is less suitable for users who want inline editor feedback, automatic remediation, or an integrated hosted workflow.
Pros and cons
- Pro — Risk-based checks: Selecting all, medium- and high-risk, or high-risk anti-patterns helps focus a review instead of treating every finding alike.
- Pro — Broad database coverage: Named support for SQL Server, MySQL, Oracle, PostgreSQL, and SQLite3 makes it relevant across common database environments.
- Pro — No-cost open-source use: The Apache-2.0 license and free plan make adoption possible without a paid tier.
- Con — Terminal and file workflow: Analysis starts with a SQL file and runs from the command line, which may interrupt workflows built around an editor or graphical application.
- Con — Findings require follow-through: SQLCheck does not provide automatic fixes, so users must assess and address anti-patterns themselves.
Alternatives
For a wider comparison, see SQL Linters and Formatters.
Choose sqlfmt if you want a browser-based formatter that runs through WebAssembly without installation. Poor SQL is an option for users seeking online and offline formatting or an SSMS/Visual Studio plugin. TSQLLint may suit users who want an installable linter through dotnet-tool, Homebrew, or NPM. JSQLFormatter is another free alternative. For build-machine use, consider SQL Enlight, which has a plan for CI/CD pipelines, servers, and build machines, along with a free trial. sqlfmt offers a free plan with 20 analyses per day, five dialects, live formatting, and saved snippets and history. Sqruff is another free option. RegSQL may fit users who want browser-local formatting and a free allowance of 20 AI requests per month.
Verdict
Choose SQLCheck if you want a free command-line scan of SQL files, with risk filters and coverage across several database systems. Its main strength is focused anti-pattern detection without a paid tier; look elsewhere if your workflow depends on editor integration, a graphical or hosted interface, or automatic fixes.
The verdict
SQLCheck provides a focused way to surface SQL anti-patterns from files and control which risk levels appear. It may fit command-line workflows, but findings require users to address them themselves.
Questions people ask
How much does SQLCheck cost?
SQLCheck is free, with a listed price of free and no paid tiers stated.
Which SQL dialects are supported?
The project lists Microsoft SQL Server, MySQL, Oracle, PostgreSQL and SQLite3, and says it targets all major SQL dialects.
Which operating systems have downloads?
Downloads are listed for Debian, RPM, macOS DMG, Windows EXE and ZIP packages. Supported platforms are Linux, macOS and Windows.
Does SQLCheck fix anti-patterns automatically?
No. The listed tool detects anti-patterns but does not provide automatic fixes.
Does it integrate with editors or other products?
No editor extensions are listed, and the maker pages describe it as a standalone command-line utility without stated integrations.
Who makes SQLCheck?
The GitHub profile for jarulraj identifies the maker as Joy Arulraj, an Associate Professor at Georgia Tech in Atlanta.
What the maker publishes
- Build requirements
- The source build instructions list g++ 4.9+ and CMake as dependencies. source
- Build requirements
- Building from source requires g++ 4.9+ and CMake, and the repository should be cloned with its recursive option. source
- Contributions and help
- The README welcomes contributions through issues, pull requests, and documentation improvements. source
- Detection categories
- It groups detected anti-patterns into logical database design, physical database design, query, and application development categories. source
- Detection coverage
- It lists anti-patterns in logical database design, physical database design, queries, and application development. source
- Downloads
- The README lists Debian, RPM, macOS DMG, Windows EXE, and ZIP downloads. source
- Input
- The command line accepts a SQL file name for analysis. source
- Input and output
- The command-line tool accepts a file name and offers color and verbose modes. source
- Integrations
- The maker pages opened describe a standalone command-line utility and do not state integrations with other products. source
- License
- The repository says SQLCheck is licensed under the Apache License. source
- macOS and Linux
- The README provides macOS DMG and Debian, RPM, and ZIP packages, with source-build instructions as well. source
- Maker
- The GitHub profile identifies jarulraj as Joy Arulraj, an Associate Professor at Georgia Tech in Atlanta. source
- Notable limitation
- The README documents file-based command-line use; it does not describe a hosted service, graphical interface, API, or mobile app. source
- Output options
- The command line provides color and verbose modes. source
- Purpose
- SQLCheck automatically detects common SQL anti-patterns that can slow queries. source
- Purpose
- SQLCheck automatically detects common SQL anti-patterns that can slow queries. source
- Release features
- The v1.3 release notes list line numbers and a status code of 1 when anti-patterns are found. source
- Release features
- The v1.3 release lists line numbers and exit status 1 when anti-patterns are found. source
- Risk levels
- The command line lets users check all anti-patterns, medium- and high-risk patterns, or high-risk patterns only. source
- Risk levels
- The command-line option supports checking all anti-patterns, medium and high risk only, or high risk only. source
- Security and compliance
- The repository identifies its license as Apache-2.0 and does not state security certifications or compliance claims. source
- SQL dialects
- The project says it targets all major SQL dialects. source
- SQL dialects
- The project says it targets all major SQL dialects. source
- Support
- The project invites users to open issues, submit pull requests, and improve its documentation. source
Checked against the maker's pages on 8 Oct 2026.