What is flex-functions-sql-foundry?

An infrastructure scaffold for an Azure Functions serverless API that connects to Azure SQL using a managed identity and calls a Microsoft Foundry AI model. It also checks the generated setup before deployment.

Use it to create and validate Azure Functions Flex Consumption infrastructure, Azure SQL access, managed-identity settings, and Microsoft Foundry model configuration.

It removes the need to assemble the cloud configuration by hand and helps catch missing or invalid deployment settings before the API is deployed.

flex-functions-sql-foundry — Skill by microsoft/agentic-journeys

About the project

microsoft/agentic-journeys is a collection of guided projects that shows how AI coding agents and skills can plan, build, and deploy applications on Azure. It is for developers building Azure applications and teams evaluating agent-assisted development workflows, including APIs, databases, frontends, and AI features. The catalogue entries supply skills, agents, and instructions used in these journeys.

microsoft/agentic-journeys · 5 stars · on GitHub

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent

npx skills add microsoft/agentic-journeys --skill flex-functions-sql-foundry

Clone the repo

git clone --depth 1 https://github.com/microsoft/agentic-journeys

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/skills/microsoft/agentic-journeys/flex-functions-sql-foundry/github.svg)](https://agentmods.dev/skills/microsoft/agentic-journeys/flex-functions-sql-foundry)

Your own site

<a href="https://agentmods.dev/skills/microsoft/agentic-journeys/flex-functions-sql-foundry"><img src="https://agentmods.dev/badge/skills/microsoft/agentic-journeys/flex-functions-sql-foundry/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

Your own site · 80×15

<a href="https://agentmods.dev/skills/microsoft/agentic-journeys/flex-functions-sql-foundry"><img src="https://agentmods.dev/badge/skills/microsoft/agentic-journeys/flex-functions-sql-foundry.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 95 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.

When invoked 1,189 The whole file, excluding the scripts and references it only reads on demand.

Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.

Origin original No closer match found in the catalogue.

Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

Model	Per session	Once invoked
Fable 5.1	$0.00095	$0.01189
Opus 5.5	$0.00038	$0.00476
Sonnet 5.5	$0.00019	$0.00238
Haiku 4.5	$0.00010	$0.00119

Measured 2d ago against content hash 11ee88cbb491, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-30, from the pricing page.

Security

Grade A, and why

flex-functions-sql-foundry scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

journeys/smart-todo/checkpoints/phase-3/repo/.github/skills/flex-functions-sql-foundry/SKILL.md · 95 lines

How it starts

The opening of the file, as written. The whole thing — 95 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Flex Functions with SQL and Foundry

When to Use

Use this skill for an Azure Functions Flex Consumption API that connects to Azure SQL through managed identity and calls a Microsoft Foundry model.

Required Inputs

Collect these before generating infrastructure:

Application name: 3-31 lowercase letters, numbers, and hyphens, starting with a letter
Runtime language: an azd-supported value such as ts, python, csharp, or java
Azure region: verify SQL and model availability there
Foundry model name and region-supported model version

Also resolve the deploying principal's ID, login, and type (User or ServicePrincipal) before provisioning. Never guess missing identity values.

Fast Path and Gate

Run node scripts/scaffold-infra.mjs --target <directory> --name <app-name>.
Generate only application code or infrastructure changes the scaffold does not cover.
Run node scripts/check-infra.mjs --offline.
Do not deploy until the gate passes.
Set the azd subscription, location, region-specific AZURE_AI_MODEL_VERSION, principal ID, login, and type values.
Run node scripts/check-infra.mjs before azd up.

The scaffold and gate use only Node.js standard-library APIs and work from any current directory. Do not copy .azure/, .env files, node_modules/, or compiled Bicep JSON into a new project.

Resource Contract

One azd service named api, hosted on Azure Functions; device clients are not services.
Flex Consumption App Service plan with SKU FC1.
Function App with system-assigned identity for runtime/deployment storage and a user-assigned identity used only for Azure SQL.
functionAppConfig with a supported runtime, 2048 MB memory, maximum instance count, and deploymentpackage blob storage authenticated by system identity.
Storage with shared-key access disabled, default network action Allow, and a deploymentpackage container.
Grant the Function App Storage Blob Data Owner; grant the deployer Storage Blob Data Contributor.
Azure SQL server with the deployer as Entra admin, an AllowAzureServices 0.0.0.0 firewall rule, and a Basic 2 GB database with zone redundancy off.
A post-provision JavaScript hook creates the SQL identity user by client-ID SID, idempotently grants reader, writer, and DDL admin roles, attempts every cleanup action even after a cleanup failure, and never uses a SQL password.
Microsoft Foundry/Azure OpenAI with local auth enabled and the selected model; use GlobalStandard for gpt-5-mini.
Log Analytics and Application Insights.
Function settings for SQL and AI providers, endpoints, deployment, key, SQL FQDN/database/client ID, and identity-based AzureWebJobsStorage__accountName. Do not set FUNCTIONS_WORKER_RUNTIME; set siteConfig.alwaysOn to false.
Outputs use SCREAMING_SNAKE_CASE; API_URL is the origin without /api.
Add the azd-service-name: api tag to the Function App.

Read the full file on GitHub · 95 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

2d ago First seen · 95 lines · 95 tokens per session scan A 11ee88cbb491

Subscribe to this mod's changes

flex-functions-sql-foundry is a skill published in the GitHub repository microsoft/agentic-journeys (5 stars, last pushed yesterday), licensed MIT. It adds 95 tokens to every session and 1,189 once invoked, about $0.0004 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-28.

Backend and APIs Cloud DevOps and cloud

stripe-projects

Provision SaaS services + sync creds via Stripe Projects.

NousResearch/hermes-agent · 15 tokens

azure-eventhub-dotnet

Azure Event Hubs SDK for .NET. Use for high-throughput event streaming: sending events (EventHubProducerClient, EventHubBufferedProducerClient), receiving events (EventProcessorClient with checkpointing), partition management, and real-time data ingestion. Triggers: "Event Hubs", "event streaming"…

microsoft/skills · 94 tokens

azure-mgmt-botservice-dotnet

Azure Resource Manager SDK for Bot Service in .NET. Management plane operations for creating and managing Azure Bot resources, channels (Teams, DirectLine, Slack), and connection settings. Triggers: "Bot Service", "BotResource", "Azure Bot", "DirectLine channel", "Teams channel", "bot management .NET", "create bot".

microsoft/skills · 78 tokens

wikipedia

Search and read Wikipedia via x wkp — MediaWiki API, no API key, zero install; query, extract, suggest, and DDG route in one module. Load for wiki, wikipedia, encyclopedia lookup, article summary.

x-cmd/x-cmd · 49 tokens

cve

Look up CVE records via x cve — cached, zero-API-key, daily xz TSV. Load for cve, vulnerability id, kev, epss, nvd, cvelist, or security advisory.