Skill UI

A powerful operational companion for database developers. This skill assists with the daily lifecycle of database interactions, including translating natural language requirements into optimized SQL queries, generating database migrations, performing comprehensive schema introspection across multiple dialects (PostgreSQL, MySQL, SQLite, SQL Server), and identifying performance bottlenecks through detailed query optimization and index recommendations. It also supports ORM patterns like Prisma and SQLAlchemy.

This guide provides comprehensive patterns for designing and implementing secure multi-tenant SaaS applications using shared databases. It covers critical techniques like Row-Level Security (RLS) in PostgreSQL, implementing tenant-aware middleware in TypeScript (Express/Fastify), and enforcing data scoping at the ORM level (Prisma/Drizzle). Learn how to prevent data leakage and manage tenant isolation across shared schemas.

This guide provides a comprehensive, step-by-step process to scaffold a modern Spring Boot application using Kotlin. It covers downloading the template, configuring dependencies (including SpringDoc and ArchUnit), and setting up complex polyglot environments using Docker Compose. Supports PostgreSQL, MongoDB, Redis, and WebFlux reactive programming.

Generates integration test cases for .NET data access artifacts targeting Oracle as the authoritative baseline. Tests are portable and later migrated to PostgreSQL in Phase 6. Use only in Phase 3 before migration work begins, not during Phase 6 or against already-migrated projects.

This comprehensive guide covers best practices for building robust database systems. It teaches crucial concepts like schema normalization, effective indexing strategies, selecting the right database (e.g., SQLite vs PostgreSQL) and ORM, and optimizing queries to prevent common performance issues like N+1 problems. It emphasizes making context-aware architectural decisions.

A comprehensive guide and workflow for identifying behavioral risks when migrating applications from Oracle to PostgreSQL. It cross-references code against known differences in complex areas such as empty strings, refcursors, type coercion, sorting, and concurrent transaction handling. Essential for both pre-migration architectural planning and post-migration validation testing.

Scaffold a Spring Boot Java project from start.spring.io with Maven or Gradle, applying sensible defaults for configuration, PostgreSQL, logging, security, testing, and Docker.

Discovers all projects in a .NET solution, classifies each for Oracle-to-PostgreSQL migration eligibility, and produces a persistent master migration plan. Use when starting a multi-project Oracle-to-PostgreSQL migration, creating a migration inventory, or assessing which .NET projects contain Oracle dependencies.

Creates structured bug reports for defects found during Oracle-to-PostgreSQL database migration, covering severity, root cause, reproduction steps, and remediation. Useful for documenting behavioral differences and validating fixes.

This skill migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL. It translates Oracle-specific syntax while preserving method signatures and type-anchored parameters. It leverages orafce where appropriate and applies explicit collation mapping. Use this when converting Oracle stored procedures or functions to PostgreSQL equivalents during database migration.

Generates a structured, actionable integration testing plan for data access artifacts migrating from Oracle to PostgreSQL. The tool analyzes a single target project to identify repositories, DAOs, and service layers, prioritizing tests based on Oracle-specific features and known behavioral differences (e.g., date/time handling, type coercion). It ensures comprehensive test coverage for crucial database interactions.

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.