SQL Server Express MCP Server

Databases
MIT License
Overview InspectNew Schema Related Servers Reviews Score
mcp-sqlexpress
# 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

```powershell
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`:

```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 accessed
- `read_query`: Execute SELECT queries
- `write_query`: Execute INSERT/UPDATE/DELETE queries
- `create_table`: Create new tables
- `list_tables`: List all tables in database
- `describe_table`: Show table schema