Skill UI

Guided instructions to scaffold a Spring Boot 3.4.5 (Java 21) project with Lombok, JPA, Redis, Mongo, docs, and Docker Compose services plus Maven commands for building and testing locally.

This skill analyzes an entire .NET solution (containing multiple projects) to map out a systematic migration path from Oracle to PostgreSQL. It scans for common Oracle indicators (NuGet packages, connection strings, code usage) and classifies every project into categories like MIGRATE, SKIP, or ALREADY_MIGRATED. The output is a structured, actionable Master Migration Plan, helping development teams manage large-scale database transitions efficiently.

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.

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.

Analyzes PostgreSQL snippets or entire projects to flag anti-patterns, enforce best practices, optimize JSONB/array usage, schema design, custom types, triggers, extensions, and security policies like RLS.

Assistant for PostgreSQL developers that highlights native features, advanced data types, performance tuning patterns, and extension usage to optimize queries, indexes, and analytics in PostgreSQL projects.

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.