MCP.so
登录

Jewei Mssql Mcp Server

@jeweis

代码仓库

关于 Jewei Mssql Mcp Server

这是一个mssql MCP服务器，专门用于执行Microsoft SQL Server的数据查询和表结构查询操作。该服务器提供了一系列工具，使客户端能够方便地与SQL Server数据库进行交互。

#mssql#sqlserver#database

基本信息

分类

数据库

传输方式

stdio

发布者

jeweis

提交者

jewei

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "jewei-mssql": {
      "command": "uvx",
      "args": [
        "jewei-mssql-mcp-server"
      ],
      "env": {
        "DB_HOST": "<your_db_host>",
        "DB_USER": "<your_db_user>",
        "DB_PASSWORD": "<your_db_password>",
        "DB_NAME": "<your_db_name>",
        "DB_PORT": "<your_db_port>"
      }
    }
  }
}

工具

3

执行SQL查询并返回结果集（仅支持SELECT语句） Args: sql: SQL查询语句（必须是SELECT语句，） Returns: 包含查询结果的字典，格式为： { "columns": [列名列表], "rows": [行数据列表], "row_count": 结果行数 }

获取指定表的结构信息 Args: table_name: 表名 schema: 架构名，默认为dbo Returns: 包含表结构信息的字典，格式为： { "columns": [列信息列表], "primary_keys": [主键列表], "foreign_keys": [外键信息列表], "indexes": [索引信息列表] }

列出数据库中的所有表 Args: schema: 架构名，默认为dbo Returns: 包含表列表的字典，格式为： { "tables": [表信息列表], "count": 表数量 }

概览

What is Jewei Mssql Mcp Server?

Jewei Mssql Mcp Server is a Model Context Protocol (MCP) server that enables AI assistants and IDEs to interact with Microsoft SQL Server databases. It is intended for developers using MCP-compatible clients who need to query or manage MSSQL databases through natural language or tool calls.

How to use Jewei Mssql Mcp Server?

Configure the server in your client's MCP settings file using the uvx command with the package name jewei-mssql-mcp-server. Provide environment variables for your database connection: DB_HOST, DB_USER, DB_PASSWORD, DB_NAME, and DB_PORT. Supported clients include Windsurf, Cursor, Claude, and Cline.

Key features of Jewei Mssql Mcp Server

  • Supports multiple MCP-compatible clients (Windsurf, Cursor, Claude, Cline)
  • Configured via standard environment variables for database credentials
  • Uses the uvx command for simple installation and execution
  • Connects to any accessible Microsoft SQL Server instance

Use cases of Jewei Mssql Mcp Server

  • Query MSSQL databases from AI-powered IDEs and chat tools
  • Execute database operations using natural language prompts
  • Integrate SQL Server access into automated development workflows

FAQ from Jewei Mssql Mcp Server

What clients are supported?

Windsurf, Cursor, Claude, and Cline are supported with explicit configuration examples in the README.

What environment variables are required?

You must set DB_HOST, DB_USER, DB_PASSWORD, DB_NAME, and DB_PORT to connect to your SQL Server instance.

How is the server installed?

The server is run via the uvx command with the package name jewei-mssql-mcp-server; no manual installation steps are described.

—

—

—

—

评论

数据库 分类下的更多 MCP 服务器

mcp-server-duckdb

ktanaka101

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities

177

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

MCP Server for Milvus

zilliztech

Model Context Protocol Servers for Milvus

235

mcp_mysql_server

wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617