Skill UI

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.

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.