approve-database

Lock and validate Database Diagram transitioning from draft to approved state.

Updated Apr 26, 2026
One-click install
npx skills add https://github.com/aoecosystem/project-foundations --skill approve-database
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: approve-database
Source: https://github.com/aoecosystem/project-foundations/tree/main/.cursor/skills/approve-database
Command: npx skills add https://github.com/aoecosystem/project-foundations --skill approve-database

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Lock and validate the Database Diagram as part of the approval workflow, transitioning from DATABASE_DRAFT to DATABASE_APPROVED.

Core Features & Use Cases

  • Verifies Mermaid erDiagram compiles to ensure diagram integrity.
  • Checks that every relationship in SoW Section 3 has a matching entity in Section 2.
  • Updates session-memory/SESSION-STATE.md and appends an audit log upon approval.
  • Enforces stage-gate to prevent progression until all quality checks pass.

Quick Start

Review the draft and run /approve-database to lock the diagram and advance the workflow.

Frequently Asked Questions about approve-database

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

FAQPage Schema
How do I validate a Mermaid erDiagram before final approval?

Validating a Mermaid erDiagram before final approval requires checking diagram integrity and confirming every SoW relationship matches a defined entity. The approval workflow enforces these stage-gate quality checks to prevent progression from draft to approved.

What is the best way to lock a database diagram and update the audit log?

Locking a database diagram and updating the audit log occurs by finalizing the DATABASE_DRAFT stage. This transitions the session state to DATABASE_APPROVED while appending a secure audit log entry recording the diagram validation.

Why does my database diagram workflow stage fail to progress to approved?

Your database diagram workflow fails to progress to approved when quality gate conditions are unmet. The stage-gate enforces relationship coverage and Mermaid erDiagram compilation, prompting resolution of any integrity errors before retrying.

How do I check if SoW relationships have matching entities in my database diagram?

Checking SoW relationships against database diagram entities is handled automatically during the approval workflow. The validation process cross-references Section 3 relationships against Section 2 entities to ensure complete coverage before locking.

Does the database approval workflow update session memory state automatically?

The database approval workflow updates session memory state automatically upon successful validation. It modifies SESSION-STATE.md to reflect the transition from DATABASE_DRAFT to DATABASE_APPROVED and appends a corresponding audit log.

When do I need to enforce a stage-gate in a database diagram workflow?

Enforcing a stage-gate in a database diagram workflow is needed when finalizing the DATABASE_DRAFT stage. It ensures diagram integrity, validates relationship coverage, and prevents progression until all quality gate conditions successfully pass.