db_design

Produces implementation-ready brownfield database design packages from approved requirements and current-state evidence.

4|Updated Jan 31, 2026
One-click install
npx skills add https://github.com/synthaicode/XRefKit --skill db-design-synthaicode
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db_design
Source: https://github.com/synthaicode/XRefKit/tree/main/skills/db_design
Command: npx skills add https://github.com/synthaicode/XRefKit --skill db-design-synthaicode

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Brownfield database changes often fail because design decisions are made from incomplete DDL, ORM guesses, or invented naming conventions. This Skill produces an implementation-ready database design package where every table, column, stored procedure, migration, and naming decision traces back to current-state evidence or is explicitly marked unknown. ## Core Features & Use Cases - Evidence-Based Design: Builds logical and physical model changes strictly from current database state analysis and registered source-structure findings, with XDDP traceability rows linking requirement differences to each design item. - Naming and Convention Discipline: Derives table, column, stored procedure, and migration names from existing DB naming rules, table-definition local rules, and stored procedure analysis instead of preference. - Migration and Risk Planning: Produces migration, backfill, data correction, rollback, transaction, concurrency, and validation plans with explicit unknowns and handoff owners. - Use Case: When a requirement change adds a new entity to an existing SQL Server-backed application, use this Skill to design the schema change, name objects per existing conventions, plan the migration and backfill, and hand off a reviewable package before any code is written. ## Quick Start Ask the AI to design the database changes for an approved requirement using the registered current database state analysis and source-structure findings for the affected targets.

Frequently Asked Questions about db_design

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

FAQPage Schema
How do I design a database schema change for an existing brownfield system?▼

Start from the current database state analysis and registered source-structure findings for each target, then draft logical and physical model changes with traceability to requirement differences. Every naming, type, and migration decision must cite existing evidence or be marked unknown.

What inputs are required before starting database design work?▼

You need approved requirements, a work plan, source modification and data change policies, current source-structure finding XIDs, and a current database state analysis with DB-unit SQL export basis for each target. Missing or stale analyses must be refreshed first.

Does this Skill write migrations or modify application code?▼

No. It only produces the design package, including migration and data correction plans. Implementing migrations, editing code, or deciding missing business requirements are explicitly out of scope and handed off to implementation flows.

How are table and stored procedure names chosen during design?▼

Names are derived from DB naming rule analysis and stored procedure naming rules captured in the current-state analysis, cross-checked with source-structure naming evidence for external boundaries. Each candidate records its evidence basis and a confidence level of strong, mixed, weak, or unknown.

What happens when current-state evidence is missing for a design decision?▼

The affected design item is marked unknown with the reason, missing evidence, affected area, downstream impact, and handoff owner. Closure is blocked if required current-state, source-structure, or constraint-derivation evidence is missing for implementation-facing design.