MockSQL

MockSQL generates SQL unit-test fixtures with an LLM, runs them locally on DuckDB, evaluates their quality, and saves replayable tests for CI. Install the CLI with pip install mocksql; install mocksql[bigquery], mocksql[snowflake], or mocksql[all] when a source connector is needed.

Generated tests never execute against the source warehouse. See the project README for user setup and connector guidance.

Development

Pour l'installation, la configuration GCP et le CLI, voir le README racine.

FastAPI · LangGraph · Python 3.12

python -m venv .venv
source .venv/bin/activate   # Windows : .\.venv\Scripts\activate
pip install poetry && poetry install --all-extras

cp .env.example .env        # compléter les variables (voir README racine §3)
uvicorn server:app --port 8080 --reload

Les connecteurs sources (BigQuery, Snowflake) sont des extras optionnels, exclus de l'install de base pour l'alléger. poetry install seul n'installe que le cœur (génération + DuckDB) ; ajoutez --all-extras (ou --extras "bigquery snowflake") pour travailler sur le profiling/import.

Commandes

make style    # ruff check + ruff format --check + vulture (code mort)
make format   # auto-format + auto-fix ruff
make test     # pytest
make check    # style + test

Type checking :

poetry run mypy build_query/ app/

Packaging

poetry build --output dist

This produces the mocksql wheel and source distribution in dist/.

License

MockSQL is released under the MIT License.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

mocksql-0.2.1.tar.gz (1.2 MB view details)

Uploaded Jul 26, 2026 Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

The dropdown lists show the available interpreters, ABIs, and platforms. Enable javascript to be able to filter the list of wheel files.

mocksql-0.2.1-py3-none-any.whl (1.2 MB view details)

Uploaded Jul 26, 2026 Python 3

File details

Details for the file mocksql-0.2.1.tar.gz.

File metadata

Download URL: mocksql-0.2.1.tar.gz
Upload date: Jul 26, 2026
Size: 1.2 MB
Tags: Source
Uploaded using Trusted Publishing? Yes
Uploaded via: twine/6.1.0 CPython/3.13.14

File hashes

Hashes for mocksql-0.2.1.tar.gz
Algorithm	Hash digest
SHA256	`00836850f1f515d37b10922c284fd7991111ee88936655ca60c93d52aa236e23`
MD5	`dd547a514ee049ede07a3bc7b9ddcdf6`
BLAKE2b-256	`dd9c44c56346a96384ed47cf2eb0b8969efee37a064ba7dc6599053e90fbed83`

See more details on using hashes here.

Provenance

The following attestation bundles were made for mocksql-0.2.1.tar.gz:

Publisher: release.yml on skadel/mocksql

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Statement:
- Statement type: https://in-toto.io/Statement/v1
- Predicate type: https://docs.pypi.org/attestations/publish/v1
- Subject name: mocksql-0.2.1.tar.gz
- Subject digest: 00836850f1f515d37b10922c284fd7991111ee88936655ca60c93d52aa236e23
- Sigstore transparency entry: 2256520941
- Sigstore integration time: Jul 26, 2026
Source repository:
- Permalink: skadel/mocksql@c2b68589410a763ccef1685863126d07c46b53bd
- Branch / Tag: refs/tags/v0.2.1
- Owner: https://github.com/skadel
- Access: public
Publication detail:
- Token Issuer: https://token.actions.githubusercontent.com
- Runner Environment: github-hosted
- Publication workflow: release.yml@c2b68589410a763ccef1685863126d07c46b53bd
- Trigger Event: push