DaoFlow-dev/server-schema-change
.agents/skills/server-schema-change/SKILL.md
Use when changing DaoFlow server schema or persistence flows, including Drizzle schema files, migrations, seed ordering, and database safety rules.
$ install --global
skillsauthnpx skillsauth add DaoFlow-dev/DaoFlow server-schema-changeInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 15, 2026, 9:00 PM33.9s2 files scanned
SKILL.md
- name:
- server-schema-change
- description:
- Use when changing DaoFlow server schema or persistence flows, including Drizzle schema files, migrations, seed ordering, and database safety rules.
Server Schema Change
Use this skill for DaoFlow server schema, migration, and seed work.
Load First
- Repository root AGENTS.md
- packages/server/AGENTS.md
- validation-gates before commit or push
Contract
- Tables live in
packages/server/src/db/schema/, grouped by concern. - All IDs must stay within the
varchar(32)limit. - Never modify a committed migration in place.
- Seed ordering and idempotency rules from
packages/server/AGENTS.mdremain mandatory. - Preserve agent safety, auditability, and approval boundaries when schema changes affect execution flows.
Required Flow
- Change the relevant schema or persistence modules.
- Generate or add the required migration instead of editing an existing committed migration.
- Update services, seeds, and contracts affected by the schema change.
- Run the relevant database checks such as
bun run db:migrate,bun run db:generate, or issue-specific recovery commands when the change requires them. - Run changed-surface tests plus validation-gates.
Guardrails
- Prefer Drizzle query builder over raw SQL unless a raw query is clearly justified.
- Keep schema files grouped by concern and split large persistence modules before they become mixed-purpose.
- Verify foreign-key ordering and idempotency whenever seed data changes.
Related Skills
DaoFlow-dev/daoflow-github-loop
development
VerifiedTrustedCommunity
Use when working DaoFlow GitHub issues end-to-end with Codex; this compatibility entrypoint loads the repo-local GitHub, validation, and review skills.
10SKILL.mdUpdated Apr 15, 2026
DaoFlow-dev/validation-gates
development
VerifiedTrustedCommunity
Use when validating DaoFlow changes before commit or push, including format, tests, lint, typecheck, conditional instruction checks, and CI follow-through.
10SKILL.mdUpdated Apr 15, 2026
DaoFlow-dev/github-issue-loop
testing
VerifiedTrustedCommunity
Use when executing DaoFlow GitHub issue or PR work with gh, including issue intake, durable progress comments, status labels, PR updates, and CI follow-through.
10SKILL.mdUpdated Apr 15, 2026
DaoFlow-dev/cli-contract-change
tools
VerifiedTrustedCommunity
Use when changing DaoFlow CLI commands or agent-facing CLI behavior, including contract updates, JSON output, scope enforcement, mutation flags, and authz updates.
10SKILL.mdUpdated Apr 15, 2026