This skill should be used when the user asks about "Azure SQL", "SQL Database", "Cosmos DB", "Redis Cache", "database on Azure", "NoSQL", "document database", "caching", or mentions Azure database and data services. Provides best practices and MCP tool guidance for Azure data services.
/plugin marketplace add charris-msft/azure-plugin/plugin install charris-msft-azure-mcp@charris-msft/azure-pluginThis skill inherits all available tools. When active, it can use any tool Claude has access to.
Azure provides multiple database services for different data models and workloads. This skill covers Azure SQL Database, Cosmos DB, and Azure Cache for Redis.
MCP Tools Available: When the Azure MCP server is enabled, use these tools:
azure_sql_server_list - List SQL serversazure_sql_database_list - List databases on a serverazure_sql_firewall_list - List firewall rulesazure_cosmosdb_account_list - List Cosmos DB accountsazure_cosmosdb_database_list - List databases in accountazure_cosmosdb_container_list - List containersazure_redis_cache_list - List Redis cachesIf Azure MCP is not enabled: Prompt the user to enable it via /mcp or run /azure:setup.
| Service | Data Model | Use Case | Scale |
|---|---|---|---|
| Azure SQL | Relational | OLTP, structured data | Single region |
| Cosmos DB | Multi-model | Global, low latency | Multi-region |
| Redis Cache | Key-value | Caching, sessions | Regional |
| PostgreSQL | Relational | Open source preference | Single region |
| MySQL | Relational | LAMP stack | Single region |
Choose Azure SQL when:
Choose Cosmos DB when:
Choose Redis when:
| Tier | Use Case | vCores | Storage |
|---|---|---|---|
| Basic | Dev/test | Shared | 2 GB |
| Standard | Small production | Shared | 250 GB |
| Premium | High IOPS | Dedicated | 4 TB |
| Hyperscale | Large databases | Dedicated | 100 TB |
| Serverless | Variable workloads | Auto-scale | 4 TB |
DTU model: Bundled compute/storage/IO - simpler vCore model: Separate compute/storage - more control
Recommend vCore for:
| Option | SLA | Use Case |
|---|---|---|
| Zone redundant | 99.995% | Regional HA |
| Geo-replication | RPO <5s | Disaster recovery |
| Auto-failover groups | Automatic | Multi-region HA |
| API | Data Model | Use Case |
|---|---|---|
| NoSQL (Core) | Document | Most scenarios, native |
| MongoDB | Document | MongoDB compatibility |
| PostgreSQL | Relational | Distributed PostgreSQL |
| Cassandra | Wide-column | Cassandra workloads |
| Gremlin | Graph | Graph relationships |
| Table | Key-value | Azure Table migration |
Partition key selection is critical:
Good partition keys:
userId for user datatenantId for multi-tenantdeviceId for IoTBad partition keys:
status (few values)timestamp (hot partition)region (uneven distribution)| Level | Guarantees | Latency | Use Case |
|---|---|---|---|
| Strong | Linearizable | Highest | Financial |
| Bounded | Bounded staleness | High | Inventory |
| Session | Session consistency | Medium | Most apps |
| Consistent Prefix | Order preserved | Low | Audit logs |
| Eventual | No guarantees | Lowest | Recommendations |
Default to Session consistency for most applications.
RU = normalized cost of operations
Provisioned throughput: Set RU/s, consistent cost Autoscale: 10-100% of max, automatic Serverless: Pay per request, variable workloads
| Tier | Features | Use Case |
|---|---|---|
| Basic | Single node, no SLA | Dev/test |
| Standard | Replicated, 99.9% SLA | Production |
| Premium | Clustering, VNet, persistence | High scale |
| Enterprise | Redis modules, 99.99% SLA | Enterprise |
Cache-Aside:
Write-Through:
Write-Behind:
1. List servers with azure_sql_server_list
2. List databases with azure_sql_database_list
3. Check firewall rules with azure_sql_firewall_list
1. List accounts with azure_cosmosdb_account_list
2. List databases with azure_cosmosdb_database_list
3. List containers with azure_cosmosdb_container_list
Use azure_redis_cache_list to view all caches.
Check tier, size, and configuration.
| Operation | MCP Tool | Description |
|---|---|---|
| List SQL servers | azure_sql_server_list | Get SQL servers |
| List SQL databases | azure_sql_database_list | Get databases |
| List firewall rules | azure_sql_firewall_list | Get SQL firewall rules |
| List Cosmos accounts | azure_cosmosdb_account_list | Get Cosmos DB accounts |
| List Cosmos databases | azure_cosmosdb_database_list | Get databases |
| List Cosmos containers | azure_cosmosdb_container_list | Get containers |
| List Redis caches | azure_redis_cache_list | Get Redis caches |
This skill should be used when the user asks to "create an agent", "add an agent", "write a subagent", "agent frontmatter", "when to use description", "agent examples", "agent tools", "agent colors", "autonomous agent", or needs guidance on agent structure, system prompts, triggering conditions, or agent development best practices for Claude Code plugins.
This skill should be used when the user asks to "create a slash command", "add a command", "write a custom command", "define command arguments", "use command frontmatter", "organize commands", "create command with file references", "interactive command", "use AskUserQuestion in command", or needs guidance on slash command structure, YAML frontmatter fields, dynamic arguments, bash execution in commands, user interaction patterns, or command development best practices for Claude Code.
This skill should be used when the user asks to "create a hook", "add a PreToolUse/PostToolUse/Stop hook", "validate tool use", "implement prompt-based hooks", "use ${CLAUDE_PLUGIN_ROOT}", "set up event-driven automation", "block dangerous commands", or mentions hook events (PreToolUse, PostToolUse, Stop, SubagentStop, SessionStart, SessionEnd, UserPromptSubmit, PreCompact, Notification). Provides comprehensive guidance for creating and implementing Claude Code plugin hooks with focus on advanced prompt-based hooks API.