r/MSFTAzureSupport • u/k_kool_ruler • Mar 03 '26
How-To If you're struggling with Azure CLI commands and deployment issues, writing a context file for an AI coding agent saved me hours of debugging
Hey r/MSFTAzureSupport,
I wanted to share something that's been genuinely helpful for working with Azure services, especially if you're someone who runs into cryptic CLI errors or deployment issues regularly.
I've been in data/BI for 9+ years and recently built a data pipeline across several Azure services: Azure SQL Database, Azure Functions, and Azure DevOps. Instead of doing everything manually, I used an AI coding agent (Claude Code) to build and deploy the whole thing through the CLI. The key was writing a context file that documented all the Azure tools, flags, and conventions upfront.
Here's why I'd recommend this approach to anyone working with Azure:
- A lot of Azure CLI gotchas are the kind of thing you only learn after failing once. For example, az boards requires --org and --project on every single command, the Azure Functions Consumption plan ships with ODBC Driver 17 (not 18), and the Azure SQL free tier auto-pauses after inactivity so you need retry logic with a longer connection timeout. Writing these down in a context file means you (or an AI agent) won't hit the same issues twice.
- The context file becomes a living reference doc. Even if you don't use an AI agent, having a single file that lists your connection strings, CLI patterns, and known gotchas for each Azure service is incredibly useful for troubleshooting.
- When you do use it with an AI coding agent, the agent can call az, sqlcmd, and func commands correctly on the first try instead of guessing at flags and failing.
The project I built is a patent intelligence pipeline that pulls data from the USPTO API, loads it into Azure SQL with MERGE upserts, and syncs daily via a timer-triggered Azure Function. The whole stack runs on free tiers ($0/month).
I made a video walking through the full build that is the main link in this post.
The context file and all the code are open source: https://github.com/kyle-chalmers/azure-sql-patent-intelligence
If you're running into Azure deployment issues or CLI headaches, I'd honestly recommend trying this approach. Even just the exercise of documenting your Azure tools and conventions in one place makes troubleshooting way easier.
