Database Schema and Migration Planner
Design relational database schemas and safe migration plans with constraints, indexes, data backfills, rollback, and verification.
Database Schema and Migration Planner is a free AI skill for data workflows. Design relational database schemas and safe migration plans with constraints, indexes, data backfills, rollback, and verification. It works with Claude, ChatGPT, Cursor and is ready to use out of the box.
About this skill
Database Schema and Migration Planner converts application requirements or a legacy schema into a structured relational data model and migration strategy. It defines entities, relationships, keys, constraints, indexes, lifecycle rules, naming conventions, migration phases, data backfills, compatibility, rollback, and verification.
What it does
The skill analyzes domain objects, access patterns, transaction boundaries, data volume, retention, and consistency needs; proposes normalized tables and relationships; identifies indexing and integrity requirements; evaluates migration risks; and produces phased SQL-oriented migration tasks with validation and rollback criteria.
What is included
- Entity and relationship model
- Table and column definitions
- Keys and constraints
- Index strategy
- Data lifecycle rules
- Migration sequence
- Backfill and compatibility plan
- Rollback and verification checklist
How to use it
1. Download the database-schema-and-migration-planner-SKILL.md file 2. Upload it to your development workspace 3. Provide the domain requirements, existing schema, and access patterns 4. Add database engine, scale, and deployment constraints 5. Use the plan to implement and review schema changes safely
Examples
Design a PostgreSQL schema and migration plan for adding teams, invitations, role-based membership, and project ownership to an existing single-user SaaS application.
A relational schema with teams, memberships, invitations, roles, projects, constraints, indexes, ownership rules, migration phases, backfills, compatibility steps, rollback conditions, and validation queries.
FAQ
What is this skill for?
Can it work with an existing database?
Does it write migration SQL?
How does it handle large tables?
Can it design multi-tenant schemas?
How is this different from drawing an ER diagram?
Related Skills
Database Query Optimization Analyst
Analyze slow database queries and create evidence-based optimization plans using execution plans, indexes, schema, and workload context.
Data Migration Verification Manager
Plan and verify data migrations with mapping, reconciliation, sampling, cutover, rollback, audit evidence, and sign-off.
Data Analysis Workflow Planner
Design a reliable data-analysis workflow from raw files to validated insights, including cleaning, checks, methods, outputs, and reproducibility.
Related Prompts
Database Query Performance Investigator
Analyze a slow database query using execution evidence, data distribution, indexes, and workload constraints before recommending changes.
Database Migration Change Planner
Plan a schema or data change for an AI-built app with compatibility, backfill, validation, rollback, and deployment sequencing.
Form-to-Database Validation Workflow
Design a safe form-ingestion workflow that validates, normalizes, deduplicates, and stores submitted data with review queues and privacy controls.