Skill UI

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 comprehensive guide outlines the end-to-end process of building production-grade ETL data pipelines using Databricks and Delta Lake. It implements the robust Medallion Architecture (Bronze, Silver, Gold) for scalable data management. Techniques covered include Auto Loader for incremental streaming ingestion, MERGE INTO for upsert semantics, data cleansing, and advanced aggregation into analytics-ready layers. Ideal for establishing reliable data pipelines in a data lakehouse environment.

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.

Guides diagnosing Buttercup CRS Kubernetes issues across the crs namespace by triaging pod states, analyzing logs, checking resource pressure, monitoring Redis, and inspecting queues for cascading failures in services such as redis, build-bot, scheduler, and UI.

Provides comprehensive instructions for deploying Deepgram transcription services into various production environments. This guide covers building production-ready Docker images, configuring Docker Compose, setting up robust Kubernetes manifests (including HPA and secrets), and implementing serverless handlers for platforms like AWS Lambda. Essential for scaling Deepgram services reliably and securely in the cloud.

Provides reference architectures for building high-scale, reliable transcription systems using Deepgram. It covers four main patterns: synchronous REST for short files, async queues (BullMQ) for batch processing, WebSocket for real-time streaming, and a hybrid router for mixed workloads. Use this when designing production-grade audio processing pipelines.

This repository provides production-ready, structured templates for building core Decentralized Finance (DeFi) protocols using Solidity. Templates cover essential components such as staking reward systems, Automated Market Makers (AMMs), governance logic, lending/borrowing mechanisms, and flash loans. It is essential for developers aiming to build robust and scalable smart contract applications on blockchain platforms.

Expert in modern CI/CD pipelines, GitOps workflows, and platform engineering. Specializes in designing and implementing secure, zero-downtime deployment strategies for enterprise-scale applications. Proficient with Kubernetes, ArgoCD, Terraform, and advanced security compliance practices.

Detects memory usage issues by scanning code for common leak patterns, such as lingering listeners, closures holding references, or runaway caches, and provides recommendations to fix them before performance degrades.

A comprehensive, end-to-end workflow bundle guiding developers through the entire software development lifecycle. It covers project scaffolding, frontend development (React/Next.js), robust backend architecture, database design, rigorous testing (TDD, E2E), code quality review, and modern CI/CD deployment practices for web and mobile applications.

A specialized guide for building robust and scalable Discord bots from scratch. Covers modern best practices, including the use of slash commands, handling gateway intents, managing rate limits, and implementing sharding. Supports foundational patterns for both Discord.js (JavaScript/TypeScript) and Pycord (Python), ensuring your bot is production-ready and highly stable.

Guidelines for building scalable, maintainable Django apps covering REST API design with DRF, ORM best practices, caching, signals, middleware, and deployment-ready project layouts and settings.