SQL Server MCP (Windows)

Name: SQL Server MCP (Windows)
Author: TharanaBope

作者：TharanaBope版本 1.0.4i★ –i在你的电脑上运行

注册名称io.github.TharanaBope/sql-server-mcp

安装

概览

作者提供的说明（英文原文）

SQL Server MCP with RAG capabilities for Windows (native ODBC support)

PopNx MCP 的三大支柱

这三项永远不会合并成一个分数：意见、测量和人气是不同的东西。

用户评价i暂无评价评价功能将在后续阶段与账户功能一起开放
我们的基础检查i1 项中通过 1 项依据公开信息检查；尚未扫描代码
使用情况i非常新↓ 61/周 · ★ –

它能帮你做什么

我们还没有为它写通俗的介绍。下面是我们从注册中心读取到的事实。

连接方式: 在你的电脑上运行
传输方式: stdio
分类: 数据库与数据集

安装

选择你使用的 AI 应用，然后复制设置。

安装之前

基础检查：1 项中通过 1 项
在你的电脑上运行，拥有你的用户账户的权限（文件、网络、应用）。
注册中心没有列出需要填写的密钥。

你需要

npm已安装 Node.js（用于 npx 命令）

你用的是哪个应用？

ClaudeClaude CodeCursorVS CodeChatGPT

在上方选择你的应用。我们会记住它，下次按钮会显示“安装到 …”。

打开 Claude Desktop → Settings → Developer → Edit Config，把下面的内容粘贴到 claude_desktop_config.json

{
  "mcpServers": {
    "sql": {
      "command": "npx",
      "args": [
        "-y",
        "@tharanabopearachchi/sql-server-mcp"
      ]
    }
  }
}

在终端中运行这条命令

claude mcp add sql -- npx -y @tharanabopearachchi/sql-server-mcp

在 Cursor 中打开

或者自己复制设置

粘贴到项目中的 .cursor/mcp.json，或 ~/.cursor/mcp.json

{
  "mcpServers": {
    "sql": {
      "command": "npx",
      "args": [
        "-y",
        "@tharanabopearachchi/sql-server-mcp"
      ]
    }
  }
}

浏览器会先询问是否打开应用，然后应用会显示设置并请你确认。密钥的值会留空，由你自己填写。

在 VS Code 中打开

或者自己复制设置

粘贴到项目中的 .vscode/mcp.json

{
  "servers": {
    "sql": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@tharanabopearachchi/sql-server-mcp"
      ]
    }
  }
}

浏览器会先询问是否打开应用，然后应用会显示设置并请你确认。密钥的值会留空，由你自己填写。

这个服务器在你的电脑上运行，而 ChatGPT 只能连接互联网上的服务器。请选择其他应用。

你的选择通过 Cookie 保存在这台设备上，无需账户。

这些设置是根据作者在注册中心的条目生成的。如果 README 的写法不同，请以 README 为准。

它能做什么

它在你的电脑上运行；安装后，工具列表会显示在你的 AI 应用中。

基础检查i

我们检查的是任何人都能看到的信息；我们没有阅读代码。不适用的检查项不计入总数。 · 检查于 2026年11月9日

✓ 通过
作者与仓库一致
注册名称已通过 GitHub 账户 TharanaBope 验证，该账户拥有此仓库
… 尚未检查
仍在维护
我们还没有从 GitHub 读取这个仓库
… 尚未检查
有许可证
我们还没有从 GitHub 读取这个仓库
– 不适用
端点有响应
它在你的电脑上运行，没有互联网端点
– 不适用
使用 OAuth 登录
在你的电脑上运行，改用本地设置
… 尚未检查
工具描述中没有隐藏指令
它在你的电脑上运行；我们只能读取互联网端点的工具列表

与“数据库与数据集”中的其他服务器比较i

星标数多于此分类中其他 1152 个服务器的 0%
发布到注册中心的时间比此分类中其他 1152 个服务器的 10% 更新
基础检查结果等于或优于此分类中其他 1152 个服务器的 100%

与注册中心里这个分类中所有活跃的服务器比较。只有当发布者拥有该仓库时，星标数才计入。

常见问题

SQL Server MCP (Windows) 安全吗？

它在 1 项适用的基础检查中通过了 1 项。我们没有阅读代码。在添加密钥或令牌之前，请先看看这个服务器要求哪些权限，并使用只具备所需权限的密钥。

它需要哪些密钥或代码？

注册中心没有列出必需的密钥，不过有些服务器会在首次使用时要求你登录。

它在我的电脑上运行还是在云端？

它在你的电脑上运行。你的 AI 应用会在需要时启动它，数据不会经过作者的服务器（除非它自己调用在线服务）。

