Skill UI

This skill provides a comprehensive pipeline for deploying Customer.io integrations to major production cloud platforms, including Google Cloud Run, Vercel, AWS Lambda, and Kubernetes. It details best practices for secure deployment using dedicated secrets managers, integrating robust health check endpoints, and implementing blue-green strategies, ensuring reliable and scalable CI/CD workflows.

This skill provides a comprehensive solution for implementing observability for Customer.io integrations. It covers setting up Prometheus metrics (latency, request counts, bounces), structured JSON logging with PII redaction, and OpenTelemetry tracing. Use it when building robust, production-grade monitoring dashboards and alerting systems for Customer.io APIs.

This skill provides advanced engineering patterns to dramatically improve the performance and reliability of Customer.io API integrations. It implements critical optimizations such as HTTP connection pooling, LRU deduplication caching, parallel batch processing, and fire-and-forget async tracking. Use this when integrating Customer.io into high-throughput, mission-critical systems to reduce latency from seconds to milliseconds.

A comprehensive guide for safely upgrading and migrating the Customer.io Node SDK. It details the necessary steps for handling major version changes, such as transitioning from the legacy CustomerIO class to the modern TrackClient and APIClient pattern. Use this skill when refactoring old code, adapting to breaking API changes, or ensuring compatibility with the latest SDK best practices.

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, 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.

This skill automates the creation of comprehensive documentation for relational databases (PostgreSQL/MySQL). By introspecting live schemas, it extracts detailed metadata including table structures, column descriptions, primary/foreign key relationships, indexes, views, and stored procedures. The output provides a data dictionary, entity-relationship map, and schema statistics, crucial for knowledge transfer and database lifecycle management.

Master the advanced process of database schema and data migrations across major ORMs (Sequelize, TypeORM, Prisma). This skill provides best practices for handling complex transformations, including implementing zero-downtime deployments, renaming columns, changing data types, and executing complex data restructuring. It emphasizes robust rollback strategies to ensure data integrity during critical database updates.

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.

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.