MSSQL MCP 服务器是一个模型上下文协议 (MCP) 服务器，支持与**Microsoft SQL Server (MSSQL)**数据库进行安全且结构化的交互。它允许 AI 助手：
列出可用的表
读取表内容
使用受控访问权限执行 SQL 查询
这确保了更安全的数据库探索、严格的权限执行以及数据库交互的记录。
通过环境变量保护 MSSQL 数据库访问
具有错误处理的受控查询执行
表格列表和数据检索
用于监控查询和操作的综合日志记录
Related MCP server: MCP SQL Server
pip install mssql-mcp-server设置以下环境变量来配置数据库访问：
MSSQL_DRIVER=mssql_driver
MSSQL_HOST=localhost
MSSQL_USER=your_username
MSSQL_PASSWORD=your_password
MSSQL_DATABASE=your_database
#optional
TrustServerCertificate=yes
Trusted_Connection=no要与Claude Desktop集成，请将此配置添加到claude_desktop_config.json ：
{
"mcpServers": {
"mssql": {
"command": "uv",
"args": [
"--directory",
"path/to/mssql_mcp_server",
"run",
"mssql_mcp_server"
],
"env": {
"MSSQL_DRIVER": "mssql_driver",
"MSSQL_HOST": "localhost",
"MSSQL_USER": "your_username",
"MSSQL_PASSWORD": "your_password",
"MSSQL_DATABASE": "your_database"
}
}
}
}# Install dependencies
pip install -r requirements.txt
# Run the server
python -m mssql_mcp_server# Clone the repository
git clone https://github.com/yourusername/mssql_mcp_server.git
cd mssql_mcp_server
# Set up a virtual environment
python -m venv venv
source venv/bin/activate # On Windows: venv\Scripts\activate
# Install development dependencies
pip install -r requirements-dev.txt
# Run tests
pytest使用具有最小权限的专用 MSSQL 用户。
切勿使用根凭据或完整管理帐户。
将数据库访问限制为仅进行必要的操作。
启用日志记录和审计以进行安全监控。
定期审查权限以确保最低权限访问。
为了安全设置：
创建具有受限权限的专用 MSSQL 用户。
避免对凭证进行硬编码——而是使用环境变量。
仅限制对必要的表和操作的访问。
启用 SQL Server 日志记录和监控以进行审计。
定期检查数据库访问权限，以防止未经授权的访问。
有关详细说明，请参阅**MSSQL 安全配置指南**。
⚠️重要提示：配置数据库访问时始终遵循最小特权原则。
本项目遵循MIT 许可证。详情请参阅LICENSE文件。
欢迎投稿！投稿方式：
分叉存储库。
创建功能分支： git checkout -b feature/amazing-feature
提交您的更改： git commit -m 'Add amazing feature'
推送到分支： git push origin feature/amazing-feature
打开拉取请求。
如有任何疑问或问题，请随时打开 GitHub **Issue**或联系维护人员。
This server cannot be installed
Unclaimed servers have limited discoverability.
If you are the server author, to access and configure the admin panel.
The HubSpot MCP Server acts as a bridge that enables AI assistants and Large Language Models to securely interact with HubSpot CRM data through natural conversation, without requiring users to understand complex API structures. It provides read-only access to standard CRM objects (contacts, companies, deals, tickets, products, invoices, and more) and their associations, secured via OAuth 2.0, allowing AI agents to perform tasks like summarizing deals, fetching company updates, and looking up record changes.
The BigQuery remote MCP server is a fully managed service that uses the Model Context Protocol to connect AI applications and LLMs to BigQuery data sources. It provides secure, standardized tools for AI agents to list datasets and tables, retrieve schemas, generate and execute SQL queries through natural language, and analyze data—enabling direct access to enterprise analytics data without requiring manual SQL coding.
A comprehensive Model Context Protocol (MCP) server that enables AI assistants to interact with yo…
The Mercado Pago MCP Server implements the Model Context Protocol to provide AI agents and LLMs with access to Mercado Pago's APIs and tools within compatible development environments. It acts as an intermediary that translates Mercado Pago resources into executable functions (tools) that AI applications can invoke to perform actions and automate flows. The server simplifies integration, enables using documentation to implement or improve code, and optimizes operations through natural language interactions without manual implementations.
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/JexinSam/mssql_mcp_server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server
