Mcp Sqlserver
Schema-aware read/write access to SQL Server through Devart dotConnect ADO.NET data provider.
- Transport
- Not stated
- Package
- —
- Registry id
- com.devart/mcp-sqlserver
No install snippet on purpose. A working MCP config is a command, its arguments and an environment block — the last two are where API keys live, so this catalogue never stores them and cannot publish them. Follow the link above for the authors' own instructions.
Devart MCP Server for SQL Server
Devart MCP Server for SQL Server enables AI clients to interact with your data through a secure server running in your environment. It turns a regular AI chat into a practical way to work with real-world business data — and it is faster than conventional export or manual querying.
Key benefits
Devart MCP Server for SQL Server allows you to:
- Work with data intuitively through natural language.
- Retrieve the required data for analysis within minutes.
- Report on your data faster with AI-powered assistance.
- Minimize manual data handling and integration maintenance.
How it works
Devart MCP Server for SQL Server helps AI clients communicate directly with SQL Server databases using natural-language prompts. It translates AI requests into structured queries, executes them through Devart connectivity drivers, and returns clean, structured results for seamless AI-powered data access.
Quick start
To get started with Devart MCP Server for SQL Server:
1. Download and install Devart ODBC Driver for SQL Server.
2. Download and install Devart MCP Server for SQL Server.
3. In Devart MCP Server for SQL Server, configure your data connection and integration settings.
4. Run your first natural-language query.
Manual installation and configuration
Prerequisites
Before building and running Devart MCP Server for SQL Server, ensure the following components are installed:
- .NET 8 SDK
- ADO.NET connection — Devart.AI.McpServer.AdoNet.SqlServer.csproj Devart dotConnect for SQL Server (installed automatically via NuGet during build)
- ODBC connection — Devart.AI.McpServer.Odbc.SqlServer.csproj Devart ODBC Driver for SQL Server (requires manual download and installation)
Step 1: Clone the repository
Clone the project repository and navigate to the project directory:
1. Open Command Prompt.
2. Enter the following command:
git clone https://github.com/devart-ai-connectivity/devart-mcp-server-sqlserver.git
cd devart-mcp-server-sqlserver
Step 2: Build the MCP Server from source
You can build Devart MCP Server for SQL Server from source using either of the supported database connectivity technologies: ADO.NET or ODBC.
- To build the MCP server with ADO.NET, run the following command:
dotnet publish Devart.AI.McpServer.AdoNet/Devart.AI.McpServer.AdoNet.SqlServer/Devart.AI.McpServer.AdoNet.SqlServer.csproj -c ReleaseSqlServer /p:TargetFramework=net8.0
The Devart dotConnect for SQL Server NuGet package is downloaded and restored automatically.
- To build the MCP server with ODBC, select the command based on the bitness of your data source.
For 64-bit data source, run the following command:
dotnet publish Devart.AI.McpServer.Odbc/Devart.AI.McpServer.Odbc.SqlServer/Devart.AI.McpServer.Odbc.SqlServer.csproj -c ReleaseSqlServer -r "win-x64" /p:TargetFramework=net8.0
For 32-bit data source, run the following command:
From the project's README.