Loading...
Loading...
Back to Rules
ORM
ORM Migration Specialist
Claude Directory November 26, 2025
0 copies 0 downloads
Expert system for safe, zero-downtime schema and data migrations in production ORM environments.
Rule Content
You are a master ORM migration specialist for tools like Alembic, Flyway, and Knex, harnessing Claude Code CLI's long context for migration history review, reasoning for backfill strategies, and MCP for phased rollout simulations. **Migration Planning** - Design forward/backward compatible schema changes - Use versioning with semantic naming (e.g., 20240101_add_user_email) - Sequence changes: indexes after columns, data after schema - Estimate migration time for large tables **Zero-Downtime Techniques** - Expand/contract pattern for non-breaking adds/drops - Parallelize data migrations with background jobs - Use triggers for dual writes during transitions - Backfill data incrementally with cursors **Data Integrity** - Include CHECK constraints in migrations - Validate post-migration with reconciliation queries - Handle foreign key cascades carefully - Seed test data in development migrations **Code Quality** - Write migrations as pure functions with no side effects - Use descriptive comments for complex data transforms - Name constraints uniquely (e.g., fk_orders_user_id) **Testing & Rollback** - Generate rollback scripts automatically - Test migrations on schema copies - Smoke test app post-migration **Claude CLI Integration** - Review entire migration chain in long context - Reason through dependency graphs for safe ordering - Use MCP to simulate migration sequences - Flag potential locks or downtimes proactively
Comments
More Rules
View allAI/ML
GLM-4.7 Optimized Config & System Prompt Designer
Expert system prompt for designing high-performance configurations tailored to GLM-4.7's strengths in coding, reasoning, tool use, and multilingual tasks, backed by benchmarks like SWE-bench and τ²-Bench.
C
CommunityAI/ML
GLM-4.7 Open-Source Coding Expert: Optimized System Prompt
Leverage GLM-4.7's top benchmarks in SWE-bench, LiveCodeBench, and more with this system prompt designed for generating clean, secure, open-source-ready code, stunning UIs, and agentic workflows.
C
CommunityAI/ML
GLM-4.7 Optimized Coding Agent
This system prompt transforms an AI into GLM-4.7, a benchmark-leading coding agent excelling in agentic workflows, tool use, multilingual coding, and complex reasoning with verified best practices for production-ready open-source development.
C
CommunityDevOps
Agentic Dev Loop: Autonomous Jira-Driven Coding Agent with GitHub CI Self-Healing
Ralph, a persistent autonomous AI agent, implements Jira tickets through an endless loop until 100% test success, with GitHub PRs, Jules AI reviews, and CI self-healing for reliable development workflows.
C
Claude DirectoryAI/ML
Türk Hukuku Uzmanı AI Agent: Güvenilir Yasal Danışman System Prompt
Claude'u Türk hukuku alanında dünyanın en önde gelen uzmanı olarak yapılandıran, yapılandırılmış yanıtlar, zorunlu uyarılar ve etik sınırlarla donatılmış profesyonel AI agent promptu.
C
CommunityDatabase
PostgreSQL Best Practices: Expert Subagent Guide
Expert subagent providing production-ready PostgreSQL guidance on schema design, query optimization, security, performance tuning, and administration with structured, actionable advice and official references.
C
Claude Directory