Skill UI

This guide outlines the process and mandatory structure for documenting defects found during an Oracle-to-PostgreSQL migration. It details how to write actionable bug reports, covering required elements like Severity, Root Cause, Scenario, and Solution. It emphasizes treating Oracle as the source of truth and handling data layer nuances (e.g., NULL vs. empty string) to ensure accurate defect tracking and remediation.

Bulk migrate repo labels and Project V2 metadata into GitHub org issue fields, converting label-based tags into typed fields, optionally removing old labels, and syncing project field values for cleaner structured issue tracking.

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 preserving React 18 concurrent patterns during migration to React 19 while outlining post-migration adoption of new APIs like use(), Actions, useOptimistic, and Suspense data fetching so concurrent behavior stays intact.

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.

Provides comprehensive guidance on upgrading your Qdrant vector database version while ensuring data integrity and maintaining application availability. It covers compatibility rules for major/minor versions, recommends step-by-step migration plans, and details how to perform zero-downtime rolling upgrades using replication factors.

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.

A comprehensive guide for developers migrating between different versions of the Flexport API, specifically detailing changes from v1 to v2. It covers breaking changes in request headers, response parsing (e.g., _object to data), pagination formats, and error structures, ensuring smooth integration updates.

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 comprehensive guidance and code patterns for upgrading and migrating integrations with the Linktree API. It addresses breaking changes related to link types, analytics schema updates, and profile customization fields, ensuring reliable data synchronization and link management across evolving versions.

A comprehensive guide detailing procedures for upgrading Abridge API versions and migrating between disparate Electronic Health Record (EHR) systems. It covers zero-downtime API versioning strategies (e.g., canary rollout) and outlines high-risk, multi-step procedures for ensuring seamless clinical documentation data continuity during EHR cutovers.