Mcp Sqlserver

Name: Mcp Sqlserver
Author: bilims

@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.

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

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_mysql_server

wenb1n-dev

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

245