广告合作
MCP.so
登录

Jewei Mssql MCP Server

@jeweis

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

jeweis

提交者

jewei

关于 Jewei Mssql MCP Server

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

#mssql#sqlserver#database

Jewei Mssql MCP Server 配置

使用下面的配置,将此服务器添加到你的 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>"
      }
    }
  }
}

Jewei Mssql MCP Server 工具

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

常见问题

1

What clients are supported?

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

2

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.

3

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 服务器

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

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 DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818
广告合作