Finops Toolkit

FinOps hubs AI agent instructions

🛡️ CORE OPERATING RULES

Essential commands

• Cost Analysis: #codebase → #azmcp-kusto-query
• Resource Info: #azure_query_learn
• File Search: #codebase
• Azure CLI: #azmcp-extension-az

Non-negotiable rules

1. READ THE REFERENCE DOCS FIRST. Before writing any query or performing any operation, you MUST read the relevant reference files listed in the Reference Files and Reference Queries tables below. These are not optional — they are mandatory prerequisites. Do not guess column names, service mappings, or query patterns from model knowledge. The reference docs contain the authoritative schema, enrichment logic, and query patterns. Skipping them produces wrong results.
2. VERIFY schema before ANY query (Check Database Guide)
3. NEVER guess columns or data
4. SHOW query before execution
5. STOP if confidence <70%

Think-Execute Framework

THINK → PLAN → VERIFY → EXECUTE → VALIDATE

🔄 EXECUTION FRAMEWORK

graph LR
    A[Request] --> B{Think & Analyze}
    B --> C[Validate Schema]
    C --> D[Select Tool]
    D --> E[Execute]
    E --> F[Format Results]
    F --> G[Deliver Insights]

Example: "Why are costs increasing?"

THINK: Cost trend analysis needed
PLAN: Check 30d trends, find anomalies
EXECUTE:
  1. Query: cost-anomaly-detection.kql
  2. Found: Storage +250% (day 15 spike)
  3. Cause: New backup policy
  4. Impact: +$5,000/month
  5. Fix: Adjust retention → Save $3,000

🛠️ TOOL SELECTION

• Have KQL? → #azmcp-kusto-query
• Need query? → #codebase (search catalog)
• Resource info? → #azure_query_learn
• Azure ops? → #azmcp-extension-az

📊 RESPONSE TEMPLATE

Confidence: [High/Medium/Low]
Scope: [Time period, filters]

Quick answer (2-3 sentences)

💰 [Key finding with primary metric]

Analysis (if needed)

[1-2 paragraphs with data table]

Recommendations

1. Immediate: [Action]
2. Next: [Action]

🔧 ERROR RECOVERY

# Auto-retry up to 3x with fixes:
- Schema errors → verify & fix columns
- Timeouts → add filters & optimize
- Syntax → auto-correct
- Access → guide permissions

📏 QUALITY CHECKLIST

• Schema verified
• Query shown
• Results validated
• Confidence stated
• Actions specific

🆘 EMERGENCY PROCEDURES

Critical Failure

1. STOP operations
2. DOCUMENT error
3. NOTIFY user
4. PROVIDE workaround

Low Confidence (<70%)

## ⚠️ Clarification Needed

I need more information:

- Time period? (default: 30 days)
- Scope? (default: all resources)

[Specify or proceed with defaults]

📚 DETAILED GUIDES

• FinOps Framework
• Microsoft FinOps documentation
• FinOps hubs database data model
• FinOps hubs starter queries: references/queries/INDEX.md

FinOps hubs

FinOps hubs query and deployment skills. Provides KQL-based cost analysis and infrastructure deployment capabilities.

Always read references/finops-hubs.md before attempting any FinOps hubs queries or analysis. Use references/queries/INDEX.md for starter queries and read references/queries/finops-hub-database-guide.md before attempting to create your own queries.

Always read references/finops-hubs-deployment.md before attempting any FinOps hubs infrastructure deployment.

Query Catalog

KQL queries for FinOps hubs analysis:

Domain Knowledge

FinOps Hubs (Cost Analysis)

Prerequisites: Load this skill before using the azure-mcp-server kusto command.

Key Facts:

• Uses KQL (Kusto), NOT SQL
• Database: Always use "Hub", never "Ingestion"
• Functions: Costs(), Prices(), Recommendations(), Transactions()
• Default: 30-day analysis window
• Always include tenant parameter for cross-tenant scenarios

Query Execution:

{
  "cluster-uri": "<cluster-uri from .ftk/environments.local.md>",
  "database": "Hub",
  "tenant": "<tenant from .ftk/environments.local.md>",
  "query": "<KQL query>"
}

Configuration: Read environment settings from .ftk/environments.local.md at the project root. Use the default environment unless the user specifies one. See references/settings-format.md for the file format.

For detailed documentation: references/finops-hubs.md

Infrastructure Deployment

Deployment targets:

• Azure Data Explorer clusters
• Microsoft Fabric workspaces
• Cost Management exports
• Power BI dashboards

Key commands: az deployment, az kusto, az storage

For detailed documentation: references/finops-hubs-deployment.md

Reference Files

Load the appropriate reference file when detailed workflows, API examples, or troubleshooting are needed.

Reference Queries

Microsoft Learn documentation

Official Microsoft documentation for FinOps and the FinOps toolkit. Source: learn.microsoft.com.

FinOps overview

FinOps Framework

Understand cloud usage and cost

Quantify business value

Optimize cloud usage and cost

Manage the FinOps practice

FOCUS

Cost optimization best practices

FinOps toolkit

FinOps hubs

Alerts

Bicep registry

Optimization engine

Power BI

Workbooks

Fabric

PowerShell commands

Cost Management commands

Open data commands

FinOps hubs commands

Toolkit commands

Help and support

Converted and distributed by TomeVault — claim your Tome and manage your conversions.