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.

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.