Build an Azure SQL patent data pipeline with Claude Code

Watch Claude Code build a patent data pipeline on Azure SQL, Azure Functions and Azure DevOps from one structured prompt.

Who it's for: Data professionals who work on the Microsoft data stack.

The problem: One pipeline touches USPTO API calls, SQL merge statements, Azure Functions, matplotlib charts and DevOps tickets. That breadth is hard for any one person to manage.

A CLAUDE.md file and one structured prompt in plan mode let Claude Code build it all on free tiers. After some feedback and a long backfill, the database held 1,753 patents.

Takeaways:

  • Add your IP address to the SQL server's networking settings.
  • Be specific about tools and patterns, then leave the implementation to the agent.
  • Question whether the results are complete.

Resources