build-sqlmcpserver-demo

Build / provision the LOCAL demo environment for the "SQL MCP Server: Bringing AI Agents to Your SQL Data" (Adventure Works scenario) on this machine, so the demos will run. USE WHEN the presenter says any of: "build the sqlmcpserver demo environment on this machine", "set up the SQL MCP Server demo kit", "build the SQL MCP Server demo environment", "provision the AdventureWorks demo on this laptop", "get the SQL MCP demo ready on this box", or moves the talk to a new machine and needs AdventureWorks + the view + a validated DAB config in place. Scope is DOWNLOAD + RESTORE + SCHEMA/VIEW + VALIDATE CONFIG + VERIFY + check MCP registration ONLY. Do NOT use to run/rehearse the demos (that's run-sqlmcpserver-demos) or to author slides.

Jump to install

Repository: microsoft/bobsql
Last source activity: July 27, 2026 at 22:26
Detected SKILL.md language: English
Stars: 317
Forks: 170

Install options

The review-first prompt is selected by default. You can switch to a direct command or download a local copy.

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

A direct command skips the review prompt. Inspect the source before running it.

npx skills add https://github.com/microsoft/bobsql --skill build-sqlmcpserver-demo

The command stays on one line. Scroll horizontally to inspect it before copying.

Prefer a local copy? Download the files currently available to SkillsMP.

Review the source files

Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.

SKILL.md

Source instructions · Read-only preview

Back to search Back to installation

build-appdev-demo

Provision, repair, verify or tear down the Azure environment for DATACON 2026 Demo 5 — "the database is the event producer" (Azure SQL Hyperscale + Change Event Streaming → Event Hubs → two Azure Functions → SignalR → browser, with a Microsoft Foundry agent triaging each ticket). USE WHEN the presenter says any of: "build the app dev demo", "build demo 5", "provision the ticket stream demo", "set up the change event streaming demo", "deploy demo 5 on this machine", "rebuild demo 5", "the agent verdict never shows up", "05-verify passes but the agent does nothing", "redeploy the function app", "re-run the model bake-off", "move demo 5 to another region", "tear down demo 5", or moves this talk to a new laptop and needs Event Hubs + SignalR + the Entra-only Hyperscale server + CES + the function app + the Foundry agent in place. Scope is PROVISION + CONFIGURE + VERIFY + TEARDOWN ONLY. Do NOT use to present or rehearse the beats (that's run-appdev-demo), to build the Private Link demo 3 environment (that's build-

2026-08-24

build-privatelink-demo

Provision, rename, re-region, verify or tear down the Azure environment for DATACON 2026 Demo 3 — "the control plane is the security perimeter" (Private Link + Entra-only Azure SQL Hyperscale + a client VM whose managed identity is the server admin). USE WHEN the presenter says any of: "build the private link demo", "provision demo 3", "set up the control plane demo", "deploy the privatelink demo on this machine", "rebuild demo 3", "move demo 3 to another region", "rename the demo 3 server", "the VM got deallocated, redeploy it", "run pre-flight for demo 3", "why is 05-verify failing", "tear down demo 3", or moves this talk to a new laptop and needs the VNet + VM + Entra-only server + demo kit in place. Scope is PROVISION + CONFIGURE + VERIFY + TEARDOWN ONLY. Do NOT use to present or rehearse the five beats (that's run-privatelink-demo), to build the Adventure Works / SQL MCP kit, or to deploy the Ward General hyperscale talk — those are separate.

2026-08-24

run-appdev-demo

Drive the live three-beat app-dev demo for DATACON 2026, "Why Azure Is the Best Cloud for SQL" — Demo 5, the database is the event producer (one INSERT into Azure SQL Hyperscale → Change Event Streaming → Event Hubs → two Azure Functions racing on separate consumer groups → SignalR → a live browser, with a Microsoft Foundry agent triaging the ticket). USE WHEN the presenter says any of: "let's run demo 5", "start the app dev demo", "run the ticket stream demo", "let's do the change event streaming demo", "walk me through demo 5", "next beat", "rehearse demo 5", "pre-flight demo 5", "is demo 5 ready", "reset the ticket demo", "fire another ticket", "what do I say when the card appears", "the agent verdict is slow, is that normal", or wants step-by-step help presenting this arc on stage. Scope is RUN / REHEARSE / RESET the beats ONLY. Do NOT use to provision, redeploy or tear down the environment (that's build-appdev-demo), to run the Private Link demo 3 beats (that's run-privatelink-demo), or to run the Advent

2026-08-24

View all from this repository

name

build-sqlmcpserver-demo

description

Build the SQL MCP Server demo environment

Stand up everything the SQL MCP Server demos need on this machine, then verify. Everything is local — a SQL Server 2025 instance on localhost with Windows integrated auth, the stock AdventureWorks database, and Data API builder (DAB) as the SQL MCP Server. No cloud egress.

All paths are workspace-relative to the bobsql root. Kit: sqlmcpserver/build/. Run .ps1 scripts synchronously (isBackground:false, timeout:0); check exit codes; one command per call.

Prereqs to check first (do NOT try to install these — stop and tell the presenter if missing)

SQL Server 2025 local instance reachable on localhost via Windows auth (current login = sysadmin). No container, no sa.
sqlcmd on PATH (SqlServer command-line tools).
.NET SDK (for the DAB global tool).
PowerShell 7+ (scripts are #requires -Version 7.0).

Quick gate:

sqlcmd -S localhost -E -C -Q "SELECT @@VERSION;"     # instance reachable via Windows auth?
Get-Command sqlcmd, dotnet, pwsh -ErrorAction SilentlyContinue

Build procedure — one command

& sqlmcpserver/build/setup.ps1

setup.ps1 is the one-shot build. It:

Checks host prereqs (sqlcmd, dotnet, pwsh; SQL reachable via Windows auth) and aborts if missing.
Downloads AdventureWorks2022.bak (git-ignored; skipped if already present).
Restores it as [AdventureWorks] (Windows auth).
Deploys the mcp schema + mcp.vProductComponents view.
Ensures the DAB CLI and runs dab validate on build/dab/dab-config.json.

(The individual scripts — download-adventureworks.ps1, restore-adventureworks.ps1, sql/01-mcp-views.sql, build.ps1 -NoStart — still exist if you need to run a single step.)

Verify — one command

& sqlmcpserver/build/verify-preflight.ps1

Read-only. Asserts: DB up, Production.Product = 504, mcp.vProductComponents for Touring-1000 = 14, dab --version ≥ 2.0.9, dab validate passes, ≤ 1 DAB process. Exit 0 = all green — that is the definition of "built."

MCP surface + registration (HTTP)

The MCP server is now HTTP on :5001, not stdio. .vscode/mcp.json (workspace root) registers Adventure Works (SQL MCP) → http://localhost:5001/mcp. The kit is location-independent (scripts resolve paths via $PSScriptRoot; the config uses localhost) — nothing to edit when the repo path changes. REST (/api), GraphQL (/graphql), and MCP (/mcp) all come from the one :5001 process.

Going live is the run skill's job, not this one; for reference the go-live command is:

& sqlmcpserver/build/start-mcp-http.ps1   # starts DAB HTTP :5001, proves the MCP handshake → GREEN

Optional (only if the demo has been built)

Demo 4 (add-a-tool) proc: if build/sql/ gains the BOM proc (uspGetProductBOM), deploy it with sqlcmd ... -i the same way as the view, then re-run verify-preflight.ps1. As of last edit this is pending a design decision — skip unless present.

Do NOT

Install SQL Server, .NET, or sqlcmd — setup.ps1 checks and reports; it does not provision the host.
Go live (start-mcp-http.ps1) or drive the demos here — that's run-sqlmcpserver-demos. This skill leaves a validated, verified environment.
Author slides.

Done =

setup.ps1 completed and verify-preflight.ps1 is all green (504 products, view = 14 for Touring-1000, dab validate passes, DAB ≥ 2.0.9). Hand off to run-sqlmcpserver-demos (which runs start-mcp-http.ps1 and drives the beats).

build-sqlmcpserver-demo

Source facts

Install options

Review the source files

More from this repository

More from this repository

Build the SQL MCP Server demo environment

Prereqs to check first (do NOT try to install these — stop and tell the presenter if missing)

Build procedure — one command

Verify — one command

MCP surface + registration (HTTP)

Optional (only if the demo has been built)

Do NOT

Done =

Build the SQL MCP Server demo environment

Prereqs to check first (do NOT try to install these — stop and tell the presenter if missing)

Build procedure — one command

Verify — one command

MCP surface + registration (HTTP)

Optional (only if the demo has been built)

Do NOT

Done =