Devart MCP Server for SQL Server (ADO.NET) — MCP server
Connects AI assistants to SQL Server databases via the Devart dotConnect data provider. It translates natural language prompts into queries to inspect schemas and read or update records.
Open on GitHubWhat Devart MCP Server for SQL Server (ADO.NET) does
This server acts as a bridge between LLM tools and SQL Server databases. Built on Devart dotConnect for SQL Server, it processes natural-language instructions, turns them into database queries, and passes structured records back to the model. The ADO.NET edition pulls its required NuGet dependencies automatically when compiled with the .NET 8 SDK.
Database credentials and transport parameters live in an mcpserver.json file. Connections run over standard I/O or http. Because Devart drivers enforce licensing, a valid License Key parameter inside the connection string is strictly required for the server to operate. When configured for http, the server must be launched manually with Devart.AI.McpServer.AdoNet.SqlServer.exe run <connection_name>.
What it helps with
- query and mutate SQL Server records directly from AI chat sessions
- inspect database schema definitions and relationships without manual SQL scripts
- extract business data reports through plain text instructions
- interface with local or remote SQL Server instances over stdio or http
Example prompts for the agent
- Show the 10 most recent orders from the Orders table where status is Delivered
- Inspect the schema of the Customers table and list all foreign keys
- Calculate total revenue for the previous month in the my_sqlserver database
How to install Devart MCP Server for SQL Server (ADO.NET)
Install
The MCP registry has no launch command for it: see the repository README
Step by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about Devart MCP Server for SQL Server (ADO.NET)
How to install Devart MCP Server for SQL Server (ADO.NET)?
Clone the repository using git clone https://github.com/devart-ai-connectivity/devart-mcp-server-sqlserver.git and compile the code with `dotnet publish Devart.AI.McpServer.AdoNet/Devart.AI.McpServer.AdoNet.SqlServer/Devart.AI.McpServer.AdoNet.SqlServer.csproj -c ReleaseSqlServer /p:TargetFramework=net8.0. Add an mcpserver.json` configuration file next to the binary and register it inside your MCP client settings.
What does Devart MCP Server for SQL Server (ADO.NET) do?
It gives AI assistants schema-aware read and write access to Microsoft SQL Server. The server translates conversational instructions into database commands using the Devart dotConnect provider.
What is required to run this ADO.NET server?
You need the .NET 8 SDK to build the binary and an active License Key specified in the connection string. Nuget packages download automatically during the build step.
