Skill UI

This comprehensive tutorial guides developers through setting up and utilizing Algolia for advanced search functionality. It covers fundamental operations such as indexing records using `saveObjects`, performing targeted searches, and configuring index settings (like custom ranking and faceting). The guide also demonstrates advanced use cases, including multi-index federation and browsing all records, making it ideal for developers building or optimizing a search backend.

A comprehensive guide to implementing Role-Based Access Control (RBAC) in ClickHouse. Learn how to manage user authentication, define hierarchical roles, enforce row-level security (RLS) for tenant isolation, restrict data access via column-level grants, and manage resource consumption using quotas and settings profiles. Essential for multi-tenant SaaS and secure data analytics platforms.

This comprehensive guide provides a production-ready reference architecture for implementing scalable search using Algolia. It details best practices for index design (including multi-index strategies), establishing robust data pipelines from source databases, structuring the service layer (search, indexing, settings), and integrating the frontend for optimal performance.

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 comprehensive guide provides advanced techniques to diagnose and significantly boost ClickHouse query performance. It covers analyzing slow queries using system tables, optimizing ORDER BY keys, implementing data skipping indexes (Bloom, Set, MinMax), utilizing projections for pre-aggregation, and fine-tuning server settings and materialized views. Essential for high-volume OLAP environments.

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.

This skill guides the secure configuration of Figma API access across development, staging, and production environments. It details best practices for managing separate API tokens (PATs), file keys, and cache settings. The focus is on implementing robust environment guards and utilizing secret management solutions to prevent cross-environment data leakage and accidental operations.

This skill provides comprehensive guidance on correctly configuring Model Context Protocol (MCP) servers within Claude Code. It details the critical concepts of configuration scope (user vs. project) and outlines best practices to prevent context pollution across different coding sessions. Users learn how to safely add, remove, and clean up MCP settings using specific JSON files, ensuring a stable and efficient development environment.

This skill helps plan engaging, structured puzzle-based activities for various settings like classrooms, parties, and corporate team-building events. Users provide the event description, target audience, and overall goal, and the planner generates a comprehensive activity schedule. It includes a minute-by-minute timeline, necessary materials checklist, and generates pre-configured generator links for diverse puzzles (Word Search, Crossword, Sudoku, etc.), ensuring content is theme-appropriate and ready for one-click use.

A comprehensive guide for diagnosing and resolving slow search performance in Qdrant. This resource covers issues related to low QPS (throughput), high latency for single queries, and slow filtered searches. Solutions include tuning HNSW parameters, managing memory pressure, implementing quantization, optimizing indexing, and configuring cluster settings for maximum efficiency.

This skill provides comprehensive SQL queries and procedures to analyze and optimize Snowflake usage costs. It covers budgeting via resource monitors, right-sizing compute warehouses, tuning auto-suspend settings, and minimizing storage costs. Use it when reviewing billing, implementing cost controls, or reducing credit consumption in your Snowflake environment.

Master the deployment of applications connected to Snowflake across various cloud environments, including serverless functions (AWS Lambda, Cloud Run) and containers. This guide covers best practices for secure connection management, connection pooling, handling secrets (like private keys), and ensuring application reliability in production settings.