CommunityProduktivität & Zusammenarbeitgithub.com

wshobson/database-migration

Führen Sie Datenbankmigrationen über verschiedene ORMs und Plattformen hinweg durch, mit Strategien für Ausfallfreiheit, Datentransformation und Rollback-Verfahren.

Was ist database-migration?

Dieses Skill unterstützt Entwickler und KI-Agenten bei der Durchführung von Datenbankmigrationen über verschiedene ORMs (Object-Relational Mapper) und Plattformen hinweg. Es bietet umfassende Strategien für ausfallfreie Migrationen mit Hilfe von Blue-Green-Deployments, Feature Flags und starken Datenvalidierungen. Der Skill umfasst auch Werkzeuge zur Datentransformation, wie die Umwandlung von Spaltentypen oder die Aufteilung von Tabellen, sowie klare Rollback-Verfahren, um Änderungen bei Bedarf rückgängig zu machen. Geeignet für den Einsatz in Kombination mit KI-Agenten wie Claude Code, Cursor oder Codex, die in der Webentwicklung und DevOps tätig sind.

Funktioniert mit~Claude Code~Codex CLI~Cursor
Part ofAgent Workflows
npx skills add https://github.com/wshobson/agents/tree/main/skills/database-migration

Installed? Explore more Produktivität & Zusammenarbeit skills: steipete/gemini, steipete/gh-issues, steipete/skill-creator · View all 6 →

Original anzeigen→Alle Skills durchsuchen

In Ihrer bevorzugten KI fragen

Öffnet einen neuen Chat, in dem dieser Agent-Skill bereits geladen ist.

OpenAIChatGPTClaudeClaudeGeminiGeminiGrokGrokPerplexityPerplexityDeepSeekDeepSeek

Dokumentation

Was macht database-migration?

Führen Sie Datenbankmigrationen über verschiedene ORMs und Plattformen hinweg mit Strategien für Ausfallfreiheit, Datentransformation und Rollback-Verfahren durch. Verwenden Sie dieses Skill bei der Migration von Datenbanken, Schemaänderungen, Datentransformationen oder der Implementierung von ausfallfreien Bereitstellungsstrategien.

Übersicht

Dieses Skill bietet eine vollständige Toolbox für Datenbankmigrationen, die von einfachen Schemaänderungen bis hin zu komplexen, ausfallfreien Datenbanküberholungen reicht. Es abstrahiert plattformspezifische Details und ermöglicht es Ihnen, sich auf die Geschäftslogik Ihrer Migrationen zu konzentrieren.

Funktionen

  • Ausfallfreie Migrationen: Führen Sie Schemaänderungen durch, ohne Ihre Anwendung offline zu nehmen. Nutzen Sie Blue-Green-Deployment-Strategien, Feature Flags und Versionierung.
  • Datentransformation: Transformieren Sie Daten während der Migration, z. B. Spaltentypen ändern, Tabellen aufteilen oder Daten zwischen Systemen migrieren.
  • Rollback-Verfahren: Definieren Sie klare Rollback-Schritte für jede Migration, damit Sie Änderungen bei Bedarf rückgängig machen können.
  • Plattformunterstützung: Funktioniert mit den gängigsten ORMs (Prisma, TypeORM, Sequelize, Django ORM, SQLAlchemy) und Datenbanken (PostgreSQL, MySQL, SQLite, MSSQL, MongoDB).

Verwendung

Grundlegende Migration

# Migration initialisieren
database-migration init --name "add-user-email"

# Migration ausführen
database-migration up --target "production"

# Migration rückgängig machen
database-migration down --target "production"

Ausfallfreie Migration

# zero-downtime.yaml
migration:
  strategy: blue-green
  steps:
    - add_column:
        table: users
        column: email
        type: varchar(255)
        nullable: true
    - backfill_data:
        query: "UPDATE users SET email = CONCAT(id, '@temp.com')"
    - add_not_null:
        table: users
        column: email

API-Referenz

BefehlBeschreibung
initInitialisiert eine neue Migration
upFührt Migrationen durch
downMacht Migrationen rückgängig
statusZeigt den Migrationsstatus an
validateValidiert Migrationsschema

Kompatible KI-Tools

  • Claude Code
  • Cursor
  • Codex CLI
  • Continue Dev
  • GitHub Copilot

Lizenz

MIT

Individual skills in this repo

This repo contains 20 individual skills — each has its own dedicated page.

wshobson/accessibility-compliance

Implement WCAG 2.2 compliant interfaces with mobile accessibility, inclusive design patterns, and assistive technology support. Use when auditing accessibility, implementing ARIA patterns, building for screen readers, or ensuring inclusive user experiences.

wshobson/airflow-dag-patterns

Build production Apache Airflow DAGs with best practices for operators, sensors, testing, and deployment. Use when creating data pipelines, orchestrating workflows, or scheduling batch jobs.

wshobson/angular-migration

Migrate from AngularJS to Angular using hybrid mode, incremental component rewriting, and dependency injection updates. Use when upgrading AngularJS applications, planning framework migrations, or modernizing legacy Angular code.

