SQLsmith is a random SQL query generator for PostgreSQL. It is inspired
by Csmith, which generates random C code.
Use cases are quality assurance through fuzz testing and benchmarking.
Besides PostgreSQL developers, users developing extensions might also be
interested in exposing their code to SQLsmith's random workload.
During its development, it already found about thirty bugs in
PostgresSQL alphas, betas and releases, including security
vulnerabilities in released versions. There is a score list maintained
by its users in a wiki:
https://github.com/anse1/sqlsmith/wiki#score-list
Version 1.0 supports generating queries for PostgreSQL 9.5 or later
only. SQLsmith was designed with testing different versions and even
products in mind, but this has not manifested yet for the first release.
SQLsmith is available under GPLv3 at
https://github.com/anse1/sqlsmith/releases/latest
Packages for Debian/Ubuntu are available via apt.postgresql.org.
In case you need consulting for testing your PostgreSQL-based product
with SQLsmith, or simply want to speed up SQLsmith's developement,
contracted work is available via my employer at
https://www.credativ.de/
mailto:info@credativ.de