它还在维护吗？

GitHub 仓库最后更新于–，最新版本（1.0.4）于7个月前进入注册中心。

哪些应用可以使用它？

支持 MCP 的应用，例如 Claude Desktop、Claude Code、Cursor 和 VS Code。你的电脑上还需要有 Node.js。

有什么可以替代它？

同一分类中有：Supabase, MongoDB MCP Server, Elasticsearch MCP Server

替代选择

同一分类中其他作者的服务器，按星标数排序。

如何看卡片：↓ 每周下载量i★ GitHub 星标i三大支柱：评价 · 检查 · 使用情况i更新 = 最新版本发布到注册中心的时间i

Supabase

MCP server for interacting with the Supabase platform

作者：supabase广泛使用↓ 23.5万/周★ 29933天前更新

电脑或云端✓ supabase.com

安装

MongoDB MCP Server

MongoDB Model Context Protocol Server

作者：mongodb-js广泛使用↓ 15.7万/周★ 11574天前更新

在你的电脑上运行

安装

Elasticsearch MCP Server

MCP server for interacting with Elasticsearch

作者：cr7258正在增长↓ 2711/周★ 31514个月前更新

在你的电脑上运行

安装

作者的 README

打开 README

按原文从作者的仓库复制。PopNx MCP 没有审查或背书其内容。HTML、图片和脚本已被移除。链接会离开本站。

SQL Server MCP - Cross-Platform Database Integration for AI

A Model Context Protocol (MCP) server implementation for SQL Server that enables AI assistants to explore and query SQL Server databases through natural language. Built as a RAG (Retrieval-Augmented Generation) system optimized for database knowledge exploration.

🌟 Features

🔍 Schema Exploration - List databases, tables, views, stored procedures
🔗 Relationship Mapping - Discover foreign key relationships and table dependencies
🔎 Search & Discovery - Global schema search across tables, columns, procedures
⚡ Safe Query Execution - Read-only SELECT queries with automatic timeouts and row limits
🗄️ Schema Caching - Fast retrieval with configurable TTL (default: 60 minutes)
🔐 Security First - Read-only by default, SQL injection prevention, query validation
🖥️ Cross-Platform - Native Windows Authentication & macOS Docker support

🎥 Demo

See SQL Server MCP in action with AI assistant integration:

Note: Watch how natural language queries instantly explore database schemas, find relationships, and retrieve data - all without leaving your AI assistant!

🚀 Quick Start

This repository contains two platform-specific implementations:

Windows Version → `sql-server-mcp/`

✅ Windows Authentication (ODBC Driver 17)
✅ SQL Server Authentication
✅ Native msnodesqlv8 driver for optimal performance
📖 Windows Setup Guide

macOS Version → `sql-server-mcp-mac/`

✅ SQL Server Authentication (Docker required)
✅ Pure JavaScript mssql driver (no native dependencies)
📖 macOS Setup Guide

📦 Installation

🎉 Now Available on MCP Registry!

This server is officially published in the Model Context Protocol Registry:

Windows: io.github.TharanaBope/sql-server-mcp
macOS: io.github.TharanaBope/sql-server-mcp-macos

🚀 Quick Start (Recommended)

No installation needed! Just add to your AI assistant's configuration:

Claude Desktop (Windows)

Config Location: %APPDATA%\Claude\claude_desktop_config.json

"mcpServers": { "sql-server": { "command": "npx", "args": ["-y", "@tharanabopearachchi/sql-server-mcp@latest"], "env": { "SQL_SERVER": "localhost", "SQL_DATABASE": "master", "SQL_USE_WINDOWS_AUTH": "true" } } } }

Claude Desktop (macOS)

Config Location: ~/Library/Application Support/Claude/claude_desktop_config.json

"mcpServers": { "sql-server": { "command": "npx", "args": ["-y", "@tharanabopearachchi/sql-server-mcp-macos@latest"], "env": { "SQL_SERVER": "localhost", "SQL_DATABASE": "master", "SQL_USE_WINDOWS_AUTH": "false", "SQL_USERNAME": "sa", "SQL_PASSWORD": "your_password" } } } }

LM Studio Configuration

Config Location: Varies by platform

Windows: %USERPROFILE%\.lmstudio\config.json
macOS: ~/.lmstudio/config.json

VS Code with Continue Extension

Config Location: ~/.continue/config.json

"experimental": { "modelContextProtocolServers": [ { "transport": { "type": "stdio", "command": "npx", "args": ["-y", "@tharanabopearachchi/sql-server-mcp@latest"] }, "env": { "SQL_SERVER": "localhost", "SQL_DATABASE": "master", "SQL_USE_WINDOWS_AUTH": "true" } } ] } }

