MCP.so
登录
M

Mcp Sqlserver

@bilims

代码仓库

关于 Mcp Sqlserver

暂无概览

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

基本信息

分类

数据库

传输方式

stdio

发布者

bilims

提交者

Onur Keskin, Ph.D.

配置

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

FAQ from Mcp Sqlserver

What are the runtime requirements?

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

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.

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.

Which transports are supported?

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

What is the maximum number of tools available?

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

评论

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

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

mcp_mysql_server

xwb602625136

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

245

Meilisearch MCP Server

meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.

193