Skill UI

Automates the generation of robust, DB-agnostic integration test cases for data access layers (DAL) during major database migrations, specifically from Oracle to PostgreSQL. These tests validate behavioral consistency across both source and target database systems, ensuring that core business logic remains intact after the migration process. Essential for maintaining data integrity and application stability.

Generates migration instructions for GitHub Copilot by comparing two project states, enabling consistent transformations during migrations, refactors, or technology upgrades and documenting rules, validation, and monitoring steps.

Converts Oracle PL/SQL stored procedures and functions into PostgreSQL PL/pgSQL equivalents by translating Oracle-specific syntax, keeping control flow and signatures intact, honoring type-anchored parameters, and applying COLLATE "C" or orafce helpers when needed during database migrations.

Creates an integration testing plan for .NET Oracle-to-PostgreSQL migrations by analyzing a project for data access artifacts, ranking them by migration risk, and outlining test cases, seed data, and Oracle-specific behaviors to validate.

Guides React 19 test migrations by outlining act import changes, Simulate-to-fireEvent replacements, full react-dom/test-utils cleanup, and StrictMode call-count verification strategies.

Generates a complete, compilable xUnit integration test project structure for validating complex database migrations, specifically from Oracle to PostgreSQL, within .NET solutions. This scaffolding includes a transaction-rollback base class and a seed data manager, ensuring a robust environment for writing migration integration tests without requiring test cases. Ideal for setting up testing infrastructure before migration validation.

A comprehensive utility designed for managing CoreWeave cloud infrastructure migrations. It facilitates upgrading between GPU generations (e.g., A100 to H100), updating CUDA versions, and handling Kubernetes resource changes. The tool uses K8s APIs to audit deployments, detect deprecated instances, and execute controlled rollbacks.

A comprehensive guide for Amazon Aurora DSQL, a serverless, PostgreSQL-compatible distributed SQL database. This skill covers the entire database lifecycle, including schema management, direct query execution, complex data migrations (e.g., MySQL to DSQL), and advanced performance tuning via query plan analysis (EXPLAIN ANALYZE). Essential for secure, multi-tenant application development.

This guide manages critical migrations for the Figma REST API, addressing scope deprecations (e.g., migrating 'files:read' to granular scopes) and upgrading from Webhooks V1 to V2. It is essential for developers updating existing integrations to ensure compatibility with the latest API standards and security features.

A comprehensive technical guide for executing major data migrations and re-platforming to Intercom. It covers bulk contact imports, syncing conversation histories, migrating company data, and transferring help center articles from source systems like Zendesk or Freshdesk.

Provides a comprehensive guide for managing Amazon Aurora DSQL, a serverless, PostgreSQL-compatible distributed SQL database. It covers direct query execution, robust schema management, safe schema evolution, multi-tenant isolation patterns, and IAM authentication. Use cases include database development, complex migrations (e.g., MySQL to DSQL), and optimizing query performance using detailed plan explainability tools.

Provides comprehensive methods for executing ClickHouse schema migrations, including column changes, engine migrations, and complex modifications like changing ORDER BY. It teaches best practices for zero-downtime schema updates and implements a versioned migration runner pattern for robust data evolution.