Cursor IDE

Config Location: Cursor Settings → Features → Model Context Protocol

Cline (VS Code Extension)

Config Location: VS Code Settings → Cline → MCP Settings

Restart your AI assistant and you're ready to go!

🛠️ Development Setup

For development or local modifications:

Windows

cd sql-server-mcp

npm install npm run build

👉 **[Complete Windows Setup Instructions](./sql-server-mcp/README.md)**

macOS

cd sql-server-mcp-mac

npm install npm run build

👉 **[Complete macOS Setup Instructions](./sql-server-mcp-mac/README.md)**

🛠️ Available MCP Tools

The server provides 12 powerful tools for database exploration:

Schema Exploration

list_databases - Discover all available databases
list_tables - View tables with row counts
describe_table - Get detailed schema (columns, types, constraints, indexes)
list_views - List all views
list_stored_procedures - List stored procedures with metadata
get_procedure_definition - Get full SQL definition
get_database_overview - High-level statistics

Relationship Mapping

get_table_relationships - Get foreign key relationships (incoming & outgoing)
get_related_tables - Find directly connected tables

Search & Discovery

search_schema - Search across tables, columns, views, procedures
find_column_usage - Find all tables containing a specific column

Query Execution

execute_query - Execute read-only SELECT queries safely

💬 Example Usage

Once configured, you can ask your AI assistant:

"What databases are available on this server?"

"Show me all tables in the Sales database"

"What's the schema of the Orders table?"

"Find all tables that reference the Customers table"

"Search for any columns related to 'email'"

"Execute: SELECT TOP 10 * FROM Products ORDER BY Price DESC"

⚙️ Configuration

Both versions use environment variables for configuration:

SQL_SERVER=localhost

SQL_DATABASE=master SQL_PORT=1433 SQL_USE_WINDOWS_AUTH=true # Windows only SQL_USERNAME= # For SQL Auth SQL_PASSWORD= # For SQL Auth QUERY_TIMEOUT=30 MAX_RESULT_ROWS=1000 ENABLE_SCHEMA_CACHE=true CACHE_TTL_MINUTES=60

See platform-specific READMEs for detailed configuration instructions.

🔐 Security Features

✅ Read-only by default - Write operations disabled unless explicitly enabled
✅ Query validation - Only SELECT statements allowed by default
✅ Automatic timeouts - Prevents long-running queries
✅ Row limits - Prevents memory exhaustion
✅ SQL injection prevention - Query sanitization and validation
✅ Database whitelisting - Optional restriction to specific databases

🏗️ Architecture

MCP/

├── sql-server-mcp/ # Windows implementation │ ├── src/ │ │ ├── index.ts # MCP server entry point │ │ ├── database/ # Connection, caching, queries │ │ ├── tools/ # 12 MCP tools │ │ └── types/ # TypeScript interfaces │ ├── dist/ # Compiled output │ ├── package.json │ └── README.md # Windows documentation │ ├── sql-server-mcp-mac/ # macOS implementation │ ├── src/ # Same structure as Windows │ └── README.md # macOS documentation │ ├── LICENSE # MIT License └── README.md # This file

🎯 Use Cases

Database Exploration

"What tables exist in this database?"
"Show me the structure of the Users table"
"List all stored procedures"

Schema Research

"Find all tables with an 'email' column"
"Search for anything related to 'invoice'"
"What views are available?"

Relationship Analysis

"How are Orders and Customers related?"
"Show me all tables that reference Products"
"What are the foreign key relationships for this table?"

Data Queries

"Get the top 10 most expensive products"
"Show me recent orders"
"What's the total count of records in each table?"

🤝 Contributing

Contributions are welcome! Please feel free to submit a Pull Request. For major changes, please open an issue first to discuss what you would like to change.

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

🙏 Acknowledgments

Built on Model Context Protocol SDK
Uses mssql and msnodesqlv8 drivers
Inspired by the need for better AI-database integration

📚 Resources

Windows Setup Guide: sql-server-mcp/README.md
macOS Setup Guide: sql-server-mcp-mac/README.md
Troubleshooting: Check platform-specific TROUBLESHOOTING.md files
MCP Documentation: https://github.com/modelcontextprotocol
Report Issues: https://github.com/TharanaBope/SQL-MCP-Mac-Windows/issues

🌐 Platform-Specific Documentation

Platform	Directory	Key Features
Windows	`sql-server-mcp/`	Windows Auth, ODBC Driver, Native performance
macOS	`sql-server-mcp-mac/`	Docker SQL Server, Pure JS, No native deps

Made with ❤️ for the MCP community

⭐ Star this repo if you find it useful! 🐛 Report bugs via Issues 💬 Questions? Check the Discussions