# Devart MCP Server for SQL Server (ADO.NET)

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.

- MCP server · `type=mcp` · Claude Code, Codex, Cursor, GitHub Copilot, Windsurf (Devin Desktop), Cline, Zed
- Author: devart-ai-connectivity
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/devart-ai-connectivity/devart-mcp-server-sqlserver
- Updated: 2026-09-03
- HTML: https://affpapa.org/en/nevibecode/mcp/devart-mcp-server-for-sql-server-adonet

## What it 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>`.

## Requirements
- Environment variables: `DEVART_MCP_SQLSERVER_CONNECTION` — keys and tokens: ask the human for the values, never commit them or put them in shared files.

## Install

### Claude Code (native platform)

**Install**
- The MCP registry has no launch command for it: see the repository README

## When to use it
- 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
- 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

## Similar
- [World Monitor](https://affpapa.org/en/nevibecode/mcp/world-monitor.md) — MCP server · ★ 89609
- [Scrapling MCP Server](https://affpapa.org/en/nevibecode/mcp/scrapling-mcp-server.md) — MCP server · ★ 89899
- [MCP Toolbox for Databases](https://affpapa.org/en/nevibecode/mcp/googleapis-mcp-toolbox-for-databases.md) — MCP server · ★ 16730
- [PostHog MCP Server](https://affpapa.org/en/nevibecode/mcp/posthog-mcp-server.md) — MCP server · ★ 40459
- [dbx](https://affpapa.org/en/nevibecode/mcp/dbx.md) — MCP server · ★ 27844
- [Metabase](https://affpapa.org/en/nevibecode/mcp/metabase.md) — MCP server · ★ 49863

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md