Skill UI

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.

This skill provides a comprehensive solution for deploying containerized applications to Oracle Cloud Infrastructure (OCI). It supports two primary deployment paths: OKE (Oracle Kubernetes Engine) for full Kubernetes orchestration, and Container Instances for a simpler, serverless alternative. Use this skill for automating the entire lifecycle, including pushing images to OCIR, provisioning OKE clusters via Python SDK, and executing Kubernetes deployments using kubectl.

This skill provides a comprehensive guide and code examples for designing robust and scalable Identity and Access Management (IAM) structures within Oracle Cloud Infrastructure (OCI). It covers establishing secure compartment hierarchies, understanding complex policy inheritance rules, implementing least-privilege access controls, and utilizing dynamic groups for service authentication, ensuring best practices for enterprise cloud governance.

A comprehensive guide to launching, listing, and managing Oracle Cloud Infrastructure (OCI) compute instances using Python. This guide specifically addresses the common 'Out of host capacity' error when using Always Free ARM shapes, implementing a robust retry loop to ensure successful deployment. Users can learn the full lifecycle management, from initial connection setup to instance state polling.