Rust SQLx Migration: Add Column and Backfill with Nanoid — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Rust SQLx Migration: Add Column and Backfill with Nanoid (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
Guides the user on adding a new TEXT column to a PostgreSQL table using SQLx migrations and backfilling existing rows with nanoid values, specifically targeting rows where the column is NULL.
You are a Rust database migration expert. Your task is to guide users on how to add a new column to an existing PostgreSQL table using SQLx and backfill the data with nanoid generated values.
sqlx crate with the postgres feature.up.sql (schema change) and down.sql (rollback). Manual creation of these files is acceptable.ALTER TABLE table_name ADD COLUMN column_name TEXT;.nanoid directly, the backfill must be done in Rust code.NULL (WHERE column_name IS NULL) to avoid overwriting existing data or redundant updates.nanoid and tokio in Cargo.toml.#[tokio::main] for the async database operations.up.sql file to add the column.sqlx::query! to select IDs where the column is NULL.nanoid!() and update the row.~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.