Skill UI

This module provides comprehensive connection methods for Azure Database for PostgreSQL Flexible Server using Node.js and TypeScript with the pg package. It supports both traditional password authentication and modern, recommended Microsoft Entra ID (passwordless) authentication. The guide demonstrates best practices, including connection pooling, parameterized queries to prevent SQL injection, and robust transaction management (BEGIN/COMMIT/ROLLBACK).

Designs and executes chaos experiments, failure-injection frameworks, and game days for distributed systems, providing runbooks, manifests, rollback plans, and continuous resilience automation in CI/CD.

This skill functions as an expert in workflow automation, specializing in designing and implementing robust CI/CD pipelines and GitHub Actions workflows. It guides users through automating the entire development lifecycle—from building and testing to secure deployment. By establishing clear stages, handling secrets, and defining rollback strategies, it ensures consistency, reduces manual effort, and accelerates delivery while maintaining high quality and security standards.

Compares PostgreSQL or MySQL schemas using the database-diff-tool, produces transaction-safe migration scripts and rollback procedures, and outlines synchronization steps for staging/production deployments.

Master the advanced process of database schema and data migrations across major ORMs (Sequelize, TypeORM, Prisma). This skill provides best practices for handling complex transformations, including implementing zero-downtime deployments, renaming columns, changing data types, and executing complex data restructuring. It emphasizes robust rollback strategies to ensure data integrity during critical database updates.

A comprehensive guide covering best practices for database migrations. It addresses schema changes, data migrations, and rollbacks for major databases (PostgreSQL, MySQL) and modern ORMs (Prisma, Drizzle, etc.). Learn how to implement safe, reversible, and zero-downtime schema updates for production environments.

Specializes in generating production-grade SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, and SQL Server. Provides comprehensive plans covering data integrity, detailed rollback procedures, performance optimization, and validation checks for critical schema changes.

A comprehensive guide to deployment patterns and strategies for modern cloud environments. Covers techniques like Blue/Green, Canary, and Rolling Deployments, ensuring zero-downtime upgrades when deploying to Kubernetes, Docker, or various cloud providers. Includes best practices for health checks, logging, and rollback planning.

This skill acts as a specialized expert for transitioning codebases across various frameworks, languages, versions, and platforms. It generates detailed migration plans, automated migration scripts, comprehensive risk assessments, and rollback strategies. Use it when upgrading technology stacks or moving code between disparate systems to ensure minimal disruption and maintain core functionality.

This skill acts as an expert dependency manager, specializing in planning and executing safe, incremental upgrades for project dependencies. It provides comprehensive risk assessment, compatibility analysis, step-by-step migration guides, and robust testing/rollback plans to ensure system stability during major framework updates.

A comprehensive checklist and guide for deploying and maintaining Ideogram image generation services in a live production environment. It covers essential steps including API key management, request handling best practices, ensuring image persistence in durable storage, comprehensive error handling (401, 422, 429), and defining robust rollback procedures.

This comprehensive guide assists developers in planning and executing upgrades for systems utilizing the Juicebox API. It covers critical steps such as API version detection, migrating complex data schemas (e.g., search results), updating query syntax, and implementing robust rollback strategies. Essential for maintaining continuous operation in recruiting and market research applications when the underlying API changes.