Skill UI

A deep dive into best practices for optimizing application performance across the entire stack, including frontend rendering, backend logic, and database queries. Learn the systematic workflow—Measure, Identify, Fix, Verify—using core metrics like Web Vitals (LCP, INP, CLS) and techniques to resolve common anti-patterns such as N+1 queries and render-blocking resources. Essential for improving user experience and addressing performance regressions.

This advanced prompt acts as a structured guide for generating comprehensive, enterprise-grade technical implementation plans. It forces the detailed breakdown of a feature based on a PRD, covering system architecture (Mermaid diagrams), database schema design, API specifications, frontend component hierarchy, and deployment strategies, all while adhering to a monorepo structure. Ideal for large-scale SaaS development.

Automates the generation of robust, DB-agnostic integration test cases for data access layers (DAL) during major database migrations, specifically from Oracle to PostgreSQL. These tests validate behavioral consistency across both source and target database systems, ensuring that core business logic remains intact after the migration process. Essential for maintaining data integrity and application stability.

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 command-line interface (CLI) for accessing and interacting with Model Context Protocol (MCP) servers. It acts as a unified gateway, allowing users to discover, inspect, and execute tools and APIs from external sources like filesystems, databases, APIs, and specialized services. Essential for programmatic workflow automation and system integration.

A comprehensive guide and checklist for identifying potential risks when migrating database applications from Oracle to PostgreSQL. It systematically cross-references code and migration artifacts against known behavioral differences, covering issues such as empty string handling, refcursors, type coercion, sorting logic, and timestamp semantics. Use this tool during the planning phase to proactively mitigate risks, or during validation to ensure comprehensive integration test coverage for the new PostgreSQL environment.

Fetches real-time Azure retail prices from the public Azure Retail Prices API and guides credit estimations for Copilot Studio agents, covering compute, storage, networking, databases, AI, and Copilot billing scenarios.

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.

This guide provides proven architectural patterns for building complex, reliable, and scalable workflows using n8n. It covers core patterns like Webhook processing, HTTP API integration, database synchronization, AI agent design, and scheduled tasks. Learn how to select the right pattern and utilize advanced components for robust automation.

Automates Notion pages, databases, blocks, comments, and users through Composio’s Notion toolkit via Rube MCP, guiding connection setup, tool sequencing, and schema-aware workflows for operations.