ai-engineering-fluency: Skill for Claude Code

Azure Storage Loader Skill

This skill enables you to load actual token usage data from Azure Table Storage into your chat conversations. This allows for faster iteration when analyzing usage patterns, testing queries, or debugging issues without needing to sync data from local session files.

Overview

The AI Engineering Fluency extension can sync token usage data to Azure Table Storage. This skill provides helper scripts to:

• Query and fetch data from Azure Storage Tables
• Load data into a usable format for chat analysis
• Authenticate using Azure credentials (Entra ID or Shared Key)
• Filter data by date range, dataset, model, workspace, or user

When to Use This Skill

Use this skill when you need to:

• Analyze actual usage data patterns without manual export
• Test query logic against real data
• Debug backend sync issues with live data
• Perform ad-hoc analysis of token usage across teams
• Validate data transformations or aggregations
• Quickly iterate on data analysis tasks in chat

Prerequisites

Before using this skill, ensure you have:

• Azure Storage account with token usage data already synced
• Azure credentials configured (either Entra ID or Shared Key)
• Node.js installed for running helper scripts
• Access to the storage account and table (read permissions minimum)

Azure Table Storage Schema

The extension stores daily aggregate data in Azure Tables with the following schema:

Table Name

Default: usageAggDaily (configurable via aiEngineeringFluency.backend.aggTable)

Entity Structure

Partition Key: ds:{datasetId}|d:{YYYY-MM-DD}

• Groups entities by dataset and day for efficient queries

Row Key: m:{model}|w:{workspaceId}|mc:{machineId}|u:{userId}

• Unique identifier for each model/workspace/machine/user combination

Fields:

• schemaVersion (number): Schema version for compatibility
• datasetId (string): Logical dataset identifier
• day (string): Date in YYYY-MM-DD format
• model (string): AI model name (e.g., "gpt-4", "claude-3-5-sonnet-20241022")
• workspaceId (string): Workspace identifier (sanitized)
• workspaceName (string, optional): Human-readable workspace name
• machineId (string): Machine identifier (sanitized)
• machineName (string, optional): Human-readable machine name
• userId (string, optional): User identifier (if team sharing enabled)
• userKeyType (string, optional): Type of user identifier (pseudonymous/teamAlias/entraObjectId)
• shareWithTeam (boolean, optional): Whether data is shared with team
• consentAt (string, optional): ISO timestamp of consent
• inputTokens (number): Total input tokens for this dimension
• outputTokens (number): Total output tokens for this dimension
• interactions (number): Total interactions count
• updatedAt (string): ISO timestamp of last update