Skill UI

A collection of production-ready patterns for wrapping the Canva Connect REST API, supporting both TypeScript and Python implementations. These patterns ensure robust API integration by handling automatic OAuth token refresh, implementing retry logic with exponential backoff, ensuring type safety, and supporting multi-tenant architectures. Use this when building resilient, reusable API wrappers for Canva services.

A set of production-ready wrappers and patterns for interacting with the CAST AI REST API. This package provides robust client implementations in TypeScript and Python, handling critical features such as typed responses, singleton management, automatic retry logic with backoff, and managing cloud resources (e.g., Kubernetes clusters, node optimization). Use it when building reusable, reliable clients for cost optimization and infrastructure management.

This guide provides a quick reference for diagnosing and fixing the top common errors encountered in ClickHouse, including syntax errors, memory limit issues, write permission failures, and data type mismatches. It offers specific error codes, root causes, and actionable SQL solutions for smooth database operation and complex analytics.

This comprehensive guide provides advanced workflows for interacting with ClickHouse. It covers efficient bulk data insertion (CSV, JSON), complex analytical querying (funnel analysis, retention), implementing materialized views for pre-aggregation, and utilizing powerful window functions. Ideal for building high-performance OLAP dashboards and executing large-scale data transformations.

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 teaches users how to set up a ClickHouse database environment. It covers creating a MergeTree table, inserting structured event data using TypeScript, and executing essential analytical queries (e.g., counting, grouping, unique user metrics). Ideal for beginners learning OLAP databases, testing connections, or mastering core data warehousing concepts.

This guide provides comprehensive steps for setting up and authenticating the official ClickHouse client for both Node.js and Python. It covers connecting to ClickHouse Cloud or a self-hosted instance, managing environment variables, and verifying the connection using sample code snippets. Ideal for new ClickHouse projects or integrating data analytics pipelines into existing applications.

Provides a comprehensive setup guide for running ClickHouse locally using Docker Compose. This includes defining the database schema, seeding mock data, and setting up robust integration tests (using vitest). Ideal for developers building OLAP systems or performing local data analysis to ensure schema and query reliability.

A comprehensive guide to reducing Algolia operational costs. This guide details the pricing structure based on search requests and records, providing advanced techniques such as implementing virtual replicas instead of standard replicas, utilizing multi-query search for request batching, and implementing client-side caching. It also includes strategies for auditing, cleaning up unused indices, and monitoring usage via the Analytics API.

A comprehensive guide detailing the breaking changes and step-by-step process for migrating applications from Algolia Search SDK v4 to v5. This resource covers updates to method signatures, import styles, and client usage patterns, ensuring a smooth upgrade process for developers.

A comprehensive guide to implementing advanced user behavior tracking and real-time data synchronization with Algolia. This guide demonstrates how to use the Insights API to track clicks, conversions, and views, and how to build event-driven pipelines using database change listeners (e.g., Prisma middleware) to keep your Algolia index perfectly synced with your core application data. Essential for deep search analytics and relevance tuning.

This guide provides comprehensive instructions for setting up and authenticating the Apify ecosystem. It covers installing and configuring core components including the apify-client library, the native Apify SDK, and the Apify CLI. Learn how to manage API tokens, use environment variables, and initialize the necessary tools for building web scrapers and automation workflows.