Skill UI

This guide provides technical patterns for building fault-tolerant integrations with Customer.io. Learn to implement critical resilience techniques, including Circuit Breakers to prevent cascading failures, Retry with Jitter for handling transient errors, and Fallback Queues (using Redis) to ensure data continuity during service outages. Essential for robust, production-grade applications.

This comprehensive guide details essential security best practices for integrating with Customer.io. It covers secure credential storage using secrets managers, sanitizing Personally Identifiable Information (PII) via hashing, verifying webhook signatures (HMAC-SHA256) to ensure data integrity, and establishing procedures for API key rotation to maintain compliance with GDPR/CCPA regulations.

This skill provides expert guidance for modern, multi-cloud database administration. It covers comprehensive knowledge across AWS, Azure, and GCP platforms, spanning relational, NoSQL, and graph databases. Key areas include Infrastructure as Code (Terraform, Flyway), achieving high availability, disaster recovery, advanced performance optimization, and ensuring strict regulatory compliance (HIPAA, GDPR). It is essential for managing complex, highly reliable cloud data architectures.

A comprehensive guide covering best practices for database migrations. It addresses schema changes, data migrations, and rollbacks for major databases (PostgreSQL, MySQL) and modern ORMs (Prisma, Drizzle, etc.). Learn how to implement safe, reversible, and zero-downtime schema updates for production environments.

This guide provides expert patterns for building robust, observable infrastructure for database migrations. It covers real-time monitoring using Change Data Capture (CDC), metrics collection (Prometheus/Grafana), and anomaly detection. Use this skill when setting up CDC pipelines (e.g., Debezium with Kafka) or implementing comprehensive observability for database schema changes and data synchronization processes.

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.

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.

A comprehensive guide detailing the setup process for Databricks CLI v2 and Python SDK. It covers essential steps for connecting to various Databricks workspaces, including configuring Personal Access Tokens (PAT), interactive OAuth U2M flows, and secure OAuth M2M service principals for CI/CD pipelines. Essential for developers integrating Databricks into their projects.

A comprehensive guide to setting up a fast, isolated local development loop for data engineering projects using Databricks Connect v2, Asset Bundles, and standard IDEs (like VS Code). This workflow allows developers to run PySpark code locally for debugging and unit testing, while managing resource deployment and ensuring consistency across development, staging, and production environments.

This skill guides the setup and management of Databricks resources across development, staging, and production environments. It covers best practices for using isolated workspaces, managing environment-specific secrets, implementing Asset Bundles, and integrating with CI/CD pipelines to ensure consistent and reliable data deployments.

A comprehensive guide to production-ready patterns for the Databricks Python SDK. This skill covers essential best practices including singleton client initialization, structured error handling with typed exceptions, context-managed cluster lifecycle control (ensuring cleanup), and implementing type-safe job definitions. It is essential for building robust, maintainable, and idiomatic integrations with the Databricks platform.

This guide provides essential best practices for building reliable, fault-tolerant applications in Go using DBOS durable workflows. It covers architectural patterns for integrating DBOS into existing Go code, defining complex workflows, managing steps, and utilizing queues for robust concurrency control. Essential reading for developers setting up, configuring, or testing mission-critical asynchronous processes.