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
Related MCP server: Jewei MSSQL MCP Server
Installation
Clone this repo
cd mcp-sqlexpress
# Create and activate virtual environment
uv venv
.venv\Scripts\activate
# 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 windowsSet
--trusted-connection yes
For SQL Server Authentication:
Set
--auth sqlAdd
--usernameand--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