Skill UI

A comprehensive, multi-step guide for migrating contact and company data into Apollo.io. Use this skill when switching from other CRMs (like Salesforce or HubSpot), consolidating multiple data sources, or executing large-scale data imports. It covers defining field mappings, pre-migration data assessment, and performing high-throughput batch processing using the Apollo Contacts API.

This comprehensive guide details how to migrate from multiple standalone data enrichment providers (like ZoomInfo, Apollo, Clearbit) or complex custom scripts into a unified Clay pipeline. It covers auditing current data stacks, mapping disparate fields, running parallel validation tests, and configuring Clay to consolidate data sources, significantly reducing complexity and operational costs.

A comprehensive guide for navigating Clay's plan changes, pricing overhauls (specifically the 2026 model), and feature upgrades. This skill helps users understand credit restructuring from legacy plans to new Data Credits and Actions, audit current usage, and adapt their integration code to ensure uninterrupted workflow operation after a migration.

A comprehensive guide for migrating user authentication systems from major providers like Auth0, Firebase, Supabase, or NextAuth to Clerk. It covers essential steps including user data export, bulk import, updating database references, and replacing client and server-side authentication code for a smooth, phased transition.

Compares PostgreSQL or MySQL schemas using the database-diff-tool, produces transaction-safe migration scripts and rollback procedures, and outlines synchronization steps for staging/production deployments.

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.

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.

Provides a practical checklist and principles for designing database schemas, indexing strategies, query optimization, and migration planning for both SQL and NoSQL systems, plus guidance on spotting and fixing N+1 issues and denormalization trade-offs.

A comprehensive, expert-level skill for designing, analyzing, and optimizing robust database schemas. It covers normalization, index tuning, choosing between SQL/NoSQL, and implementing zero-downtime data migrations. Provides systematic workflows for schema analysis, performance modeling, and advanced SQL pattern generation.

Master the advanced process of database schema and data migrations across major ORMs (Sequelize, TypeORM, Prisma). This skill provides best practices for handling complex transformations, including implementing zero-downtime deployments, renaming columns, changing data types, and executing complex data restructuring. It emphasizes robust rollback strategies to ensure data integrity during critical database updates.

A comprehensive guide covering best practices for database migrations. It addresses schema changes, data migrations, and rollbacks for major databases (PostgreSQL, MySQL) and modern ORMs (Prisma, Drizzle, etc.). Learn how to implement safe, reversible, and zero-downtime schema updates for production environments.

This guide provides expert patterns for building robust, observable infrastructure for database migrations. It covers real-time monitoring using Change Data Capture (CDC), metrics collection (Prometheus/Grafana), and anomaly detection. Use this skill when setting up CDC pipelines (e.g., Debezium with Kafka) or implementing comprehensive observability for database schema changes and data synchronization processes.