| Name | yulin-mssql-mcp JSON |
| Version |
0.1.0
JSON |
| download |
| home_page | None |
| Summary | A Model Context Protocol (MCP) server that enables secure interaction with Microsoft SQL Server databases. |
| upload_time | 2025-07-31 06:23:35 |
| maintainer | None |
| docs_url | None |
| author | None |
| requires_python | >=3.11 |
| license | MIT |
| keywords |
ai
database
mcp
mssql
sql-server
|
| VCS |
|
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
# Microsoft SQL Server MCP Server
[](https://pypi.org/project/yulin-mssql-mcp/)
[](https://opensource.org/licenses/MIT)
A Model Context Protocol (MCP) server for secure SQL Server database access through Claude Desktop.
## Features
- 🔍 List database tables
- 📊 Execute SQL queries (SELECT, INSERT, UPDATE, DELETE)
- 🔐 Multiple authentication methods (SQL, Windows, Azure AD)
- 🏢 LocalDB and Azure SQL support
- 🔌 Custom port configuration
## Quick Start
### Install with Claude Desktop
Add to your `claude_desktop_config.json`:
```json
{
"mcpServers": {
"mssql": {
"command": "uvx",
"args": ["yulin-mssql-mcp"],
"env": {
"MSSQL_SERVER": "localhost",
"MSSQL_DATABASE": "your_database",
"MSSQL_USER": "your_username",
"MSSQL_PASSWORD": "your_password"
}
}
}
}
```
## Configuration
### Basic SQL Authentication
```bash
MSSQL_SERVER=localhost # Required
MSSQL_DATABASE=your_database # Required
MSSQL_USER=your_username # Required for SQL auth
MSSQL_PASSWORD=your_password # Required for SQL auth
```
### Windows Authentication
```bash
MSSQL_SERVER=localhost
MSSQL_DATABASE=your_database
MSSQL_WINDOWS_AUTH=true # Use Windows credentials
```
### Azure SQL Database
```bash
MSSQL_SERVER=your-server.database.windows.net
MSSQL_DATABASE=your_database
MSSQL_USER=your_username
MSSQL_PASSWORD=your_password
# Encryption is automatic for Azure
```
### Optional Settings
```bash
MSSQL_PORT=1433 # Custom port (default: 1433)
MSSQL_ENCRYPT=true # Force encryption
```
## Alternative Installation Methods
### Using pip
```bash
pip install yulin-mssql-mcp
```
Then in `claude_desktop_config.json`:
```json
{
"mcpServers": {
"mssql": {
"command": "yulin-mssql-mcp",
"args": [],
"env": { ... }
}
}
}
```
### Development
```bash
git clone https://github.com/yulin0629/mssql_mcp_server.git
cd mssql_mcp_server
pip install -e .
```
## Security
- Create a dedicated SQL user with minimal permissions
- Never use admin/sa accounts
- Use Windows Authentication when possible
- Enable encryption for sensitive data
## License
MIT
Raw data
{
"_id": null,
"home_page": null,
"name": "yulin-mssql-mcp",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.11",
"maintainer_email": null,
"keywords": "ai, database, mcp, mssql, sql-server",
"author": null,
"author_email": "yulin0629 <yulin0629@gmail.com>",
"download_url": "https://files.pythonhosted.org/packages/7c/6e/c7509e81f20635d1c036ffd54c63586c19ffd4eea283cf630bccae2284fb/yulin_mssql_mcp-0.1.0.tar.gz",
"platform": null,
"description": "# Microsoft SQL Server MCP Server\n\n[](https://pypi.org/project/yulin-mssql-mcp/)\n[](https://opensource.org/licenses/MIT)\n\nA Model Context Protocol (MCP) server for secure SQL Server database access through Claude Desktop.\n\n## Features\n\n- \ud83d\udd0d List database tables\n- \ud83d\udcca Execute SQL queries (SELECT, INSERT, UPDATE, DELETE)\n- \ud83d\udd10 Multiple authentication methods (SQL, Windows, Azure AD)\n- \ud83c\udfe2 LocalDB and Azure SQL support\n- \ud83d\udd0c Custom port configuration\n\n## Quick Start\n\n### Install with Claude Desktop\n\nAdd to your `claude_desktop_config.json`:\n\n```json\n{\n \"mcpServers\": {\n \"mssql\": {\n \"command\": \"uvx\",\n \"args\": [\"yulin-mssql-mcp\"],\n \"env\": {\n \"MSSQL_SERVER\": \"localhost\",\n \"MSSQL_DATABASE\": \"your_database\",\n \"MSSQL_USER\": \"your_username\",\n \"MSSQL_PASSWORD\": \"your_password\"\n }\n }\n }\n}\n```\n\n## Configuration\n\n### Basic SQL Authentication\n```bash\nMSSQL_SERVER=localhost # Required\nMSSQL_DATABASE=your_database # Required\nMSSQL_USER=your_username # Required for SQL auth\nMSSQL_PASSWORD=your_password # Required for SQL auth\n```\n\n### Windows Authentication\n```bash\nMSSQL_SERVER=localhost\nMSSQL_DATABASE=your_database\nMSSQL_WINDOWS_AUTH=true # Use Windows credentials\n```\n\n### Azure SQL Database\n```bash\nMSSQL_SERVER=your-server.database.windows.net\nMSSQL_DATABASE=your_database\nMSSQL_USER=your_username\nMSSQL_PASSWORD=your_password\n# Encryption is automatic for Azure\n```\n\n### Optional Settings\n```bash\nMSSQL_PORT=1433 # Custom port (default: 1433)\nMSSQL_ENCRYPT=true # Force encryption\n```\n\n## Alternative Installation Methods\n\n### Using pip\n```bash\npip install yulin-mssql-mcp\n```\n\nThen in `claude_desktop_config.json`:\n```json\n{\n \"mcpServers\": {\n \"mssql\": {\n \"command\": \"yulin-mssql-mcp\",\n \"args\": [],\n \"env\": { ... }\n }\n }\n}\n```\n\n### Development\n```bash\ngit clone https://github.com/yulin0629/mssql_mcp_server.git\ncd mssql_mcp_server\npip install -e .\n```\n\n## Security\n\n- Create a dedicated SQL user with minimal permissions\n- Never use admin/sa accounts\n- Use Windows Authentication when possible\n- Enable encryption for sensitive data\n\n## License\n\nMIT",
"bugtrack_url": null,
"license": "MIT",
"summary": "A Model Context Protocol (MCP) server that enables secure interaction with Microsoft SQL Server databases.",
"version": "0.1.0",
"project_urls": null,
"split_keywords": [
"ai",
" database",
" mcp",
" mssql",
" sql-server"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "439a4c336fd8cfcde02538bc0ace8e423f3e5995cf60229316f0ebcb53d71cc7",
"md5": "2b630ffab644e998bef511fb3a50e81a",
"sha256": "0a7a8f2b120b6f4b336108e9769c9d9d8192057ad9c5f8e79e27a2fcb5323e64"
},
"downloads": -1,
"filename": "yulin_mssql_mcp-0.1.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "2b630ffab644e998bef511fb3a50e81a",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.11",
"size": 6909,
"upload_time": "2025-07-31T06:23:34",
"upload_time_iso_8601": "2025-07-31T06:23:34.173638Z",
"url": "https://files.pythonhosted.org/packages/43/9a/4c336fd8cfcde02538bc0ace8e423f3e5995cf60229316f0ebcb53d71cc7/yulin_mssql_mcp-0.1.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "7c6ec7509e81f20635d1c036ffd54c63586c19ffd4eea283cf630bccae2284fb",
"md5": "4c0d211d797de2e08c9ac83f69a78e5f",
"sha256": "cf0d5abd77294a22827526355a200ae192102598d07c819cafd9957e8ddb8211"
},
"downloads": -1,
"filename": "yulin_mssql_mcp-0.1.0.tar.gz",
"has_sig": false,
"md5_digest": "4c0d211d797de2e08c9ac83f69a78e5f",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.11",
"size": 35615,
"upload_time": "2025-07-31T06:23:35",
"upload_time_iso_8601": "2025-07-31T06:23:35.675757Z",
"url": "https://files.pythonhosted.org/packages/7c/6e/c7509e81f20635d1c036ffd54c63586c19ffd4eea283cf630bccae2284fb/yulin_mssql_mcp-0.1.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-07-31 06:23:35",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "yulin-mssql-mcp"
}
