sqlsmith
random SQL query generator
Install
- All systems
-
curl cmd.cat/sqlsmith.sh
- Debian
-
apt-get install sqlsmith - Ubuntu
-
apt-get install sqlsmith - Kali Linux
-
apt-get install sqlsmith - Windows (WSL2)
-
sudo apt-get updatesudo apt-get install sqlsmith - Raspbian
-
apt-get install sqlsmith - Dockerfile
- dockerfile.run/sqlsmith
sqlsmith
random SQL query generator
SQLsmith is a random SQL query generator. Its paragon is Csmith, which proved valuable for quality assurance in C compilers. It currently 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. Besides PostgreSQL developers, users developing extensions of PostgreSQL might also be interested in exposing their code to SQLsmith's random workload. During its prototyping stage, it already found about thirty bugs in PostgreSQL alphas, betas and releases, including security vulnerabilities in released versions.