MCP.so
Sign In

SQL Server Express MCP Server

@hanweg

Repository

About SQL Server Express MCP Server

MCP server for interacting with SQLExpress

#mcp-sqlexpress#sql-server#database-interaction

Config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

Tools

6

Get list of databases that are allowed to be accessed

Execute SELECT queries

Execute INSERT/UPDATE/DELETE queries

Create new tables

List all tables in database

Show table schema

Overview

What is SQL Server Express MCP Server?

An MCP server for interacting with Microsoft SQL Server Express. It supports both Windows and SQL Server authentication and is intended for use with AI assistants like Claude Desktop.

How to use SQL Server Express MCP Server?

Clone the repository, create and activate a Python virtual environment using uv, install dependencies, then configure claude_desktop_config.json with the appropriate --server, --auth, and optional --username/--password flags. For Windows authentication use --auth windows --trusted-connection yes; for SQL authentication use --auth sql and supply credentials.

Key features of SQL Server Express MCP Server

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

Use cases of SQL Server Express MCP Server

  • Querying SQL Server databases through an AI assistant
  • Managing table schemas without direct database tools
  • Securely integrating SQL Server with MCP-compatible applications

FAQ from SQL Server Express MCP Server

What authentication methods are supported?

The server supports Windows Authentication (--auth windows) and SQL Server Authentication (--auth sql). SQL authentication requires a username and password.

What are the prerequisites?

Python 3.10 or higher, Microsoft ODBC Driver 18 for SQL Server, and a SQL Server instance with appropriate permissions.

How do I restrict which databases can be accessed?

Use the --allowed-databases flag and provide a comma-separated list of database names (e.g., database1,database2).

Can I run custom queries other than SELECT?

Yes. The write_query tool executes INSERT, UPDATE, and DELETE queries, and the create_table tool creates new tables.

Does the server support certificate trust?

Yes, use the --trust-server-certificate yes flag to trust the server certificate without validation.

Frequently asked questions

What authentication methods are supported?

The server supports Windows Authentication (`--auth windows`) and SQL Server Authentication (`--auth sql`). SQL authentication requires a username and password.

What are the prerequisites?

Python 3.10 or higher, Microsoft ODBC Driver 18 for SQL Server, and a SQL Server instance with appropriate permissions.

How do I restrict which databases can be accessed?

Use the `--allowed-databases` flag and provide a comma-separated list of database names (e.g., `database1,database2`).

Can I run custom queries other than SELECT?

Yes. The `write_query` tool executes INSERT, UPDATE, and DELETE queries, and the `create_table` tool creates new tables.

Does the server support certificate trust?

Yes, use the `--trust-server-certificate yes` flag to trust the server certificate without validation.

Comments

Basic information

Category

Developer Tools

License

MIT

Transports

stdio

Author

hanweg

More Developer Tools MCP servers

Termany

thinkany-ai

Agent-Native Terminal

174

TaskerArmy Agent

TaskerArmy

Ask Claude or ChatGPT what Shopify theme optimization tasks are pending on your store, a remote MCP server for TaskerArmy Agent accounts.

ship.page

Bitgate

Throw HTML at an API, get an unguessable URL back. Zero-config remote MCP server — your agent deploys pages, sites and CI reports in one call. Free, no signup needed.

Reelier

Maxime Houle

Agents make claims. Reelier writes receipts — record an agent's tool-call workflow once, replay it deterministically at 0 tokens, and diff runs to catch drift.

AptiBuild AI — Career Intelligence

ParklandBuilds

AptiBuild AI — Career Intelligence MCP Server Structured career decision scaffolding for AI agents. Provides personality-conditioned business idea generation, official BLS OEWS wage data, FRED labor market signals, and