skills.rest
iots1
iots1COMMUNITY
Explore all skills by this author →
WebsiteGitHub

add-entity-or-column

Guide schema modifications and entity additions in the HIS Analyzer project.

2|Updated Nov 22, 2025
Search Tags:#API#database#schema#migration#model#code
One-click install
npx skills add https://github.com/iots1/migration-toolkit --skill add-entity-or-column
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: add-entity-or-column
Source: https://github.com/iots1/migration-toolkit/tree/main/.claude/skills/add-entity-or-column
Command: npx skills add https://github.com/iots1/migration-toolkit --skill add-entity-or-column

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides step-by-step instructions for adding new database columns or entities within the HIS Analyzer project, streamlining schema evolution tasks.

Core Features & Use Cases

  • Schema Modification: Assists in adding columns to existing tables, ensuring consistency from model updates to DDL and API schemas.
  • New Entity Creation: Guides through creating new tables, repository functions, API schemas, and integration steps for new data entities.
  • Use Case: When expanding the system to track new audit events, this Skill directs the developer through all necessary changes from data models to migration scripts.

Quick Start

Invoke this Skill with the table name and column name to get tailored checklist steps for schema modifications or with new entity details for a fresh addition.

Frequently Asked Questions about add-entity-or-column

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

FAQPage Schema
How do I add a new database column to an existing table schema?▼

Schema modification requires updating data models, database DDL, and API schemas together to ensure consistency. This approach handles minor column updates by providing structured steps that maintain robust data management workflows across the entire project.

What is the process for new entity creation in a database?▼

New entity creation involves setting up database tables, repository functions, API schemas, and integration steps. This broad implementation ensures the new data entity is fully connected within the system architecture and deployment scripts are properly updated.

How do I ensure API schemas match database migrations?▼

Ensuring API schemas match database migrations requires applying structured step-by-step instructions for schema updates. This guarantees that data models, database DDL, and API schemas are consistently updated during schema evolution tasks.

What steps are needed to update deployment scripts for new data models?▼

Updating deployment scripts requires modifying migration scripts alongside the new schema additions. This ensures the deployment process accurately reflects the structural changes made to the database and API layers during entity or column additions.

Can I use a checklist to track schema modifications and entity additions?▼

Yes, using a tailored checklist to track schema modifications and entity additions provides structured steps for consistency. Invoking the process with the table and column name yields steps covering everything from model updates to migration scripts.

Related Skills

Explore More Software Engineering Skills→
EIS-ITSEIS-ITS

Backend Migrations

Automate reversible database schema migrations with rollback methods and version control.

Official
Intermediate
DengNaichenDengNaichen
34

axiom-audit-database-schema

Analyzes SQLite and GRDB schemas and migration scripts for integrity risks.

Community
Advanced
faizanarshadfaizanarshad

rubberduck-schema-code-api-drift-pro

Detect discrepancies across database schemas, code types, and API contracts.

Community
Advanced
yashvinthanyashvinthan

Backend Migration Standards

Enforce reversible, atomic database migration scripts with zero-downtime deployment strategies.

Community
Advanced