Skill UI

An expert architect specializing in designing, optimizing, and scaling entire data layers from inception (greenfield) to re-architecture. Proficient in selecting the optimal database technology (SQL, NoSQL, Graph, Time-series), designing robust schemas, implementing sophisticated indexing strategies, and planning complex migration paths. Suitable for defining data storage solutions that meet high performance, scalability, and data integrity requirements.

Provides a practical checklist and principles for designing database schemas, indexing strategies, query optimization, and migration planning for both SQL and NoSQL systems, plus guidance on spotting and fixing N+1 issues and denormalization trade-offs.

Specializes in generating production-grade SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, and SQL Server. Provides comprehensive plans covering data integrity, detailed rollback procedures, performance optimization, and validation checks for critical schema changes.

Actionable guidance for analyzing plans, indexing, connection pooling, partitioning, and detecting N+1 queries to keep PostgreSQL and MySQL workloads fast and reliable.

A specialized skill for optimizing database performance and scalability across PostgreSQL and MySQL. It guides users through analyzing slow queries, interpreting execution plans (EXPLAIN ANALYZE), designing optimal indexing strategies, tuning configuration parameters, and resolving bottlenecks like lock contention. Essential for DevOps engineers, database administrators, and backend developers.

A comprehensive guide detailing optimization techniques for Databricks environments. It covers optimal cluster sizing for various workloads (ETL, ML, Streaming), advanced Spark configurations (AQE, memory management), and deep data optimization strategies for Delta Lake, including Z-Ordering and Liquid Clustering. It also provides methods for query plan analysis and join optimization.

This skill guides the definition of relationships and integration contracts between distinct bounded contexts within a complex system using Domain-Driven Design (DDD) patterns. It is crucial for preventing domain leakage, planning anti-corruption layers (ACLs), and clarifying ownership boundaries when multiple services interact, ensuring a robust and scalable system architecture.

A comprehensive, expert-level workflow for debugging complex software issues in production environments. This skill guides users through initial triage, advanced observability data collection (APM, distributed traces, logs), intelligent hypothesis generation, and full root cause analysis. Use it when dealing with intermittent failures, performance bottlenecks, or needing a complete fix and prevention plan.

Creates step-by-step decomposition plans and migration roadmaps to guide the transition from monolithic applications to distributed architectures, prioritizing risk, value, and dependencies while tracking progress through pattern-based phases.

Uses the Gemini API to autonomously plan, search, read, and synthesize detailed research reports with streaming status updates, structured outputs, and the ability to continue previous investigations for market analysis, technical reviews, or due diligence.

A comprehensive guide for developers planning Deepgram SDK version upgrades (v3/v4 to v5) and model migrations (Nova-2 to Nova-3). This resource details breaking changes, provides side-by-side API comparisons, and includes automated validation scripts to ensure smooth integration of new features and improved speech recognition capabilities.

A comprehensive guide to deployment patterns and strategies for modern cloud environments. Covers techniques like Blue/Green, Canary, and Rolling Deployments, ensuring zero-downtime upgrades when deploying to Kubernetes, Docker, or various cloud providers. Includes best practices for health checks, logging, and rollback planning.