Skill UI

This skill generates a comprehensive, safe, and zero-downtime database migration plan for schema changes. It utilizes the industry-standard expand/contract pattern to ensure backward compatibility, detailing multiple phased steps (Expand, Backfill, Contract), necessary SQL scripts, robust rollback procedures, and detailed deployment runbooks. Essential for maintaining application availability during large-scale database updates.

This skill guides the decomposition of monolithic applications into independent microservices using Domain-Driven Design (DDD). It defines bounded contexts, service boundaries, communication patterns (sync/async), data ownership, and provides a structured migration roadmap (e.g., Strangler Fig Pattern). Essential for scaling and modernizing large enterprise systems.

This skill helps diagnose, repair, and prevent complex Drizzle Kit database migration conflicts. It addresses issues arising from merging branches, rebasing, or PR updates involving generated SQL, snapshots, and journals. Use it to ensure stable schema evolution in multi-developer teams and harden CI/CD workflows.

This skill provides comprehensive guidance on choosing and creating the appropriate Neon Postgres branch for development and testing workflows. Users must decide between a 'Normal' branch (for realistic migration testing with live data) or a 'Schema-Only' branch (for highly sensitive data environments). It details the decision rules, tool selection (CLI/MCP), and procedures for branch creation and resetting.

A comprehensive guide to safe and reversible database migration patterns. Covers zero-downtime schema changes, data backfilling, and rollbacks for major databases like PostgreSQL and MySQL, and popular ORMs (Prisma, Drizzle, Django). Learn techniques like concurrent indexing and the expand-contract pattern to ensure production stability.

A comprehensive, multi-phase checklist for ensuring the quality, security, and deployment readiness of Django applications. It covers linting (ruff, mypy), unit testing (pytest), database migrations, security audits (bandit, pip-audit), and performance checks, making it an essential quality gate for CI/CD pipelines before merging or deploying to production.

This skill helps transform vague product or engineering ideas into structured, verifiable acceptance criteria (AC). It is crucial for high-impact changes involving security, data migration, or external APIs. By inspecting existing context and asking minimal, targeted questions, it produces clear, observable criteria, significantly de-risking the development process and ensuring handoff readiness.

A comprehensive guide to building robust database layers in Kotlin using the Exposed ORM framework. It covers advanced patterns including DSL queries, DAO entity management, transaction handling, connection pooling with HikariCP, schema migration via Flyway, and implementing the Repository pattern for clean, production-grade data access.

This tool automates the creation of new, sequentially numbered database migration scripts. It generates paired 'up' and 'down' SQL files for managing schema changes, such as creating tables, adding/modifying columns, or creating indexes. It ensures idempotency and maintains a consistent migration history.

This tool validates all pending database migrations to ensure correctness, safety, and adherence to best practices. Use it before applying migrations to catch critical issues like broken foreign key references, incomplete rollback logic, unintended destructive operations (e.g., DROP TABLE), and naming convention violations. It checks for rollback completeness, schema integrity, and idempotency.

This skill provides a comprehensive framework for assessing whether a research project meets the academic scope of general population science. It guides users to shift focus from mere data usage to advancing core demographic questions concerning fertility, mortality, migration, and population change, helping to frame the contribution for maximum impact.

Streamlines the complex process of documenting software releases. This tool scans Git history, categorizes changes (features, fixes, performance), and generates multiple outputs—including a structured CHANGELOG, PR body, and user-friendly communication announcements—while also detecting necessary database migrations. Ideal for professional software teams preparing for production deployments.