Versioned security assessment

Report ID: SA-F9E2C34B

7/23/2026, 10:42:16 PM

database-migrations-sql-migrations security assessment v5

Skill Security Certification Report

Audit History
Scanner version 3.0.0 Audit model: codex Latest published report
Skill name
database-migrations-sql-migrations
Version
v5
Maintainer
sickn33
Source
github.com/sickn33/antigravity-awesome-skills/tree/main/skills/database-migrations-sql-migrations
Coverage
2 Files scanned · 555 Lines analyzed
Policy version
skillstore-security-audit-policy-v1

Highest confirmed finding severity

High

2 confirmed security findings require attention.

Installation context

Check the current Skill page

This page summarizes report evidence only. The Skill page provides the canonical install advisory.

Open current Skill page

This report does not block or authorize the manifest or ZIP.

The skill contains documentation and code samples; none automatically execute commands or access SQLite files, so all 33 static alerts are false positives for those patterns. However, the rollback and Python examples interpolate unvalidated values into SQL and paths, creating adoption-time injection and file-selection risks. No prompt injection, network access, credential exfiltration, or hidden execution was found.

Report position

Latest published report

Latest refers to the report sequence, not to artifact currentness.

Audit attestation

Active attestation

A public attestation is available for this exact report.

Human verification

Not verified

No human verification is recorded for this report.

Coverage

2 Files scanned · 555 Lines analyzed

2 items shown for review

Limitations

This report does not claim runtime or sandbox execution and does not prove the absence of side effects.

Evidence chain

Follow the evidence from source binding to the install contract. Available evidence supports verification; it is not a safety guarantee.

  1. Source

    Commit and path bound

  2. Artifact

    Content and tree hashes bound

  3. Audit

    Complete

  4. Install contract

    Open manifest to verify

    Open manifest

Capabilities observed

Observed means this report recorded supporting evidence. Not recorded does not prove that a capability is absent.

Contains scripts

May execute code included with the Skill.

Not recorded by this audit

Network access

May connect to external services.

Not recorded by this audit

Filesystem access

May read or write local files.

Not recorded by this audit

Env variables

May read values from the process environment.

Not recorded by this audit

External commands

May invoke commands or programs outside the Skill.

Observed in 3 evidence locations

Risk findings

Confirmed security concerns are separated from items that still need review.

Confirmed security concerns (2)

RISK-001 High
resources/implementation-playbook.md:335-354
Rollback Script Uses Unvalidated Migration Input
The example inserts MIGRATION_VERSION directly into a SQL command and backup or migration paths. A crafted value could alter rollback SQL or select unintended files.
The parameter comes directly from the first positional argument and is interpolated into SQL and paths without an allowlist or SQL binding.
RISK-002 High
resources/implementation-playbook.md:249-256resources/implementation-playbook.md:372-386resources/implementation-playbook.md:410-432
Dynamic SQL Examples Interpolate Unchecked Identifiers
Validation and parallel migration examples build SQL with table or column names from input objects and method arguments. Untrusted values could change query structure.
The examples place input-derived identifiers into f-strings, and no identifier composition API or allowlist appears in the surrounding code.

Remediation

Suggested fixes recorded by this audit. Applying them is the maintainer’s responsibility.

  1. FIX-001
    High
    The rollback example inserts a positional argument into SQL and filenames without validation.
    Allowlist migration versions, quote database arguments, constrain generated paths, and bind the version through psql variables instead of SQL string interpolation.
  2. FIX-002
    High
    Python examples insert input-derived table and column names into SQL strings.
    Use driver identifier-composition APIs, allowlist schema identifiers, and accept raw query fragments only from trusted application constants.

Expert evidence

Immutable subject identity, scanner metadata, dismissed matches, and source-level evidence.

Artifact subject

Marketplace commit
f9e2c34b4f19c7f3e6b0a1e93227b5f77cc12526
Content hash
f8658625b0fc4287e2f5e873448a1ac5ade2e2df8fa3837b90184c9c91e8d042
Tree hash
dd51dbd6a69786ea7ad9a558a2bfff5e308c7e8b672e545c79aa5221d202c737
Skill path
skills/sickn33/database-migrations-sql-migrations
Audit payload hash
a643dd2dd6a70180ebc4301d275faacc

Analysis metadata

Audit model: codex

Analysis state: Complete

Scope is limited to the recorded files, lines, methods, and evidence. No runtime or sandbox execution is claimed.

Verify and export

JSON report Signed attestation CITATION.cff SARIF 2.1.0 Signed installation manifest Source

The manifest and lockfile bind install artifacts to cryptographic hashes. This integrity claim is separate from the security assessment.

Audit attestation: active