Skill UI

A comprehensive, production-grade reference architecture for integrating with Apollo.io. It details a layered design encompassing API services, business logic, background job processing (e.g., lead enrichment), and data modeling, enabling the building of robust sales intelligence and CRM synchronization systems.

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.

This comprehensive skill covers the full scope of Firebase services, including Authentication, Firestore, Cloud Functions, and Hosting. It goes beyond basic implementation, focusing on critical architectural principles: adopting a query-first, denormalized NoSQL mindset. Key insights include mandatory security rule design, optimal data modeling for performance, and correctly utilizing modular SDKs to build scalable and secure backends.

Expert guidance on designing highly scalable, distributed NoSQL databases, specifically covering Apache Cassandra and Amazon DynamoDB. This skill emphasizes the 'Query-First' modeling approach, teaching best practices like partitioning, denormalization, single-table design, and avoiding common anti-patterns (e.g., hot partitions, joins) to ensure optimal read/write performance at massive scale.

An expert assistant providing deep knowledge and best practices for Prisma ORM. It covers the entire lifecycle of database interaction, including optimal schema design, relation modeling, safe migration workflows, and advanced query optimization techniques (addressing N+1 issues and implementing raw queries) across PostgreSQL, MySQL, and SQLite.

This comprehensive guide details the expertise needed for a Senior Data Engineer. It covers building, optimizing, and governing scalable data pipelines and robust ETL/ELT systems using modern tools like Spark, Kafka, Airflow, and dbt. Includes decision frameworks for architecting data solutions (Batch vs Streaming, Lakehouse vs Warehouse) and implementing advanced data modeling patterns.

Guidance for integrating Firebase Realtime Database in Flutter apps: data modeling, real-time sync, queries, offline persistence, presence, transactions, fan-out, and security rules. Choose Realtime Database for simple models and low latency or Cloud Firestore for complex querying and scalability.

A comprehensive skill for performing deep security audits and writing secure code in Go. It guides developers through identifying vulnerabilities like SQL injection, XSS, path traversal, and crypto misuse. The framework incorporates advanced techniques such as STRIDE/DREAD threat modeling, data flow tracing, and multi-stage review modes (Audit, Review, Coding), ensuring defense in depth for robust Go applications.

Guides an AI pair to document application needs, access patterns, and scaling concerns while producing Azure Cosmos DB NoSQL requirements and data model artifacts using established best practices in a structured workflow.

Guides creating, altering, and validating Snowflake semantic views via the Snowflake CLI, covering connection setup, star-schema modeling, metadata comments/synonyms, temporary validation steps, and post-validation querying for reliable semantic layer delivery.

This guide provides a comprehensive workflow for building robust ETL data pipelines within Palantir Foundry. It teaches how to utilize Python transforms, including the @transform_df decorator, for dataset-to-dataset processing. Key topics covered include multi-input joins, implementing incremental updates for efficiency, low-level file I/O, and configuring Spark resources for heavy computations. Essential for data engineers working with complex data modeling in Foundry.

This catalog provides a comprehensive set of abstractions, types, and utilities for building robust administrative interfaces within the Webiny Content Management System (CMS). It covers core functionalities such as content entry editing, bulk actions, GraphQL client interactions, and structured data modeling. Developers should import specific named abstractions to ensure correct interfaces and types when extending the CMS.