Copilot SQL MCP POC

Proof of concept for answering business questions over local SQL Server WideWorldImporters data through MCP.

Current Milestone

Milestone 5: local Streamable HTTP MCP server.

Status:

• Legacy Cursor implementation preserved in legacy/.

• Shared app package created.

• STDIO entry point added as server_stdio.py.

• Existing MCP tool names preserved.

• Existing Cursor MCP App resource URI preserved.

• Data dictionary copied from the legacy implementation.

• Cursor renderer copied from the legacy implementation.

• Unit tests added for SQL validation and result handling.

• Shared VisualResponse model added.

• Cursor visual results now pass through the neutral model.

• Cursor renderer can normalize visual_response payloads.

• SQL remains excluded from public visual response payloads.

• Adaptive Card renderer added for KPI, bar, horizontal bar, line, pie, doughnut, table, and fallback outputs.

• Copilot-facing output helper added with business result, Adaptive Card, and fallback text.

• Streamable HTTP entry point added as server_http.py.

• /health endpoint added.

• MCP HTTP endpoint defaults to /mcp.

• Manual Cursor acceptance questions verified against live SQL Server.

Related MCP server: SqlAugur

Local STDIO Server

Run the refactored Cursor-compatible MCP server with:

python server_stdio.py

Local Streamable HTTP Server

Run the local HTTP MCP server with:

python server_http.py

Defaults:

• host: 0.0.0.0

• port: 8000, or PORT if set

• MCP endpoint: /mcp, or MCP_HTTP_PATH if set

• health endpoint: /health

Example health URL:

http://localhost:8000/health

The original working implementation remains available at:

legacy/sqlserver_mcp_wwi_cursor_apps_business.py

Configuration

The refactored server keeps the legacy local defaults:

• SQLSERVER_HOST, default 050027346-3

• SQLSERVER_DB, default WideWorldImporters

• SQLSERVER_USER, optional

• SQLSERVER_PASS, optional legacy password variable

• SQLSERVER_PASSWORD, optional preferred password variable

• SQLSERVER_DRIVER, default ODBC Driver 17 for SQL Server

If no SQL user/password is provided, the connection uses Windows trusted authentication, matching the legacy Cursor setup.

Local state files default to the legacy/ directory for compatibility:

• mcp_memory.txt

• mcp_pending_suggestions.txt

• mcp_queries.log

Override that directory with MCP_STATE_DIR if needed.

Tests

The current tests use the Python standard library and do not require a live SQL Server:

python -m unittest discover -s tests -p "test_*.py" -v

Manual Cursor and SQL Server acceptance checks are listed in docs/acceptance_tests.md.

The shared visual contract is summarized in docs/visual_contract.md. Adaptive Card rendering notes are in docs/adaptive_card_examples.md. Local HTTP setup notes are in docs/local_http.md.