Skill UI

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.

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.

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.

Guides adding GraalVM native image support to Java apps by detecting Maven or Gradle frameworks, injecting native build plugins, configuring reflection/resource/JNI/proxy files, iterating builds per Oracle best practices, and validating the native executable.

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.

Scaffolds an empty xUnit integration test project targeting Oracle in .NET solutions, including a transaction-rollback base class and seed data manager. Use in Phase 3 before writing Oracle baseline tests for Oracle-to-PostgreSQL migration.

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.

This utility collects comprehensive diagnostic evidence for Algolia support tickets or internal troubleshooting. It gathers index statistics, API key access control lists (ACLs), recent query logs, and network diagnostic information using API endpoints and shell scripting. Use it when diagnosing search performance or unexpected service behavior.

This guide demonstrates how to implement robust Role-Based Access Control (RBAC) for Algolia Enterprise environments. It covers defining granular permissions using ACLs, generating Secured API Keys for strict multi-tenant data isolation, and building middleware to validate service permissions, ensuring the principle of least privilege in large-scale applications.

This document outlines the reference architecture for integrating diverse enterprise knowledge sources (such as Confluence, Jira, Notion, and Slack) into the Glean search index. It details the end-to-end data flow, covering connector frameworks, message queuing, permission synchronization (ACLs), and client-side search APIs. Designed to ensure continuous, reliable, and low-latency unified search across all corporate data.