SQL Server MCP Server for Claude Code

@shakunvohradeltek

代码仓库

基本信息

分类

数据库

许可证

MIT license

传输方式

stdio

作者

shakunvohradeltek

关于 SQL Server MCP Server for Claude Code

MS SQL Server - MCP for Claude-Code

#sqlserver #mcp #database-integration

SQL Server MCP Server for Claude Code 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "SQLServer-MCP": {
      "command": "python3",
      "args": [
        "run_mssql_mcp.py"
      ]
    }
  }
}

SQL Server MCP Server for Claude Code 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

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

概览

What is SQL Server MCP Server for Claude Code?

SQL Server MCP Server for Claude Code is an MCP server that gives Claude Code the ability to directly query Microsoft SQL Server databases. It uses FreeTDS under the hood for cross-platform compatibility and is aimed at developers who work with SQL Server and want to query it interactively inside a Claude Code session.

How to use SQL Server MCP Server for Claude Code?

Install by cloning the repository and running the provided shell script (./install_mssql_mcp_clean.sh). Then run ./configure_mcp.sh to enter your server hostname/port, database name, username, and password. After setup, invoke SQL queries in Claude Code with mcp__mssql__execute_sql(query="SELECT ...").

Key features of SQL Server MCP Server for Claude Code

Enables Claude Code to run SQL queries directly against Microsoft SQL Server
Cross-platform support: Linux, macOS, and Windows (via WSL)
Uses FreeTDS for broad SQL Server compatibility
Database credentials stored only in the local .mcp.json file
Automatic temporary file management and cleanup per query

Use cases of SQL Server MCP Server for Claude Code

List all tables in a database
Count records in a table
Query data with filtering conditions (e.g., WHERE City='London')
Explore database schema during a Claude Code session

常见问题

What are the prerequisites?

Python 3.8 or higher, FreeTDS (installed by the setup script), a SQL Server instance accessible from your machine, and a Linux, macOS, or Windows (via WSL) operating system.

How does the query execution work?

Claude sends a `CallToolRequest` to the MCP server. The server creates a temporary SQL file, executes it with FreeTDS's `tsql` utility, parses the results into structured JSON, and cleans up the temporary files.

Where are database credentials stored?

Credentials are stored locally in the `.mcp.json` configuration file, which is created during the `configure_mcp.sh` setup. They are never sent as part of prompts.

What transport protocol does this server use?

The server uses the stdio transport protocol, as defined by the `"type": "stdio"` entry in the `.mcp.json` configuration.

How can I test the connection?

Run `./test_tsql.sh` to verify that FreeTDS can connect to your SQL Server with the provided credentials. You can also run `tsql -C` to check the FreeTDS installation itself.

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

MySQL MCP Server

designcomputer

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

1.3K

Dbhub

bytebase

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

3.1K

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

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

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.