Skill UI

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.

Guides an AI pair to document application needs, access patterns, and scaling concerns while producing Azure Cosmos DB NoSQL requirements and data model artifacts using established best practices in a structured workflow.

This comprehensive guide provides a complete, step-by-step workflow for setting up a modern Spring Boot Java project from scratch. It covers downloading the project template, configuring multiple data sources (PostgreSQL, Redis, MongoDB), integrating API documentation (SpringDoc), and orchestrating a full, containerized service environment using Docker Compose. Ideal for complex, enterprise-level application development.

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 tool facilitates the migration of stored procedures and functions from Oracle PL/SQL to PostgreSQL PL/pgSQL. It handles complex syntax translation, preserves function signatures and type-anchored parameters, and manages explicit collation mapping. Use this when converting an existing Oracle database schema or application logic to a PostgreSQL environment.

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.

This comprehensive scaffold sets up a complete, modern Power Apps Code App project structure using Vite, React, and TypeScript. It guides developers through initializing the project with PAC CLI, configuring SDK integration, and setting up best practices for connecting to 1,500+ Power Platform connectors (e.g., Office 365, SharePoint, SQL Server). Ideal for building complex, code-first enterprise applications within the Power Platform ecosystem.

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.

This skill is designed for understanding complex database structures. It allows users to list all available tables, intelligently filter relevant tables based on natural language queries, retrieve detailed schemas (columns, types, primary/foreign keys), and map inter-table relationships. It culminates in generating the M-Schema format, which is essential for accurately preparing the context needed for advanced SQL query generation.

A comprehensive reference architecture detailing how to automate Apple Notes on macOS. Since there is no public REST API, this system relies on a layered approach using Node.js, JXA scripting via osascript, local SQLite caching, and FSEvents polling. It outlines best practices for creating robust, local automation solutions for note management and data export.

This guide provides advanced methods to significantly boost Clari API performance and data pipeline efficiency. It covers parallelizing multi-period data exports using Python's concurrency features, implementing a robust local caching mechanism with Time-To-Live (TTL), and optimizing data warehouse loading using SQL MERGE statements. Use this when facing slow exports, high API call volume, or requiring fast data synchronization in multi-forecast environments.