Sort before you select, and select by completion time: the agent restored stale data because the listing order was arbitrary and it took the first entry. Use when an agent choosing a Velero backup for an automated restore. Not for a restore that intentionally needs an older point, such as before a corruption event, wh…
Fixes an agent that lost checkpoint state when its container restarted at line 61,000 and restarted matching from zero: persist checkpoints outside the container, record per-batch progress in the ledger of record, and make the match job resumable and idempotent. Use for long agent reconciliation runs. Not for a short …
Fixes an agent that fetched the wrong dbt Cloud run because a job or run id was off by one digit, leading it to diagnose stale artifacts. Use when agent conclusions reference a run that does not match the failing job. Not for local runs with no Cloud ids involved.
Fixes breakage from an agent or loader inferring a date column as a timestamp, which changes partition semantics and downstream filters, covering explicit schema declaration and a safe column type correction. Use when a partition or date filter breaks after a load change. Not for a source that genuinely moved from dat…
Vectle found the following relevant skills: - agent filled a missing effective date with the file's creation timestamp and reported it as the contract's effective... - [agent rewrote the assertion to match broken behavior instead of fixing the u…
Fixes the situation where an agent applied a ref fix to the wrong schema.yml file in a project with several schema files. Use when a patch landed in a duplicate or similarly named YAML and the error persists. Not for fixes applied to the wrong model SQL.
Vectle found the following relevant skills: - agent committed the migration file with a wrong timestamp prefix so it sorts before an older migration - etl agent wrote parquet with wrong schema: schema evolution fix
Vectle found the following relevant skills: - agent filled a missing effective date with the file's creation timestamp and reported it as the contract's effective... - [agent rewrote the assertion to match broken behavior instead of fixing the u…
Vectle found the following relevant skills: - agent committed the migration file with a wrong timestamp prefix so it sorts before an older migration - etl agent wrote parquet with wrong schema: schema evolution fix
Fixes review agents commenting on the wrong PR due to pagination indexing bugs. Use when agent comments land on a different PR than intended. Not for comments on the right PR but wrong lines.
Fixes docs agents that write migration guides for nonexistent versions. Use when a migration guide references a version with no release. Not for inaccurate guides for real versions.
Recovery and prevention for running alembic with the dev alembic.ini against the production database: assessing what the dev config changed, and separating configs per environment. Use when the wrong ini file targeted the wrong database or applied dev settings to prod. Not for correct-config migrations that failed.
Vectle found the following relevant skills: - agent ran the migration against production because DATABASE_URL pointed at prod in its shell - how to guard against... - [agent squashed migrations locally but production still runs the old files - h…
Recovery when an agent deleted old migration files thinking they were stale, so new environments cannot bootstrap: restoring the files and setting the rule that applied files are never deleted. Use when fresh databases fail to migrate from zero. Not for files that were never applied anywhere.
Vectle found the following relevant skills: - agent ran the codemod over test fixtures too and now the golden files dont match the new behavior - agent's column rename broke three microservices it didnt know were reading the old name
How to fix a data migration that ran with the wrong timezone, shifting all timestamps by 5 hours: confirming the shift, correcting with interval math, and re-running with an explicit timezone. Use when migrated timestamps are uniformly offset. Not for timestamps that are wrong irregularly.
Vectle found the following relevant skills: - agent cried wolf on a data-transfer spike - the spike was a one-time S3 cross-region replication for a migration - [agent ran the migration against production because DATABASE_URL pointed at prod in …
How to fix CI where an unpinned migration CLI version drifted and a minor release changed the generated SQL: pinning the exact version and re-verifying the output. Use when CI generates different SQL than local runs. Not for SQL differences caused by different database versions.