SQL Server Express MCP Server

@hanweg

リポジトリ

基本情報

カテゴリ

開発者ツール

ライセンス

MIT

トランスポート

stdio

作者

hanweg

SQL Server Express MCP Server について

MCP server for interacting with SQLExpress

#mcp-sqlexpress#sql-server #database-interaction

SQL Server Express MCP Server の設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

SQL Server Express MCP Server のツール

Get list of databases that are allowed to be accessed

Execute SELECT queries

Execute INSERT/UPDATE/DELETE queries

Create new tables

List all tables in database

Show table schema

概要

What is SQL Server Express MCP Server?

An MCP server for interacting with Microsoft SQL Server Express. It supports both Windows and SQL Server authentication and is intended for use with AI assistants like Claude Desktop.

How to use SQL Server Express MCP Server?

Clone the repository, create and activate a Python virtual environment using uv, install dependencies, then configure claude_desktop_config.json with the appropriate --server, --auth, and optional --username/--password flags. For Windows authentication use --auth windows --trusted-connection yes; for SQL authentication use --auth sql and supply credentials.

Key features of SQL Server Express MCP Server

Execute SELECT, INSERT, UPDATE, DELETE queries
Create new tables
List and describe tables
Restrict access to allowed databases
Supports Windows and SQL Server authentication

Use cases of SQL Server Express MCP Server

Querying SQL Server databases through an AI assistant
Managing table schemas without direct database tools
Securely integrating SQL Server with MCP-compatible applications

よくある質問

What authentication methods are supported?

The server supports Windows Authentication (`--auth windows`) and SQL Server Authentication (`--auth sql`). SQL authentication requires a username and password.

What are the prerequisites?

Python 3.10 or higher, Microsoft ODBC Driver 18 for SQL Server, and a SQL Server instance with appropriate permissions.

How do I restrict which databases can be accessed?

Use the `--allowed-databases` flag and provide a comma-separated list of database names (e.g., `database1,database2`).

Can I run custom queries other than SELECT?

Yes. The `write_query` tool executes INSERT, UPDATE, and DELETE queries, and the `create_table` tool creates new tables.

Does the server support certificate trust?

Yes, use the `--trust-server-certificate yes` flag to trust the server certificate without validation.

「開発者ツール」の他のコンテンツ

ArtiBot Cloud MCP - Zhijiangyun 智匠云

bofob

ArtiBot Cloud MCP (Zhijiangyun 智匠云) — cloud MCP server for robot manipulation data & GPU workloads. 15 tools: robot fleet management, data collection & video recording, post-processing pipelines, and benchmark evaluation

LocalCan

Gives AI agents public URLs (tunnels) for localhost, live HTTP traffic inspection, snapshot publishing, and access control. Part of LocalCan, the ngrok alternative for Mac, Windows and Linux. Free plan.

Leadpages MCP

Leadpages

Leadpages MCP is a remote MCP server available at https://mcp.leadpages.com.

Foremerge

naw103

Catch intent conflicts before code conflicts. The open-source coordination protocol for coding agents, built above Git.

FARPY

mangomunchr

Verified distributed compute for humans, applications, and agents. Submit Blender, Octane, and video workloads, route them across qualified GPUs, track asynchronous execution, download finished artifacts, and verify FARP