drio
Open app

MS SQL MCP Server 1.1

Source

MCP server for MS SQL Server

Catalog onlyCatalog onlySTDIO

Overview

Mssql Mcp Server is an easy-to-use bridge that allows AI assistants like Claude to directly query and explore Microsoft SQL Server databases without requiring any coding experience.

To use Mssql Mcp Server, simply set up the server and connect it to your Microsoft SQL Server database. You can then interact with the database through your AI assistant.

  • No coding experience required for querying databases. - Direct integration with AI assistants for seamless data exploration. - User-friendly interface for managing database queries.
  1. Enabling non-technical users to access and query SQL databases.
  2. Assisting data analysts in exploring data through natural language queries.
  3. Facilitating quick data retrieval for AI-driven applications.

Add to your AI client

Use these steps to connect MS SQL MCP Server 1.1 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": {
    "mssql-mcp-server-dperussina": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mssql-mcp-server-dperussina"
      ]
    }
  }
}

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": {
    "mssql-mcp-server-dperussina": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mssql-mcp-server-dperussina"
      ]
    }
  }
}

Claude Code

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

.mcp.json (project root)

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

VS Code (Copilot)

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

.vscode/mcp.json

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

Windsurf

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

~/.codeium/windsurf/mcp_config.json

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

Cline

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

Cline MCP Settings (via UI)

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

FAQ

Can I use Mssql Mcp Server with any SQL Server version?

Yes! Mssql Mcp Server is compatible with various versions of Microsoft SQL Server.

Is there any coding required to use Mssql Mcp Server?

No! Mssql Mcp Server is designed for users without coding experience.

What kind of AI assistants can I use with Mssql Mcp Server?

You can use any AI assistant that supports integration with external databases, such as Claude.7:["$","div",null,{"className":"container mx-auto flex flex-col gap-4","children":["$L26","$L27",["$","$L28",null,{"currentProject":{"id":1972,"uuid":"3a899f15-b8ef-4f07-a46a-012974686b7b","name":"mssql-mcp-server","title":"MS SQL MCP Server 1.1","description":"MCP server for MS SQL Server","avatar_url":"https://avatars.githubusercontent.com/u/379170?v=4","created_at":"2025-03-05T07:37:32.582Z","updated_at":"2025-03-12T10:21:48.133Z","status":"created","author_name":"dperussina","author_avatar_url":"https://avatars.githubusercontent.com/u/379170?v=4","tags":"[]","category":"developer-tools","is_featured":false,"sort":1,"url":"https://github.com/dperussina/mssql-mcp-server","target":"_self","content":"$29","summary":"$2a","img_url":null,"type":null,"metadata":"{\"star\":\"26\",\"license\":\"GPL-3.0 license\",\"language\":\"JavaScript\",\"is_official\":false,\"latest_commit_time\":\"2025-05-08 06:44:45\"}","user_uuid":"ce1f9d3b-1c35-447b-a299-5b97eb893761","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