Skill UI

A comprehensive guide and code pattern for configuring ClickHouse instances across development, staging, and production environments. It emphasizes best practices for infrastructure-as-code (IaC), secure secrets management (integrating AWS Secrets Manager, Vault, etc.), and ensuring environment-specific settings are correctly applied for reliable data analytics pipelines.

This guide provides production-ready patterns for using the @clickhouse/client library in Node.js. It covers critical, real-world scenarios such as safe typed queries, streaming large data inserts (with backpressure handling), robust batch operations with retries, and streaming SELECT queries for low memory consumption. It also includes best practices for comprehensive error handling and connection lifecycle management, ensuring stable and scalable ClickHouse integrations for data pipelines.

Automates the integration of ClickUp API within Continuous Integration/Continuous Deployment (CI/CD) pipelines using GitHub Actions. This skill allows users to run comprehensive unit and integration tests against the ClickUp API v2, and critically, enables syncing the final deployment status (e.g., 'deployed') back to the corresponding ClickUp task, ensuring task tracking is always aligned with development progress.

This guide provides a comprehensive strategy for configuring ClickUp API access across development, staging, and production environments. It emphasizes the critical importance of environment isolation using separate API tokens and dedicated workspaces to prevent data leaks and accidental destructive operations in live environments. Includes best practices for secret management (Vault, AWS, GCP) and implementing environment guards.

This guide details how to use sophisticated coding agents (such as Codex, Claude Code, or Pi) through a structured bash workflow. It provides methods for complex development tasks, including building new features, refactoring large codebases, and reviewing pull requests (PRs). Key best practices covered include managing pseudo-terminals (PTY), defining focused working directories (`workdir`), and executing tasks in the background for robust, multi-step automation.

A comprehensive guide to configuring robust CI/CD pipelines for Cohere API v2 applications. This skill covers setting up automated unit tests (mocked responses) and critical integration tests (real API calls) within environments like GitHub Actions. It ensures the stability and reliability of Cohere-powered features such as Chat, Embeddings, and Rerank across development cycles.

This guide sets up a comprehensive, fast, and reproducible local development workflow for integrating with the Cohere API v2. It utilizes mocking, vitest for unit testing, and hot reload capabilities (tsx watch) to ensure rapid iteration cycles without constant reliance on external APIs. Ideal for developers building AI applications with Cohere.

A comprehensive guide for configuring and integrating the Cohere API v2 across development, staging, and production environments. This pattern ensures environment-specific settings—including API keys, model selections, token limits, and caching strategies—are correctly applied. It covers best practices for secure secret management using tools like Vault, AWS Secrets Manager, and GCP Secret Manager, ensuring robust and scalable deployments.

A comprehensive guide for optimizing cloud GPU expenditures on CoreWeave. Learn strategies like right-sizing instances, implementing scale-to-zero for development environments, and using quantization techniques (e.g., AWQ, GPTQ) to fit large models onto smaller, cost-effective GPUs, ensuring maximum efficiency and budget adherence for AI/ML workloads.

This guide details setting up and managing CoreWeave GPU cloud infrastructure across Development, Staging, and Production environments. It ensures strict resource separation using dedicated Kubernetes namespaces for GPU quotas and scaling policies. Use this when deploying complex ML/AI workloads requiring robust environment isolation and controlled promotion workflows.

This skill provides comprehensive guidance for building and managing applications using Amazon Aurora DSQL, a serverless, distributed, PostgreSQL-compatible SQL database. Topics cover schema management, multi-tenant isolation, IAM authentication, complex DDL migrations (column, constraint), MySQL data type mapping, and advanced query performance tuning using plan explainability tools, ensuring robust and scalable data architecture.

This guide sets up a professional, cost-effective local development workflow for ElevenLabs TTS/voice projects. It includes SDK mocking to prevent character quota overruns during testing, hot-reloading capabilities, and quota-aware scripts. Ideal for developers building robust AI voice applications.