SQL Server Express

by hanweg

4 stars
425 downloads
Not rated
GitHub

About

Integrates with Microsoft SQL Server Express to enable database interactions, supporting query execution, table creation, and schema description with configurable authentication and access restrictions.

Details

Author
hanweg
Repository
hanweg/mcp-sqlexpress
GitHub stars
4
Downloads
425
License
MIT License
Categories
Database, Other, Productivity, Developer Tools, Design, AI, Search, Project Management, API, Frontend
Tags
#integration

Jump to

- Execute SELECT, INSERT, UPDATE, DELETE queries
- Create new tables
- List and describe tables
- Restrict access to allowed databases
- Supports Windows and SQL Server authentication

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

  1. Download and install Highlight from highlightai.com/download
  2. Navigate to the plugins tab and select "Add Custom Plugin"
  3. Configure the plugin with the settings below
    Plugin Name SQL Server Express
    Command (node, npx, python, etc.) uv
    Arguments
    • Argument 1 --directory
    • Argument 2 PATH\TO\PROJECT\mcp-sqlexpress
    • Argument 3 run
    • Argument 4 mcp-server-sqlexpress
    • Argument 5 --server
    • Argument 6 server\instance
    • Argument 7 --auth
    • Argument 8 windows
    • Argument 9 --trusted-connection
    • Argument 10 yes
    • Argument 11 --trust-server-certificate
    • Argument 12 yes
    • Argument 13 --allowed-databases
    • Argument 14 database1,database2

    Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.

  4. Enable "Start Automatically" if you want the plugin to start when Highlight launches

From the repository

Clone this repo

cd mcp-sqlexpress

uv venv

.venv\Scripts\activate


uv pip install --editable .

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"
            ]
        }
    }
}

For Windows Authentication:
- Set --auth windows
- Set --trusted-connection yes

For SQL Server Authentication:
- Set --auth sql
- Add --username and --password

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.

- 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

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "sql server express": {
            "env": {},
            "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"
            ],
            "shell": false,
            "command": "uv"
        }
    }
}

Linux

{
    "env": [],
    "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"
    ],
    "shell": false,
    "command": "uv"
}

Macos

{
    "env": [],
    "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"
    ],
    "shell": false,
    "command": "uv"
}

Windows

{
    "env": [],
    "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"
    ],
    "shell": false,
    "command": "uv"
}

An MCP server for interacting with Microsoft SQL Server Express. Supports Windows and SQL Server authentication.

- Python 3.10 or higher
- Microsoft ODBC Driver 18 for SQL Server
- SQL Server instance with appropriate permissions

cd mcp-sqlexpress # Create and activate virtual environment uv venv .venv\Scripts\activate # Install dependencies uv pip install --editable .

Add to yourclaude_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" ] } } }

- Set--auth windows
- Set--trusted-connection yes

- Set--auth sql
- Add--usernameand--password

- 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

Official MCP server for dbt (data build tool) providing integration with dbt Core/Cloud CLI, project metadata discovery, model information, and semantic layer querying capabilities.

Open source MCP server specializing in easy, fast, and secure tools for Databases.

Query and analyze data with MotherDuck and local DuckDB

Query Streams securely connects MCP clients to live databases through the Query Streams Cloud Network, with no VPNs, inbound ports, or complex setup.

Interact with the SingleStore database platform

Official Supabase MCP server for managing Supabase projects, databases, auth, storage, edge functions, and SQL workflows from AI agents.

A collection of tools for managing the platform, addressing data quality and reading and writing to Teradata Database.

Multi-database agent access (PostgreSQL, SQLite, MySQL, Oracle, SQL Server) with batch queries, pre-configured connections, and SQLGlot-enforced read-only safety

No reviews yet — be the first

Sign in to leave a review

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

Install

Add to Claude Desktop or Cursor

{
    "mcpServers": {
        "sql server express": {
            "env": {},
            "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"
            ],
            "shell": false,
            "command": "uv"
        }
    }
}

More like this

Similar MCP servers you might find useful

Browse category

Sequential Thinking

Sequential Thinking is an MCP server that provides a tool for dynamic and reflective problem-solving through a structured, step-by-step thinking process. It is…

88.2k
Other

Time

A Model Context Protocol server that provides time and timezone conversion capabilities. It enables LLMs to get current time information and perform timezone…

88.2k
Productivity

Filesystem

Filesystem is a Node.js server that implements the Model Context Protocol (MCP) for filesystem operations. It enables AI assistants to read, write, and manage…

88.1k
Other