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.

インストールへ移動

リポジトリ: microsoft/bobsql
ソースの最終更新活動: 2026年7月27日 22:26
検出された SKILL.md の言語: 英語
スター: 317
フォーク: 170

インストール方法

デフォルトでは、最初にソースを確認する Prompt が選択されています。直接コマンドに切り替えるか、ローカルコピーをダウンロードすることもできます。

Codex または Claude でインストールこの Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。

直接コマンドでは確認用 Prompt が省略されます。実行前にソースを確認してください。

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

コマンドは1行のまま表示されます。コピー前に横へスクロールして全体を確認してください。

ローカルで確認しますか？SkillsMP が現在取得できるファイルをダウンロードできます。

ソースファイルを確認

インストールを決める前に、SKILL.md と SkillsMP に表示されている付属ファイルをお読みください。

SKILL.md

ソースの指示 · 読み取り専用プレビュー

検索に戻るインストールに戻る

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

このリポジトリのすべてを見る

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

ソース情報

インストール方法

ソースファイルを確認

このリポジトリの他の Skills

このリポジトリの他の Skills

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 =