Skill UI

This skill provides a comprehensive guide for deploying a containerized Finta integration service using Docker. It connects to the Finta API to manage critical fundraising data, including tracking fundraising rounds, investor pipelines, and deal flow analytics. The implementation covers environment configuration, health checks, and rolling update strategies, ensuring zero-downtime operation during active fundraising campaigns.

A comprehensive guide detailing security best practices for the Hex data analytics platform. This covers secure API key management (read vs. run scopes), implementing least privilege access, validating webhooks, and redacting sensitive data from logs. Use this guide when auditing Hex security configuration or integrating secure data pipelines.

This comprehensive debugging bundle collects essential diagnostic evidence from Linktree link-in-bio API integrations. It systematically checks OAuth token validity, profile metadata retrieval, link status, click analytics availability, and webhook endpoint health. The resulting data package helps support engineers quickly diagnose complex issues like broken links, missing analytics events, and permission errors without needing direct Linktree admin access. Ideal for QA and support teams.

Provides comprehensive guidance and code patterns for upgrading and migrating integrations with the Linktree API. It addresses breaking changes related to link types, analytics schema updates, and profile customization fields, ensuring reliable data synchronization and link management across evolving versions.

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.

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 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.

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.

Builds a robust, automated workflow to export critical sales data—including forecasts, quota details, adjustments, and CRM totals—from Clari CRM to a designated data warehouse. The pipeline supports multiple targets like Snowflake, BigQuery, and PostgreSQL, ensuring that real-time revenue intelligence is available for advanced analytics and business reporting.

This reference architecture provides a comprehensive blueprint for building a robust revenue intelligence data platform integrated with Clari. It covers the entire data lifecycle, including API data extraction (ETL pipeline), data warehousing design (Snowflake/BQ), change detection logic, and advanced analytics/alerting layers. Use this guide when designing a scalable forecast tracking system, planning complex data integrations, or establishing best practices for enterprise revenue analytics.

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.

Provides a comprehensive, production-ready reference architecture for building advanced analytics platforms powered by ClickHouse. It details everything from project layout (TypeScript/Node.js structure) and data ingestion pipelines (Kafka, Webhooks) to the optimal 3-layer schema design (Raw, Hourly, Daily) and multi-tenancy patterns, ensuring scalable and efficient OLAP query performance.