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
Plans
Every plan and priceFree
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.