Skip to main content
Glama
enesjakozh

SQL Server Express MCP Server

by hanweg
GitHub
Python
MIT License
4
OverviewInspectNewEndpointsSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

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 --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

This server cannot be installed

-
security - not tested
A
license - permissive license
-
quality - not tested

How are these scores calculated?

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

자연어 MCP 명령을 통해 쿼리, 테이블 관리, 스키마 검사 등의 데이터베이스 작업을 지원하여 Microsoft SQL Server Express와의 상호 작용을 용이하게 합니다.

  1. 필수 조건
    1. 설치
      1. Claude Desktop과 함께 사용
        1. 인증 옵션
      2. 특징
        1. 도구

      Related Resources

      Related MCP Servers

      • MCP SQL Server

        dennismartis
        -
        security
        F
        license
        -
        quality
        A FastMCP server that provides natural language interaction with MS SQL databases, enabling users to query data, list tables, describe structures, and execute database operations through a conversational AI interface.
        Last updated -

      • Jewei MSSQL MCP Server

        jeweis
        -
        security
        A
        license
        -
        quality
        A FastMCP-based server that enables executing Microsoft SQL Server data queries and table structure queries through a standardized MCP protocol interface.
        Last updated -
        3
        MIT License

      • MSSQL MCP Server

        NakiriYuuzu
        A
        security
        F
        license
        A
        quality
        Enables interaction with Microsoft SQL Server databases through a Model Context Protocol interface, supporting database connections, switching between databases, and executing secure SELECT queries.
        Last updated -
        8
        1

      • NLSQL MCP Server

        tushar-badhwar
        -
        security
        A
        license
        -
        quality
        An MCP (Model Context Protocol) server that exposes natural language to SQL functionality, allowing any MCP-compatible client to convert plain English questions into SQL queries for database interaction using AI.
        Last updated -
        1
        MIT License

      View all related MCP servers

      Appeared in Searches

      New MCP Servers

      MCP directory API

      We provide all the information about MCP servers via our MCP API.

      curl -X GET 'https://glama.ai/api/mcp/v1/servers/hanweg/mcp-sqlexpress'

      If you have feedback or need assistance with the MCP directory API, please join our Discord server