mcp-sqlexpress
3.3
If you are the rightful owner of mcp-sqlexpress and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
An MCP server for interacting with Microsoft SQL Server Express. Supports Windows and SQL Server authentication.
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
.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 windows - Set
--trusted-connection yes
For SQL Server Authentication:
- Set
--auth sql - Add
--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
