Skill UI

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.

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.

This skill provides a comprehensive Python guide to building a production-ready Virtual Cloud Network (VCN) on Oracle Cloud Infrastructure (OCI). It details the entire process from scratch, including creating the VCN, setting up Internet and NAT Gateways, configuring route tables, and defining Network Security Groups (NSGs). This is essential for engineers needing to provision complex, secure, and highly functional network architectures for development or production use.

This skill uses the OCI Usage API and SDK to programmatically track spending across compartments, services, and shapes. It allows users to query granular cost data, set detailed budget alerts (e.g., 80%, 95%, forecast), and identify cost optimization opportunities like utilizing Always Free tiers or preemptible instances, ensuring proactive and precise cloud cost management.

This skill provides comprehensive Python patterns for managing Oracle Cloud Infrastructure (OCI) Object Storage. It covers best practices for creating buckets, handling both simple and large multipart uploads, safely generating and revoking Pre-Authenticated Requests (PARs), and configuring lifecycle policies to ensure data integrity and proper object management within OCI.