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.

开发工具分类下的更多 MCP 服务器

Capgo MCP

Cap-go

Console, Backend and CLI to manage Capgo Instant update and Native build for Capacitor apps Build and upload to app store your mobile app

Mythex

Remote MCP server for Mythex, an AI app builder. Claude, Cursor or Codex get a cloud sandbox to build full-stack apps: files and bash, live preview, Postgres database, file storage, secrets, checkpoints, browser tests an

Heard

Let your cloud agents talk to you. Grok Bot, Meta Muse, ChatGPT, Claude, Devin and others report progress to Heard, which reads it out loud on your Mac, and they pick up the replies you send back.

Yocoolab

MCP server for AI Agents — exposes Yocoolab feedback threads and design selections as tools

Casefile

azimov777

One case file per task — shared by every session, agent and person that touches it. Self-hosted MCP server and live board. MIT.