{"data":{"kind":"file","path":"README.md","version_id":"uz9eknx8on2hr8hwavj0pf03","entry":{"name":"README.md","path":"README.md","is_directory":false,"size":1436,"modified_at":"2026-08-10T10:09:40.842000","content_hash":"dc71bb9294714ea5d1cf12d99379d62e21c7835813ca121aa53500b827d6dbee"},"entries":[],"content":"# Database Schema Migration Simulator\n\nA verifiers environment that evaluates LLMs on generating correct SQL DDL migration scripts. Given a source schema and a description of desired changes, the model must produce a valid, idempotent migration script that transforms the source into the target.\n\n## Task Types\n\n- **Column operations**: ADD, DROP, ALTER TYPE, RENAME columns\n- **Table operations**: CREATE, DROP, RENAME tables\n- **Constraint management**: ADD/DROP primary keys, foreign keys, unique constraints, check constraints\n- **Index management**: CREATE/DROP indexes, composite indexes\n- **Data type migrations**: VARCHAR expansion, INT to BIGINT, TEXT to JSONB\n- **Multi-step migrations**: Complex scenarios combining multiple operations with correct ordering\n\n## Difficulty Levels\n\n- **Level 0**: Single column add/drop\n- **Level 1**: Column type change + constraint add\n- **Level 2**: Multi-table foreign key migration\n- **Level 3**: Full schema evolution with ordering dependencies\n- **Level 4**: Cross-dialect migrations (PostgreSQL / MySQL / SQLite)\n\n## Scoring\n\n- **sql_syntax_score**: Valid SQL syntax (parses without errors)\n- **operation_correctness**: Correct operations identified and applied\n- **ordering_score**: DDL statements in safe execution order (drops after references removed)\n- **idempotency_score**: Script uses IF EXISTS / IF NOT EXISTS for safety\n- **completeness_score**: All required changes covered\n","encoding":"utf-8","truncated":false,"total_bytes":1436},"status":null}