ntaksh42/agents
Overview
This skill generates database migration scripts with built-in rollback support for a range of relational databases and common ORMs. It produces up/down SQL files and can scaffold migration classes for TypeORM-style projects. The output focuses on schema changes: create/drop tables, add/remove columns, indexes, and foreign keys, with clear rollback steps.
How this skill works
Provide the desired schema change or current/target models and the skill outputs paired migration artifacts: an "up" migration to apply changes and a "down" migration to revert them. It can emit raw SQL compatible with common dialects and scaffold migration code for TypeORM (TypeScript). Each migration includes explicit operations for schema, indexes, constraints, and timestamps to ensure safe rollbacks.
When to use it
- When adding, removing, or renaming tables and columns in a production schema
- When creating repeatable, auditable migration files for deployment pipelines
- When you need both SQL migrations and ORM-compatible migration classes (e.g., TypeORM)
- When introducing indexes or foreign-key constraints with reversible changes
- When preparing rollback plans for schema changes before applying to production
Best practices
- Review generated down migrations to ensure destructive rollbacks handle data carefully
- Run migrations in a staging environment matching production to verify behavior
- Keep migrations small and focused: one logical change per migration file
- Include explicit index and constraint creation/removal to avoid implicit behavior
- Version and name migration files clearly (timestamp or incremental) for ordering
Example use cases
- Generate an initial users table with email uniqueness, timestamps, and an index
- Add a nullable profile_id column and corresponding foreign key with rollback
- Create and later drop a performance index during optimization work
- Scaffold TypeORM MigrationInterface classes for a TypeScript service
- Produce paired up/down SQL files to include in CI/CD deployment artifacts
FAQ
The skill targets common relational dialects (PostgreSQL, MySQL, SQLite) and produces standard SQL and ORM scaffolding; dialect-specific adjustments may be needed for proprietary features.
Does the skill handle data migrations (transformations) as well as schema?
It primarily focuses on schema operations and reversible structural changes. Simple data transformations can be included, but complex ETL-like operations should be reviewed and tested carefully.
23 skills
This skill generates database migration scripts with up and down migrations, covering table creation, alterations, indexes, and foreign keys across databases.
This skill helps you manage Azure DevOps tasks, pipelines, repos, and artifacts efficiently using the az devops CLI across projects.
This skill converts data between JSON, YAML, XML, CSV, TOML and more, with validation, formatting, and simple transformations to ease data migration.
This skill creates structured Marp proposal and comparison slides, clarifying issues, evaluating multiple options, and organizing merits and risks for informed
This skill helps you generate and manage Azure DevOps Wiki pages with markdown content, including automatic TOCs and embedded diagrams for clear project
This skill generates production-ready MCP servers in Python or TypeScript with Tools, Resources, and Prompts following best practices.
This skill generates comprehensive unit, integration, and end-to-end tests from code, including edge cases and mocks to support TDD.
This skill generates GraphQL schemas, resolvers, and type definitions from data models, enabling rapid API design and automatic documentation.
This skill generates and edits Word documents (.docx) with headers, footers, styles, tables, images, and Markdown conversion.
This skill generates structured meeting notes with decisions, action items, and summaries from transcripts, improving clarity and follow-up.
This skill helps you manage Azure Pipelines variable groups and Key Vault secrets for environment-specific configurations and seamless pipeline integration.
This skill automates iterative AI output improvement through feedback loops, scoring, prompt optimization, and convergence to the best result.
This skill generates professional HTML presentations using reveal.js from markdown content, with responsive design, code highlighting, and speaker notes.
This skill analyzes code performance to identify bottlenecks and suggest practical optimizations for algorithms, queries, and resource usage.
This skill evaluates AI generated content across readability, accuracy, relevance, originality, SEO, accessibility, engagement, and style to deliver actionable
This skill helps you manage Azure Artifacts feeds, publish packages, and control access across npm, NuGet, and universal packages.
This skill helps you design Azure release pipelines with blue-green and rolling strategies, including approvals and rollback across environments.
This skill helps you manage Azure DevOps infrastructure as code by generating Terraform configurations for projects, repos, pipelines, and variable groups.
This skill evaluates software architecture for SOLID principles, design patterns, and scalability, proposing actionable improvements for maintainability.
This skill generates OpenAPI/Swagger, Markdown, HTML, and Postman documentation from code for REST and GraphQL APIs, with code examples and authentication
This skill enables end-to-end internationalization for .NET and C++ apps, generating resources, managing translations, and enforcing localization best
This skill translates technical documents, code comments, and UI strings across languages while preserving code blocks and terminology to accelerate
This skill suggests refactoring opportunities to improve code structure, readability, and maintainability across methods, conditionals, and design patterns.
