sqlsmith
« Back to VersTracker
Description:
Random SQL query generator
Type: Formula  |  Tracked Since: Dec 28, 2025
Links: Homepage  |  formulae.brew.sh
Category: Developer tools
Tags: sql testing fuzzing database generator
Install: brew install sqlsmith
About:
Sqlsmith is a random SQL query generator designed for testing database engines and SQL parsers. It generates syntactically valid but complex SQL queries to uncover edge cases, bugs, and performance issues. This tool is invaluable for ensuring robustness and reliability in database systems under diverse query loads.
Key Features:
  • Generates complex, valid SQL queries for stress testing
  • Supports multiple SQL dialects and database backends
  • Helps identify parser bugs and edge cases in SQL engines
  • Configurable query complexity and generation parameters
Use Cases:
  • Fuzz testing SQL parsers and database engines for bugs
  • Benchmarking database performance under random query loads
  • Validating SQL compliance and robustness of new database features
Alternatives:
  • SQLancer – SQLancer focuses on logic bugs via query equivalence testing, while Sqlsmith generates random queries for broader fuzzing.
  • Jepsen – Jepsen tests distributed database consistency, whereas Sqlsmith targets SQL parsing and execution correctness.
Version History
Detected Version Rev Change Commit
Sep 15, 2025 12:03pm 4 VERSION_BUMP 1a696b27
Dec 22, 2024 6:54pm 4 VERSION_BUMP c7ba4674
Sep 13, 2024 4:36am 3 VERSION_BUMP 22b84750