EVERYTHING XIAOMI
Get listed

SQLancer

SQLancer automatically tests database management systems to find bugs in their implementation.

Place
#16 of 28
Score
6.0
SQLancer's website

What SQLancer is

SQLancer automatically tests database management systems to find bugs in their implementation. It generates SQL statements and database states, then validates queries using test oracles. Listed methods include TLP, NoREC, PQS, DQP, CODDTest and CERT. SQLancer targets logic bugs, performance issues, unexpected internal errors and database crashes. Its supported database list includes 21 implementations, among them PostgreSQL, MySQL, SQLite, DuckDB and ClickHouse. The project's impact page reports evidence of use by 22 DBMS projects. SQLancer runs on Linux, macOS and Windows, and requires Java 11 or later and Maven. It is free under the MIT License, with no paid tiers listed. Releases are available through GitHub, Maven Central and DockerHub; the README recommends the latest source on GitHub. DuckDB, H2 and SQLite can run as embedded systems with binaries included as JAR dependencies. A run may continue indefinitely when no bugs are found, though options can stop it after a chosen bug count or timeout. The project README points users to a Slack workspace for testing discussions.

Good

  • Free under the MIT License
  • Supports 21 listed database implementations
  • Targets logic, performance and crash issues
  • Can stop after a chosen bug count or timeout
  • Embedded support for DuckDB, H2 and SQLite

Watch out

  • Requires Java 11 or later and Maven
  • Runs may continue indefinitely without bugs
  • Other DBMS versions may produce false alarms

Who it suits

SQLancer suits database developers and testers looking for automated checks of DBMS behavior. Users should be comfortable with its Java and Maven requirements and self-hosted test execution.

Verdict

SQLancer offers automated DBMS testing across a broad set of listed implementations, with several test oracles and no paid tier. Check the tested-version limits and provide a stopping condition if an uninterrupted run is not wanted.

Plans and prices

From SQLancer's own pricing page, checked 4 Oct 2026.

All about pricing
PlanPriceWhat it gives you
FreeFreeMIT License · no paid tiers listed

The facts

Each one read from SQLancer's own pages, with the date it was checked.

What it does

Adoption
The impact page reports 22 DBMS projects with evidence of using SQLancer.checked 4 Oct 2026
Bug types
It targets logic bugs, performance issues, unexpected internal errors, and database crashes.checked 4 Oct 2026
Database support
The official supported-databases page lists 21 implementations, including PostgreSQL, MySQL, SQLite, DuckDB, and ClickHouse.checked 4 Oct 2026
DBMS version limits
The README says SQLancer is tested against specific DBMS versions and that testing other versions can produce false alarms.checked 4 Oct 2026
Distribution
The README says releases are available through GitHub, Maven Central, and DockerHub, and recommends the latest source on GitHub.checked 4 Oct 2026
Embedded databases
DuckDB, H2, and SQLite are supported as embedded systems with binaries included as JAR dependencies.checked 4 Oct 2026
License
The project says it is free to use under the MIT License.checked 4 Oct 2026
Purpose
SQLancer automatically tests database management systems to find bugs in their implementation.checked 4 Oct 2026
Requirements
The README lists Java 11 or above and Maven as minimum requirements.checked 4 Oct 2026
Run behavior
SQLancer can run indefinitely when it finds no bugs; the README describes options to stop after a chosen number of bugs or a timeout.checked 4 Oct 2026
Support
The project README points users to a Slack workspace for SQLancer and DBMS testing discussions.checked 4 Oct 2026
Test generation
It generates SQL statements and database states, then validates queries using test oracles.checked 4 Oct 2026
Testing methods
Its listed test oracles include TLP, NoREC, PQS, DQP, CODDTest, and CERT.checked 4 Oct 2026

Alternatives to SQLancer

All alternatives
  1. 1Atlas logo

    Atlas

    Free planOpen sourceWebAPILinuxmacOS
    8.3From $39 a month
    Visit
  2. 2DataKitchen TestGen logo

    DataKitchen TestGen

    Free planOpen sourceWebAPILinuxmacOS
    8.1From $100 a month
    Visit
  3. 3Soda logo

    Soda

    Free planWebAPILinuxSelf-hosted
    7.5From $750 a month
    Visit
  4. 4

    Avidemux

    Free planOpen sourceWebLinuxmacOSWindows
    7.3Free plan
    Visit
  5. 5

    pgroll

    Free planOpen sourceLinuxmacOSSelf-hostedWindows
    7.3Free plan
    Visit
  6. 6Bytebase Enterprise logo

    Bytebase Enterprise

    Free planWebAPISelf-hosted
    6.8From $20 a month
    Visit