| Name | yulin-mssql-mcp JSON |
| Version |
0.1.2
JSON |
| download |
| home_page | None |
| Summary | A Model Context Protocol (MCP) server that enables secure interaction with Microsoft SQL Server databases. |
| upload_time | 2025-08-12 02:59:04 |
| 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
MCP_DEBUG=1 # Enable debug logging to stderr
```
## 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 .
```
## Debugging
Enable debug mode to see detailed logs in stderr:
```bash
# Set environment variable
MCP_DEBUG=1
# Or in Claude Desktop config
"env": {
"MCP_DEBUG": "1",
...
}
```
Debug logs include:
- Database connection details (without passwords)
- SQL query execution traces
- MCP protocol message flow
## 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/ec/14/b2bc24bbfc9ac8ff997bab96695cb71cbf358eaac400017171e1669e6b4f/yulin_mssql_mcp-0.1.2.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\nMCP_DEBUG=1 # Enable debug logging to stderr\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## Debugging\n\nEnable debug mode to see detailed logs in stderr:\n\n```bash\n# Set environment variable\nMCP_DEBUG=1\n\n# Or in Claude Desktop config\n\"env\": {\n \"MCP_DEBUG\": \"1\",\n ...\n}\n```\n\nDebug logs include:\n- Database connection details (without passwords)\n- SQL query execution traces\n- MCP protocol message flow\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.2",
"project_urls": null,
"split_keywords": [
"ai",
" database",
" mcp",
" mssql",
" sql-server"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "48fae541eede6474d3a4e68f32995d556cb04cf5be66da2596bd23c14c8f587b",
"md5": "09c358e24ee0d42091d2f88cf07fef33",
"sha256": "763361dc28b08c6f21981da4e07f4f128bb2a30765d5030ce718fde360792f16"
},
"downloads": -1,
"filename": "yulin_mssql_mcp-0.1.2-py3-none-any.whl",
"has_sig": false,
"md5_digest": "09c358e24ee0d42091d2f88cf07fef33",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.11",
"size": 7734,
"upload_time": "2025-08-12T02:59:03",
"upload_time_iso_8601": "2025-08-12T02:59:03.325037Z",
"url": "https://files.pythonhosted.org/packages/48/fa/e541eede6474d3a4e68f32995d556cb04cf5be66da2596bd23c14c8f587b/yulin_mssql_mcp-0.1.2-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "ec14b2bc24bbfc9ac8ff997bab96695cb71cbf358eaac400017171e1669e6b4f",
"md5": "b61ac60b6141958bc76d109223fc162c",
"sha256": "10b01ea3341f57edad461e1ab62f8b62c2d5653c95c393f5ca55fd2d77c196eb"
},
"downloads": -1,
"filename": "yulin_mssql_mcp-0.1.2.tar.gz",
"has_sig": false,
"md5_digest": "b61ac60b6141958bc76d109223fc162c",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.11",
"size": 37425,
"upload_time": "2025-08-12T02:59:04",
"upload_time_iso_8601": "2025-08-12T02:59:04.630179Z",
"url": "https://files.pythonhosted.org/packages/ec/14/b2bc24bbfc9ac8ff997bab96695cb71cbf358eaac400017171e1669e6b4f/yulin_mssql_mcp-0.1.2.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-08-12 02:59:04",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "yulin-mssql-mcp"
}
