mocksql is an open-source CLI tool that generates SQL unit test data for analytics engineers. It uses SQLGlot to extract constraints, leverages LLMs to generate fixtures, and validates results with DuckDB, automatically retrying on empty outputs. Ideal for testing analytics workflows.
mocksql is a Testing & QA product. It focuses on generating realistic SQL test data for analytics engineers without manual fixture creation. It is built as an open-source project for analytics engineers. mocksql is open source under the MIT license. mocksql is available on the command line.
skadel builds and maintains mocksql, and the product first shipped in 2026. Development happens publicly on GitHub with 415 commits in the last 90 days. Key capabilities include SQL data generation, constraint extraction, and LLM fixture generation.
Latest indexed changes and source events
Other apps tracked under the same category.
