partition-strategy

What problem does it solve?

Helping architects and engineers choose partition keys and query patterns for Cosmos DB to minimize RU costs, avoid hot partitions, and improve query performance across single-tenant and multi-tenant scenarios.

Core Features & Use Cases

• Hierarchical partition guidance: Advice for designing up to three-level partition keys (tenant, time, discriminator) to support point reads and scoped queries.
• Partition key construction patterns: Examples for building full and partial PartitionKey values and choosing between entity-per-container and polymorphic container designs.
• Operational guidance: Recommendations to detect existing partition patterns, reduce cross-partition fan-out, and monitor RU consumption.
• Use Case: Design partitioning for an invoices container in a multi-tenant system to support tenant-isolated queries and monthly reporting without hot partitions.

Quick Start

Ask the skill to recommend a hierarchical partition key and query strategy for a Cosmos container storing multi-tenant invoices with high write volume.