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

SQLancer

sqlancer.github.io

  • Free plan
  • Windows
  • macOS
  • Linux

What SQLancer is

SQLancer automatically tests database management systems to locate implementation bugs. It generates SQL statements and database states, then checks query behavior with test oracles. Listed methods include TLP, NoREC, PQS, DQP, CODDTest, and CERT. The tool targets logic errors, performance problems, unexpected internal errors, and database crashes. Its supported-database page lists 21 implementations, including PostgreSQL, MySQL, SQLite, DuckDB, and ClickHouse. SQLancer runs on Linux, macOS, and Windows, and requires Java 11 or later plus Maven. Releases are available through GitHub, Maven Central, and DockerHub, with the README recommending the latest source on GitHub. DuckDB, H2, and SQLite can run as embedded databases with binaries supplied as JAR dependencies. Runs may continue indefinitely when no bugs appear, but options can stop after a chosen bug count or timeout. The project is free under the MIT License, with no paid tiers listed. Its README points users to a Slack workspace for discussions.

Who it suits

SQLancer is for developers and database-testing teams who need automated SQL-based checks across supported database systems. It also suits researchers investigating DBMS behavior.

Good to know, and what to watch

  • Automates SQL test generation
  • Targets several bug categories
  • Supports 21 listed implementations
  • MIT-licensed and free
  • Runs on Linux, macOS, and Windows
  • Requires Java 11 or later and Maven
  • Runs may continue indefinitely
  • Other DBMS versions can produce false alarms

Free

Free

Free plan

The verdict

SQLancer provides automated, self-hosted database testing with multiple test oracles and broad listed DBMS support. Users should match tested database versions and configure stopping conditions for long runs.

What the maker publishes

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

Checked against the maker's pages on 4 Oct 2026.