db-admin

Automate auditable Directus Postgres changes with snapshots, approvals, and diff verification.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/Coignite-ApS/businesslogic --skill db-admin
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db-admin
Source: https://github.com/Coignite-ApS/businesslogic/tree/main/.claude/skills/db-admin
Command: npx skills add https://github.com/Coignite-ApS/businesslogic --skill db-admin

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a safe, auditable workflow for Directus Postgres changes, ensuring snapshots, approvals, and diff verification before applying migrations.

Core Features & Use Cases

  • Multi-phase change workflow for schema, data migrations, and snapshot edits.
  • Enforces snapshot-before-change discipline and mandatory user consultation for structural changes.
  • Generates and validates pre/post task snapshots, diff reports, and migration scripts with down migrations.

Quick Start

Describe the desired Directus Postgres change and start the task with a concise description, and the agent will guide you through snapshots, research, and approvals.

Frequently Asked Questions about db-admin

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I safely apply Directus Postgres schema changes without breaking data?

Directus Postgres schema changes require a multi-phase workflow that enforces pre-task snapshots, paired migration scripts with down migrations, and explicit approval gates before applying any modifications. This ensures safe, auditable database updates with diff verification.

What is the best way to manage Directus database migrations and snapshot edits?

Managing Directus database migrations involves generating and validating pre/post task snapshots, creating diff reports, and pairing migration scripts with down migrations. The workflow mandates user consultation for structural changes and explicit acceptance before applying updates.

Do I need to create a database dump before running Directus Postgres data migrations?

Yes, pre-task database dumps are strictly required before running Directus Postgres data migrations. The mandated workflow enforces snapshot-before-change discipline to ensure you can verify diffs and safely rollback using paired down migrations if needed.

Can I automate Directus schema changes without manual approval gates?

No, Directus schema changes cannot bypass the mandatory consultation and approval gates. The workflow requires explicit user acceptance before applying any structural modifications to ensure safe, auditable database updates with proper diff verification.

How does diff verification work for Directus Postgres database changes?

Diff verification for Directus Postgres changes works by generating and validating pre-task and post-task snapshots, then comparing them to create detailed diff reports. This process ensures schema changes, data migrations, and snapshot edits are auditable and safe.

Why does my Directus database migration workflow require down migrations?

Directus database migrations require down migrations to provide safe rollback paths for schema changes and data migrations. This paired approach ensures auditable database updates by allowing you to reverse modifications if diff verification or post-task snapshots reveal issues.