广告合作
MCP.so
登录
M

MCP Sqlserver

@bilims

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

bilims

提交者

Onur Keskin, Ph.D.

关于 MCP Sqlserver

暂无概览

#mcp-sqlserver#sql-server#database-management

MCP Sqlserver 配置

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

{
  "mcpServers": {
    "mcp-sqlserver": {
      "command": "npx",
      "args": [
        "-y",
        "@bilims/mcp-sqlserver"
      ],
      "env": {
        "SQLSERVER_HOST": "your-server-host",
        "SQLSERVER_DATABASE": "your-database",
        "SQLSERVER_USERNAME": "your-username",
        "SQLSERVER_PASSWORD": "your-password"
      }
    }
  }
}

MCP Sqlserver 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is Mcp Sqlserver?

Mcp Sqlserver is a Model Context Protocol (MCP) server that enables AI agents to securely interact with Microsoft SQL Server databases. It provides CRUD operations, schema introspection, stored procedure execution, transaction management, and bulk operations for production environments.

How to use Mcp Sqlserver?

Install and configure via NPX (recommended), global npm installation, or from source. Create a .env file with SQL Server credentials and add the server configuration (command, args, env) to your Claude Desktop MCP settings (claude_desktop_config.json). The server exposes 22 tools accessible from any MCP‑compatible client.

Key features of Mcp Sqlserver

  • Complete CRUD operations (SELECT, INSERT, UPDATE, DELETE)
  • Schema introspection for databases, tables, columns, and indexes
  • Stored procedure execution with parameters and multiple result sets
  • Transaction management with isolation levels and savepoints
  • High‑performance bulk insert, batch update/delete, and CSV/JSON import
  • All queries use parameterized inputs to prevent SQL injection

Use cases of Mcp Sqlserver

  • AI‑powered data analysis and reporting on SQL Server databases
  • Automated database maintenance and schema exploration
  • Intelligent application backends that query and modify data on demand
  • Bulk data loading and transformation tasks via AI agents
  • Secure, controlled database operations within MCP‑compatible chat assistants

常见问题

1

What are the runtime requirements?

Node.js 20+, TypeScript 5.0+, and Microsoft SQL Server 2016+ are required.

2

How is data kept secure?

All queries use parameterized inputs to prevent SQL injection, DDL operations are blocked in custom queries, and connections include validation, health checks, and timeout controls.

3

Where does the server store configuration?

Database credentials and connection pool settings are stored in a `.env` file or passed as environment variables in the MCP client configuration.

4

Which transports are supported?

The server uses the standard MCP transport. It is designed for use with Claude Desktop and any MCP‑compatible client.

5

What is the maximum number of tools available?

22 tools are provided, covering core database operations, stored procedures, transaction management, and bulk operations.

评论

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

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

Database Gateway

centralmind

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

531

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

广告合作