広告掲載
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.

コメント

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

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

Dbhub

bytebase

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

3.1K

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

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

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

広告掲載