azure-table

Define Azure Table Storage patterns for batch writes and soft-delete semantics.

23|3|Updated Jun 28, 2022
One-click install
npx skills add https://github.com/Esposter/Esposter --skill azure-table
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: azure-table
Source: https://github.com/Esposter/Esposter/tree/main/.agents/skills/azure-table
Command: npx skills add https://github.com/Esposter/Esposter --skill azure-table

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Provides proven Azure Table Storage patterns for robust server-side data access, including key constants, partition/row key design, reverse-ticked timestamps, and efficient batch writes.

Core Features & Use Cases

  • Key constants guidance for pagination and batch operations (AZURE_MAX_PAGE_SIZE and AZURE_MAX_BATCH_SIZE) to ensure deterministic processing.
  • Batch write patterns that paginate through results and require all actions in a single transaction share the same partitionKey.
  • Partition/Row key design, reverse-ticked timestamps, and soft-delete semantics with deletedAt for reliable querying and lifecycle management.

Quick Start

Apply these patterns in your server code to design partition/row keys, manage batch writes with page-by-page pagination, and implement soft-delete using deletedAt.

Frequently Asked Questions about azure-table

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design partition and row keys for Azure Table storage?

Design Azure Table storage partition and row keys using constants, reverse-ticked timestamps, and soft-delete semantics to ensure reliable querying and efficient batch writes within a single partition.

Can I batch write across multiple partitions in Azure Table storage?

No, Azure Table storage batch writes require all actions within a single transaction to share the same partitionKey to execute atomically and ensure data integrity.

What is the best way to implement deterministic pagination in Azure Table storage?

Implement deterministic pagination in Azure Table storage by applying constant limits like AZURE_MAX_PAGE_SIZE to paginate through results and ensure consistent processing.

How does soft-delete work with Azure Table storage?

Azure Table storage soft-delete uses a deletedAt field to implement lifecycle management semantics, ensuring reliable querying of active records without immediate data removal.

When do I need reverse-ticked timestamps in Azure Table storage?

Use reverse-ticked timestamps in Azure Table storage to sort records by newest first, enabling efficient querying of recent server-side workloads like messages and moderation logs.