Interact with Azure Data Lake Storage Gen2 using Python for hierarchical file systems, big data analytics, and file/directory operations.
database-migrations-sql-migrations
This skill provides expert-level guidance and tooling for SQL database migrations, focusing on zero-downtime deployments and maintaining data integrity. It's designed for PostgreSQL, MySQL, and SQL Server environments, offering comprehensive migration scripts with rollback procedures, validation checks, and performance optimization.
The skill leverages best practices for handling edge cases, large datasets, and concurrent operations. It provides actionable steps and verification methods to ensure production-ready strategies. Detailed examples and implementation playbooks are available for reference.
The output includes migration analysis reports, implementation plans, version-controlled SQL scripts, validation suites, rollback procedures, performance optimizations, and monitoring integration, all geared towards enterprise-grade safety and reliability.
What It Does
Provides SQL database migration strategies and implementation, focusing on zero-downtime deployments, data integrity, and rollback procedures for PostgreSQL, MySQL, and SQL Server.
When To Use
When working on SQL database migration tasks requiring zero-downtime, data integrity, or rollback capabilities for PostgreSQL, MySQL, or SQL Server.
Installation
Copy SKILL.md to your skills directoryWhat people say, and where to get help
No ratings yet. If you have used this skill, yours would be the first.
Sign in to leave a rating
An account keeps your review with your name on it, and lets you edit it later. Sign in or create one free.
No reviews yet
This skill has not been rated. If you have run it, a short note about what you used it for helps the next person more than any description can.
Related Skills You May Like
Discover more AI agent skills in the same category to enhance your workflow automation.
Master C#/.NET backend patterns for robust APIs, MCP servers, and enterprise applications using modern best practices.
Integrate with Notion's API to manage pages, databases, and blocks programmatically.
Expert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integration.
Design microservices architectures with service boundaries, event-driven communication, and resilience patterns. Use when building distributed systems, decomposing monoliths, or implementing microservices.
Implement Command Query Responsibility Segregation for scalable architectures. Use when separating read and write models, optimizing query performance, or building event-sourced systems.
Have a Skill to Share?
Join the community and help AI agents learn new capabilities. Submit your skill and reach thousands of developers.