Skill UI

This guide details how to implement robust content safety guardrails for applications powered by Claude. It covers essential techniques such as system prompt hardening, input validation to detect injection patterns and length limits, and output validation to prevent system prompt leakage. It ensures compliance with Anthropic's policies, making the AI integration secure and reliable.

A comprehensive guide to building fault-tolerant integrations with Claude. It details advanced patterns such as built-in SDK retries, model fallback chains, circuit breakers, graceful degradation, and timeout mechanisms. Use this guide to design resilient systems that maintain availability even when the underlying API encounters failures.

This comprehensive guide diagnoses and fixes common Clari API errors, including 401 Unauthorized, empty exports, job timeouts, and data mismatches. It provides step-by-step solutions for debugging data extraction and forecasting issues using API calls.

This skill provides blueprints for deploying Clari data export pipelines into robust, production-grade cloud environments. It guides users on setting up reliable, scheduled, and serverless data syncs using major platforms like Airflow DAGs, AWS Lambda, and Google Cloud Functions. Ideal for automating revenue forecasting and business intelligence data extraction.

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.