Skill UI

A comprehensive guide and code implementation for scaling data enrichment pipelines to handle high volumes (10K-100K+ leads monthly). It covers capacity planning, optimizing batch processing using queues (e.g., BullMQ/Redis), managing rate limits, and designing multi-table architectures for robust, large-scale data ingestion.

A comprehensive guide and implementation framework for managing real-time data flow using Clay's event-driven architecture. This skill covers both inbound webhooks (POSTing data into Clay tables) and outbound HTTP API callbacks (receiving enriched data from Clay). It provides production-ready TypeScript code for setup, signature verification, and idempotent processing, enabling robust, event-driven integrations.

This comprehensive guide demonstrates how to implement enterprise-grade Role-Based Access Control (RBAC) and organization management using Clerk. It covers setting up multi-tenant architectures, defining granular custom roles and permissions (e.g., data:write, org:admin), integrating SSO (SAML/OIDC), and securely protecting both Next.js routes (via middleware) and client components based on user roles and specific permissions. Ideal for building secure, scalable SaaS applications.

A comprehensive guide for designing production-grade lead enrichment pipelines in Clay. Covers three integration patterns (Webhook, API), detailed table schema design, advanced data waterfall logic, implementing complex ICP scoring formulas, and setting up robust CRM synchronization flows for go-to-market data operations.

This comprehensive template provides a production-grade reference architecture for CodeRabbit AI code reviews. It is designed to guide teams in establishing rigorous coding standards by defining specific, best-practice instructions for various layers (API, Database, Authentication, Frontend, CI/CD, Infrastructure). Use this as a robust starting point to build a comprehensive, automated, and secure code quality review process.

This skill provides a comprehensive guide to implementing the Command Query Responsibility Segregation (CQRS) pattern. It is crucial for separating read and write concerns, allowing independent scaling of read models, optimizing complex query performance, and building robust, event-sourced architectures when read and write data models differ.

A comprehensive reference guide for structuring development projects within the Cursor IDE. It details best practices for directory layout, defining layered rules (covering global conventions, security constraints, and technology-specific patterns like API routes and database access), and optimizing indexing strategies. This ensures maximum AI effectiveness, improves code maintainability, and streamlines the entire development workflow.

A comprehensive reference architecture guide for implementing enterprise-grade integrations with Customer.io. It details best practices for building robust, scalable, and reliable systems, focusing on event-driven patterns, message queuing (e.g., Redis/Kafka), service layer separation, and idempotency. Ideal for designing complex data pipelines and ensuring high availability in mission-critical applications.

This comprehensive workflow guides the entire database lifecycle, from initial architecture design (covering both SQL and NoSQL) to advanced implementation, optimization, and maintenance. It covers crucial stages like schema design, implementing migrations, optimizing query performance, developing robust data pipelines (using tools like Airflow and dbt), and managing data quality and operations. Ideal for engineers building complex, production-grade data systems.

This skill provides expert guidance for modern, multi-cloud database administration. It covers comprehensive knowledge across AWS, Azure, and GCP platforms, spanning relational, NoSQL, and graph databases. Key areas include Infrastructure as Code (Terraform, Flyway), achieving high availability, disaster recovery, advanced performance optimization, and ensuring strict regulatory compliance (HIPAA, GDPR). It is essential for managing complex, highly reliable cloud data architectures.

An expert architect specializing in designing, optimizing, and scaling entire data layers from inception (greenfield) to re-architecture. Proficient in selecting the optimal database technology (SQL, NoSQL, Graph, Time-series), designing robust schemas, implementing sophisticated indexing strategies, and planning complex migration paths. Suitable for defining data storage solutions that meet high performance, scalability, and data integrity requirements.

This comprehensive guide outlines the end-to-end process of building production-grade ETL data pipelines using Databricks and Delta Lake. It implements the robust Medallion Architecture (Bronze, Silver, Gold) for scalable data management. Techniques covered include Auto Loader for incremental streaming ingestion, MERGE INTO for upsert semantics, data cleansing, and advanced aggregation into analytics-ready layers. Ideal for establishing reliable data pipelines in a data lakehouse environment.