Run Sandbox
Run migration in ephemeral sandbox and validate.
Creates a temporary Postgres container, clones the target schema from the latest SchemaSnapshot, generates synthetic data, applies the migration, runs validation queries, and returns structured results.
The sandbox operation runs in a separate thread via asyncio.to_thread() to avoid blocking the FastAPI event loop.
Authorizations
Section titled “Authorizations ”Parameters
Section titled “ Parameters ”Path Parameters
Section titled “Path Parameters ”Request Body required
Section titled “Request Body required ”object
Raw SQL DDL migration to test in an ephemeral Postgres sandbox. Can contain multiple statements.
Number of rows of synthetic data to generate per table in the sandbox. Higher values give more realistic validation but slower execution.
Responses
Section titled “ Responses ”Successful Response
Response for POST /sandbox.
object
Whether the request succeeded.
object
Whether the migration applied successfully and all validation queries passed.
Whether the migration SQL was successfully executed against the sandbox schema.
Number of tables created in the sandbox from the schema snapshot.
Total number of synthetic data rows inserted across all tables.
Results of each validation query run against the post-migration sandbox.
Total sandbox execution time in milliseconds, including schema setup, data generation, migration, and validation.
Validation Error