wshobson/anti-reversing-techniques

Understand anti-reversing, obfuscation, and protection techniques encountered during software analysis. Use this skill when analyzing malware evasion techniques, when implementing anti-debugging protections for CTF challenges, when reverse engineering packed binaries, or when building security research tools that need to detect virtualized environments.

wshobson/api-design-principles

Master REST and GraphQL API design principles to build intuitive, scalable, and maintainable APIs that delight developers. Use when designing new APIs, reviewing API specifications, or establishing API design standards.

wshobson/architecture-decision-records

Write and maintain Architecture Decision Records (ADRs) following best practices for technical decision documentation. Use when documenting significant technical decisions, reviewing past architectural choices, or establishing decision processes.

wshobson/architecture-patterns

Implement proven backend architecture patterns including Clean Architecture, Hexagonal Architecture, and Domain-Driven Design. Use this skill when designing clean architecture for a new microservice, when refactoring a monolith to use bounded contexts, when implementing hexagonal or onion architecture patterns, or when debugging dependency cycles between application layers.

wshobson/async-python-patterns

Master Python asyncio, concurrent programming, and async/await patterns for high-performance applications. Use when building async APIs, concurrent systems, or I/O-bound applications requiring non-blocking operations.

wshobson/attack-tree-construction

Build comprehensive attack trees to visualize threat paths. Use when mapping attack scenarios, identifying defense gaps, or communicating security risks to stakeholders.

wshobson/auth-implementation-patterns

Master authentication and authorization patterns including JWT, OAuth2, session management, and RBAC to build secure, scalable access control systems. Use when implementing auth systems, securing APIs, or debugging security issues.

wshobson/avoid-ai-writing

Audit and rewrite prose so it stops reading as machine-generated. Use this skill when asked to remove AI-isms, clean up AI writing, edit a draft for AI tells, audit a README, changelog, release note, PR description, or blog post for machine-sounding prose, or make text sound less like AI. Supports a detect-only mode, a rewrite mode, and an edit-in-place mode, with optional voice and context profiles.

wshobson/backtesting-frameworks

Build robust backtesting systems for trading strategies with proper handling of look-ahead bias, survivorship bias, and transaction costs. Use when developing trading algorithms, validating strategies, or building backtesting infrastructure.

wshobson/bash-defensive-patterns

Master defensive Bash programming techniques for production-grade scripts. Use when writing robust shell scripts, CI/CD pipelines, or system utilities requiring fault tolerance and safety.

wshobson/bats-testing-patterns

Master Bash Automated Testing System (Bats) for comprehensive shell script testing. Use when writing tests for shell scripts, CI/CD pipelines, or requiring test-driven development of shell utilities.

wshobson/bazel-build-optimization

Optimize Bazel builds for large-scale monorepos. Use when configuring Bazel, implementing remote execution, or optimizing build performance for enterprise codebases.

wshobson/before-you-build

Pre-build product and feature risk review for founders, product managers, and AI-assisted builders. Use this skill when the user is about to build a landing page, MVP, SaaS product, internal tool, agent workflow, or major feature and needs to check demand, positioning, monetization, retention, trust, distribution, and adoption risk before implementation starts.

wshobson/billing-automation

Build automated billing systems for recurring payments, invoicing, subscription lifecycle, and dunning management. Use when implementing subscription billing, automating invoicing, or managing recurring payment systems.

wshobson/binary-analysis-patterns

Master binary analysis patterns including disassembly, decompilation, control flow analysis, and code pattern recognition. Use when analyzing executables, understanding compiled code, or performing static analysis on binaries.

wshobson/block-no-verify-hook

Configure a PreToolUse hook to prevent AI agents from skipping git pre-commit hooks with --no-verify and other bypass flags. Use when setting up Claude Code projects that enforce commit quality gates.

wshobson/brand-landingpage

Brand-first landing page designer — runs a brand-identity interview (colors, typography, shape language), then generates and iterates on a polished landing page via Stitch with deployment-ready HTML. Use when the user asks to create, design, or build a landing page, homepage, or marketing page and has no established visual direction. Skip when they have a design mockup, need a dashboard or app UI, are working at component level, building a multi-page app, or restyling with known design tokens — use frontend-design instead.

Verwandte Skills

steipete/gemini

Gemini CLI one-shot prompts, summaries, generation, skills, hooks, MCP, or Gemma routing.

community

steipete/gh-issues

Fetch GitHub issues, select candidates, spawn background fix agents, open PRs, and optionally process PR review comments.

community

steipete/skill-creator

Create, edit, audit, tidy, validate, or restructure AgentSkills and SKILL.md files.

community

steipete/clawhub

Search, install, update, sync, or publish agent skills with the ClawHub CLI and registry.

community

steipete/coding-agent

Delegate coding work to Codex, Claude Code, or OpenCode as background workers; not simple edits or read-only code lookup.

community

steipete/mcporter

List, configure, authenticate, call, and inspect MCP servers/tools with mcporter over HTTP or stdio.

community
← More Produktivität & Zusammenarbeit skills