Skill UI

An expert in designing, implementing, and optimizing scalable, reliable, and cost-effective data pipelines for both batch and streaming data. Covers advanced topics including ETL/ELT patterns, Kappa/Lambda architectures, workflow orchestration (Airflow/Prefect), transformation using dbt/Spark, and managing modern storage formats like Delta Lake and Iceberg. Focuses heavily on data quality, monitoring, and cost optimization strategies.

This comprehensive workflow guides the entire database lifecycle, from initial architecture design (covering both SQL and NoSQL) to advanced implementation, optimization, and maintenance. It covers crucial stages like schema design, implementing migrations, optimizing query performance, developing robust data pipelines (using tools like Airflow and dbt), and managing data quality and operations. Ideal for engineers building complex, production-grade data systems.

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.

A comprehensive, expert-level skill for designing, analyzing, and optimizing robust database schemas. It covers normalization, index tuning, choosing between SQL/NoSQL, and implementing zero-downtime data migrations. Provides systematic workflows for schema analysis, performance modeling, and advanced SQL pattern generation.

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.

Automates database schema design guidance for backend projects, activating whenever you ask about schema patterns, best practices, or implementation in node.js, Python, Go, microservices, caching, or messaging contexts.

This skill provides a comprehensive guide on implementing robust data governance patterns within Delta Lake, leveraging Unity Catalog. It covers essential compliance topics such as data classification tagging, handling GDPR 'right-to-deletion' requests for PII, and establishing automated data retention policies. Use this when designing secure, compliant, and auditable data pipelines in a data lake environment.

This comprehensive diagnostic bundle collects critical evidence from the Databricks environment, including environment setup, cluster state, job run history, and Delta table diagnostics. It generates a redacted, safe tar.gz file specifically designed for submitting detailed support tickets and efficiently troubleshooting complex data pipeline issues.

A comprehensive runbook designed for on-call engineers to manage Databricks incidents, outages, and major job failures. It provides structured procedures for immediate triage, decision tree guidance (covering cluster failures, code errors, and data quality issues), and steps for evidence collection and postmortem documentation, ensuring rapid and systematic incident resolution.

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.

This skill guides the architectural definition of complex business domains using Domain-Driven Design (DDD). It helps in defining core subdomains, separating services by bounded contexts, and establishing a unified ubiquitous language. It is essential for decomposing monoliths, structuring microservices, and aligning team ownership with clear domain boundaries.