[Rule] Use stored procedures only for multi-document atomic operations within a single partition

[sajeetharan]

Stored procedures are often misused as a general server-side compute layer. They should only be used when you need atomicity across multiple items in a single partition and can't use transactional batch.

We need a rule clarifying:

• Valid use case: multi-document ACID within one partition
• Anti-patterns: using sprocs for single-item CRUD, cross-partition logic, or heavy computation
• Limitations: 5-second timeout, single-partition scope, hard to debug
• Prefer SDK-side logic + transactional batch for most scenarios

Category: \pattern-\ Design Patterns
Impact: Medium
Suggested file: \skills/cosmosdb-best-practices/rules/pattern-stored-procedure-scope.md\

References:

• https://learn.microsoft.com/azure/cosmos-db/nosql/stored-procedures-triggers-udfs

---

This is a good first issue! Follow the Contributing Guide and use the rule template to get started.

[ramnnn2006]

Hi @sajeetharan, i'd like to work on this one.
i went through the contributing guide and a few existing rules to get the format. the idea makes sense, sprocs only when you need multi-doc atomicity in one partition, otherwise transactional batch

i will raise a PR for pattern-stored-procedure-scope.md. Can you assign it to me

[ramnnn2006]

i've made the PR
check and let me know if any changes/improvements are to be made! ⭐