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.

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.

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.

This skill provides a comprehensive guide to configuring and handling Fathom webhooks. It allows developers to receive real-time and completed meeting data at a custom endpoint. The payload includes critical information such as meeting summaries, full transcripts, and action items. Ideal for building automated data pipelines, triggering workflows, and integrating meeting intelligence into custom applications.

Generates publication-quality, editable SVG vector graphics for structured diagrams, including system architectures, complex workflows, and pipelines. By taking a structured FigureSpec JSON as input, this tool ensures deterministic output: the same spec always yields the same diagram, making it ideal for formal documentation and system modeling where precise layout is mandatory. It operates entirely locally without external APIs. Use when you need a highly structured, technical diagram rather than a natural illustration or data plot.

Automates the Continuous Integration (CI) and Continuous Deployment (CD) pipeline for Finta fundraising CRM data. It runs mocked unit tests on every pull request (PR) and executes comprehensive integration tests against the live API upon merging to the main branch. This ensures the integrity of data synchronization logic, pipeline stage transitions, and automated investor reporting workflows.

A comprehensive guide to optimizing the Finta fundraise workflow. This document addresses critical performance bottlenecks, including pagination issues with large investor datasets, latency in multi-stage round data aggregation, and slow CRM synchronization. Optimization strategies cover cursor-based fetching, strategic caching (TTL management), connection pooling, and robust rate limit handling, aiming to reduce pipeline load times by 50-70% and maintain dashboard responsiveness.

A comprehensive checklist designed to verify the production readiness of Finta CRM integrations. It covers critical areas such as API connectivity, robust security protocols, data synchronization (e.g., pipeline stages, financial records), error handling, and monitoring setup. Used by development or operations teams to ensure seamless, reliable, and accurate fundraise operations and investor communication.

A comprehensive reference architecture for building robust and scalable supply chain integrations with Flexport's logistics API. It outlines a structured pipeline using Ingest (webhooks/polling), Core (business logic services), and Expose (REST API/Dashboard layers), ensuring reliable data flow, caching, and queueing best practices.

This skill establishes CI/CD pipelines for complex financial workflows, including expense tracking, budget alerts, and compliance reporting for startup accounting (Fondo). It runs comprehensive unit and integration tests on every pull request and main branch merge, validating data transformation, monitoring filing deadlines, and ensuring live API connectivity to maintain financial data integrity and compliance.

This skill demonstrates the complete workflow for integrating with the Glean platform. It guides users through three core steps: setting up a custom data source using the Indexing API, programmatically indexing documents, and executing advanced search queries using the Client API. This is essential for developers starting new Glean connectors or needing to test their search pipelines.

This skill provides comprehensive guidelines and implementation examples for managing rate limits when interacting with the Glean Indexing and Search APIs. It includes a custom RateLimiter class, robust retry logic (handling 429 errors and server errors), and best practices for batch processing large datasets, ensuring stable, high-volume data ingestion pipelines.