SQL Server Express MCP Server
An MCP server for interacting with Microsoft SQL Server Express. Supports Windows and SQL Server authentication.
Prerequisites
- Python 3.10 or higher
- Microsoft ODBC Driver 18 for SQL Server
- SQL Server instance with appropriate permissions
Installation
Clone this repo
cd mcp-sqlexpress
# Create and activate virtual environment
uv venv
.venvScriptsactivate
# Install dependencies
uv pip install --editable .
Usage with Claude Desktop
Add to your claude_desktop_config.json
:
{
"mcpServers": {
"sqlexpress": {
"command": "uv",
"args": [
"--directory",
"PATH\TO\PROJECT\mcp-sqlexpress",
"run",
"mcp-server-sqlexpress",
"--server",
"server\instance",
"--auth",
"windows",
"--trusted-connection",
"yes",
"--trust-server-certificate",
"yes",
"--allowed-databases",
"database1,database2"
]
}
}
}
Authentication Options
For Windows Authentication:
- Set
--auth windows
- Set
--trusted-connection yes
For SQL Server Authentication:
- Set
--auth sql
- Add
--username
and--password
Features
Tools
get_allowed_databases
: Get list of databases that are allowed to be accessedread_query
: Execute SELECT querieswrite_query
: Execute INSERT/UPDATE/DELETE queriescreate_table
: Create new tableslist_tables
: List all tables in databasedescribe_table
: Show table schema
SQL Server Express MCP Server
Project Details
- hanweg/mcp-sqlexpress
- MIT License
- Last Updated: 2/20/2025
Recomended MCP Servers
Fetch MCP Server
Command line interface for MCP clients with secure execution and customizable security policies
mcp server for mlflow
A Model Context Protocol (MCP) server implementation for Notion integration, providing a standardized interface for interacting with Notion's...
A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.
Model Context Protocol (MCP) server to access an instance of TrueRAG
An unofficial JavaScript SDK for Model Context Protocol
MCP Civil Tools 伺服器
MCP server 0xEvm addresses