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.

Guides adding GraalVM native image support to Java apps by detecting Maven or Gradle frameworks, injecting native build plugins, configuring reflection/resource/JNI/proxy files, iterating builds per Oracle best practices, and validating the native executable.

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.

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 universal assistant for conducting deep code reviews across major SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). It rigorously analyzes SQL code for critical vulnerabilities (like SQL injection), performance bottlenecks, maintainability issues, and adherence to industry best practices. Features include security audits, index optimization recommendations, query structure analysis, and schema design validation, ensuring robust and secure database development.

Cross-database SQL performance optimization assistant offering query tuning, indexing strategies, pagination, batch operations, and monitoring guidance for MySQL, PostgreSQL, SQL Server, Oracle, and other relational systems.

This skill provides a structured framework for running multi-branch "What-If" scenario analyses. Instead of predicting a single outcome, it maps the full possibility space by exploring 4-6 distinct branches (e.g., Best Case, Worst Case, Wild Card, Contrarian). It is ideal for strategic planning, risk mapping, contingency development, and stress-testing complex decisions before committing resources.

A comprehensive guide to advanced SQL injection (SQLi) methodologies for offensive security assessments and bug bounty hunting. Covers all major injection types, including error-based, boolean/time-based blind, out-of-band, and second-order injection. Provides specific payloads and techniques for MySQL, MSSQL, PostgreSQL, Oracle, and NoSQL databases, along with methods for bypassing WAFs, exploiting GraphQL, WebSocket, and modern API filters. Includes full automation workflows using tools like sqlmap.

This skill provides a comprehensive guide to setting up robust CI/CD pipelines for Oracle Cloud Infrastructure (OCI). It leverages GitHub Actions and Terraform to automate the deployment, planning, and testing of OCI resources. Instructions cover secure API key authentication, best practices for managing Terraform state, and crucial workarounds for known OCI provider bugs, ensuring stable and reliable cloud deployments.

This comprehensive guide helps users diagnose and resolve common Oracle Cloud Infrastructure (OCI) API errors. It covers critical issues like authentication failures (401), authorization errors (404), SSL certificate problems, and rate limiting (429). The resource provides runnable Python and Bash scripts to pinpoint the exact root cause and implement the necessary fixes, significantly streamlining cloud debugging processes.

This skill provides comprehensive functionality for provisioning, managing, and scaling Oracle Cloud Infrastructure (OCI) compute instances using the Python SDK. It addresses common challenges like "out of host capacity" errors by implementing robust retry logic across multiple Availability Domains (ADs). Users can select optimal Flex shapes (AMD, ARM, Intel), manage the entire instance lifecycle (start, stop, reboot, terminate), and retrieve network details, ensuring reliable cloud workload deployment.