Jewei Mssql Mcp Server

Name: Jewei Mssql Mcp Server
Author: jeweis

@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>"
      }
    }
  }
}

ツール

执行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.

—

「データベース」の他のコンテンツ

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

MCP MongoDB Server

kiliczsh

A Model Context Protocol Server for MongoDB

281

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K