MCP Sqlexpress MCP Server

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

Local serverstdioPython

What is the MCP Sqlexpress MCP Server?

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

What it needs from you

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

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
get_allowed_databasesGet list of databases that are allowed to be accessed
read_queryExecute SELECT queries
write_queryExecute INSERT/UPDATE/DELETE queries
create_tableCreate new tables
list_tablesList all tables in database
describe_tableShow table schema

How to install the MCP Sqlexpress MCP Server

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

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

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

Example prompts to try

  • “Use MCP Sqlexpress to get allowed databases.”
  • “Use MCP Sqlexpress to read query.”
  • “Use MCP Sqlexpress to write query.”

Frequently asked questions

An MCP server for interacting with Microsoft SQL Server Express. Supports Windows and SQL Server authentication. Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.