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.

Ir a la instalación

Repositorio: microsoft/bobsql
Última actividad en el origen: 27 de julio de 2026 a las 22:26
Idioma detectado de SKILL.md: inglés
Estrellas: 317
Forks: 170

Opciones de instalación

De forma predeterminada está seleccionado el prompt que primero revisa el origen. Puedes cambiar a un comando directo o descargar una copia local.

Instalar con Codex o Claude Copia este prompt, pégalo en Codex, Claude u otro asistente, y deja que revise la página de la skill y la instale por ti.

Un comando directo omite el prompt de revisión. Revisa el origen antes de ejecutarlo.

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

El comando permanece en una sola línea. Desplázate horizontalmente para revisarlo antes de copiarlo.

¿Prefieres una copia local? Descarga los archivos que SkillsMP tiene disponibles ahora.

Revisa los archivos de origen

Lee SKILL.md y los archivos complementarios que muestra SkillsMP antes de decidir si quieres instalarlo.

SKILL.md

Instrucciones de origen · Vista previa de solo lectura

Volver a la búsqueda Volver a la instalación

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

Ver todos los de este repositorio

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

Datos de origen

Opciones de instalación

Revisa los archivos de origen

Más de este repositorio

Más de este repositorio

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 =