广告合作
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 服务器

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531

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
广告合作