digirati-co-uk/db-migrations
.agents/skills/db-migrations/SKILL.md
Work on Madoc TS database migrations and migration tooling. Use when adding SQL migrations, running Slonik migrator, or updating migration paths in services/madoc-ts.
$ install --global
skillsauthnpx skillsauth add digirati-co-uk/madoc-platform db-migrationsInstall 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 16, 2026, 3:52 PM5.4s2 files scanned
SKILL.md
- name:
- db-migrations
- description:
- Work on Madoc TS database migrations and migration tooling. Use when adding SQL migrations, running Slonik migrator, or updating migration paths in services/madoc-ts.
Database Migrations (Madoc TS)
Goal
Explain how migrations are organized and executed so new migration scripts are added safely and run correctly.
Scope
- Migration file layout and naming
- Slonik migrator setup and entrypoints
- Environment variables required for migrations
Non-scope
- Query implementation details
- Repository patterns
- Runtime DB pool configuration outside migration runs
Key Entry Points
services/madoc-ts/migrations/services/madoc-ts/src/migrate.tsservices/madoc-ts/migrate.cjs
Architecture Summary (Based on Source)
- Migrations live in
services/madoc-ts/migrationsand are executed via@slonik/migrator. src/migrate.tsusesROOT_PATH+/migrationsto locate migration files.migrate.cjsis a CommonJS entrypoint with the same migrations path.
Quick Start Workflow
- Review existing migration files in
services/madoc-ts/migrations/for naming and structure. - Confirm
DATABASE_*env vars are set for the migration run. - Use
services/madoc-ts/src/migrate.ts(ormigrate.cjs) to execute migrations.
Common Tasks
- Add a new SQL migration file
- Run migrations in a dev or deployment environment
- Fix migration order or dependencies
Pitfalls
- Incorrect migration filename format
- Running migrations without required environment variables
- Changing migration path without updating both TS and CJS entrypoints
Suggested Checks
- Run migrator on a clean database
- Verify new migration applies and is idempotent where expected
Tooling
scripts/list_migrations.py: list migration files in order.- Usage:
python scripts/list_migrations.py
- Usage:
Related Skills
digirati-co-uk/utility-core
tools
VerifiedTrustedCommunity
Work on Madoc TS shared utility helpers (JWT, metadata, errors, IIIF helpers, auth helpers). Use when changing core utility functions or shared helpers in services/madoc-ts.
56SKILL.mdUpdated Apr 16, 2026
digirati-co-uk/types-schemas
development
VerifiedTrustedCommunity
Work on Madoc TS shared type definitions and schema contracts. Use when updating TypeScript types, JSON schema shapes, or cross-layer data contracts in services/madoc-ts.
56SKILL.mdUpdated Apr 16, 2026
digirati-co-uk/tasks-automation
tools
VerifiedTrustedCommunity
Understand and extend Madoc TS task automation, including bots and task-related extensions. Use when adding task automation, bot behavior, or task metadata resolution in services/madoc-ts.
56SKILL.mdUpdated Apr 16, 2026
digirati-co-uk/ssr-site
development
VerifiedTrustedCommunity
Work on Madoc TS site SSR pipeline, HTML template injection, and site render data wiring. Use when changing site SSR behavior, template tokens, or site SSR data wiring in services/madoc-ts.
56SKILL.mdUpdated Apr 16, 2026