Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type @ followed by the MCP server name and your instructions, e.g., "@SQL MCP Server Demo What's the average salary by department?"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
This repository implements a local Model Context Protocol (MCP) server for SQL Server using Microsoft Data API Builder (DAB) 2.0. It exposes read-only data access tools (describe_entities, read_records, and aggregate_records) to a local Ollama model (qwen3:8b) via a Python MCP client and Streamlit frontend.
A:\sql-mcp-demo
│ .env.example - Template environment variables
│ .gitignore - Configured git ignore rules
│ README.md - Project documentation
│ requirements.txt - Python dependencies
│ mcp_client.py - Python MCP Client and LLM function calling loop
│ app.py - Streamlit frontend UI
│ test_ollama.py - Verifies basic connection to Ollama
│ test_tools.py - Verifies tool-calling capability of qwen3:8b
│
├── .venv/ - Python virtual environment
│
├── dab/
│ └── dab-config.json - Schema-valid Data API Builder configuration
│
├── database/
│ └── verify.sql - Reference SQL database queries
│
└── scratch/ - Developer tests and verification scriptsRelated MCP server: MSSQL MCP Reader
┌──────────────────────┐
│ Streamlit UI │
│ app.py │
└──────────┬───────────┘
│ User Query
▼
┌──────────────────────┐
│ Qwen3:8B │
│ Ollama │
└──────────▲───────────┘
│ Function Call
│ Negotiation
▼
┌──────────────────────┐
│ MCP Client │
│ mcp_client.py │
└──────────┬───────────┘
│
│ MCP HTTP (Streamable HTTP)
▼
┌──────────────────────┐
│ Data API Builder │
│ SQL MCP Server │
│ localhost:5000/mcp │
└──────────┬───────────┘
│
│ SQL Connection
▼
┌──────────────────────┐
│ SQL Server LocalDB │
│ EmployeeDB │
│ └── dbo.Employee │
└──────────────────────┘Follow these steps to start and run the application:
Ensure your local SQL Server instance and Ollama are running:
sqllocaldb start MSSQLLocalDB
ollama run qwen3:8bOpen a terminal, activate your virtual environment, and run the DAB server:
# Navigate to workspace
cd A:\sql-mcp-demo
# Activate environment
.venv\Scripts\activate
# Start DAB MCP Server
C:\Users\kamal\.dotnet\tools\dab.exe start --config .\dab\dab-config.jsonThe server will start listening at http://localhost:5000/mcp.
Open a second terminal window and launch the frontend dashboard:
# Navigate to workspace
cd A:\sql-mcp-demo
# Activate environment
.venv\Scripts\activate
# Launch Streamlit
streamlit run app.pyThis will open the dashboard in your web browser at http://localhost:8501.
To test the tool negotiation loop directly via the command-line client:
python mcp_client.pytest_ollama.py: Verifies connection to Ollama.
test_tools.py: Verifies basic tool selection capability.
scratch/test_all_queries.py: Runs a batch of 7 validation queries testing counts, filters, averages, group-bys, and sort conditions.
A critical schema validation issue in Microsoft's Data API Builder v2.0.9 was addressed:
The standard DAB schema validator contains a bug where defining "mcp" at the entity level for table types incorrectly triggers a stored-procedure constraint (requiring source.type to be stored-procedure).
This was resolved by removing the redundant entity-level "mcp" block since MCP capability is already configured globally at the runtime level.
This server cannot be deployed
Safe, read-only Postgres and MySQL access for AI agents. Audit log + column-level controls.
Read public AT Protocol profiles, records, threads, backlinks and lexicons. No API key required.
Read-only MCP server for ClassQuill, a tutoring-business-management platform.
Read-only finance and operations controls for AI agents with evidence and safe next actions.
