drio
Open app

SQL Server Express MCP Server

Source

MCP server for interacting with SQLExpress

Catalog onlyCatalog onlySTDIO

Overview

MCP SQL Server Express is a server designed for interacting with Microsoft SQL Server Express, providing a streamlined interface for database management.

To use MCP SQL Server Express, clone the repository, set up a virtual environment, install dependencies, and configure it with your SQL Server instance.

  • Supports both Windows and SQL Server authentication. - Tools for executing queries, creating tables, and managing databases. - Ability to list allowed databases and describe table schemas.
  1. Managing SQL Server databases in a development environment.
  2. Executing complex SQL queries through a simplified interface.
  3. Automating database management tasks in applications.

Add to your AI client

Use these steps to connect SQL Server Express MCP Server in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.

Cursor

Add this to your .cursor/mcp.json file in your project root, then restart Cursor.

.cursor/mcp.json

{
  "mcpServers": {
    "mcp-sqlexpress-hanweg": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-sqlexpress-hanweg"
      ]
    }
  }
}

Claude Desktop

Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.

~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

{
  "mcpServers": {
    "mcp-sqlexpress-hanweg": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-sqlexpress-hanweg"
      ]
    }
  }
}

Claude Code

Add this to your project's .mcp.json file. Claude Code will detect it automatically.

.mcp.json (project root)

{
  "mcpServers": {
    "mcp-sqlexpress-hanweg": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-sqlexpress-hanweg"
      ]
    }
  }
}

VS Code (Copilot)

Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.

.vscode/mcp.json

{
  "servers": {
    "mcp-sqlexpress-hanweg": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-sqlexpress-hanweg"
      ]
    }
  }
}

Windsurf

Add this to your Windsurf MCP config file, then restart Windsurf.

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "mcp-sqlexpress-hanweg": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-sqlexpress-hanweg"
      ]
    }
  }
}

Cline

Open Cline settings, navigate to MCP Servers, and add this server configuration.

Cline MCP Settings (via UI)

{
  "mcpServers": {
    "mcp-sqlexpress-hanweg": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-sqlexpress-hanweg"
      ]
    }
  }
}

FAQ

What are the prerequisites for using MCP SQL Server Express?

You need Python 3.10 or higher and the Microsoft ODBC Driver 18 for SQL Server.

Is MCP SQL Server Express free to use?

Yes! It is open-source and free to use.

Can I use it with any SQL Server instance?

Yes, as long as you have the appropriate permissions and configurations.7:["$","div",null,{"className":"container mx-auto flex flex-col gap-4","children":["$L26","$L27",["$","$L28",null,{"currentProject":{"id":1552,"uuid":"55b7d1ed-5593-437a-8054-928662208ac7","name":"mcp-sqlexpress","title":"SQL Server Express MCP Server","description":"MCP server for interacting with SQLExpress","avatar_url":"https://avatars.githubusercontent.com/u/140543700?v=4","created_at":"2025-02-20T23:18:53.508Z","updated_at":"2025-02-23T07:19:15.438Z","status":"created","author_name":"hanweg","author_avatar_url":"https://avatars.githubusercontent.com/u/140543700?v=4","tags":"mcp-sqlexpress,sql-server,database-interaction","category":"developer-tools","is_featured":false,"sort":1,"url":"https://github.com/hanweg/mcp-sqlexpress","target":"_self","content":"$29","summary":"$2a","img_url":null,"type":null,"metadata":null,"user_uuid":null,"tools":null,"sse_url":null,"sse_provider":null,"sse_params":null,"is_official":false,"server_command":null,"server_params":null,"server_config":null,"allow_call":false,"is_innovation":false,"is_dxt":false,"dxt_manifest":null,"dxt_file_url":null,"is_audit":false},"randomProjects":[],"currentServerKey":"$undefined"}]]}]

Developer tools
SQL Server Express MCP Server — MCP Registry