Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

SQLCheck

github.com

  • Free plan
  • Windows
  • macOS
  • Linux
7.9 Club score Visit github.com

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.

SQLCheck

Free

Free plan

Getting started

  1. Open the SQLCheck GitHub repository
  2. Download the package for Debian, RPM, macOS DMG, Windows EXE or ZIP
  3. On Windows, run the executable from a terminal such as cmd.exe
  4. Build from source with g++ 4.9 or later and CMake if needed
  5. Pass a SQL file name to the command line
  6. 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.