SQL Server Express
An MCP server for interacting with Microsoft SQL Server Express databases.
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 accessedread_query
: Execute SELECT querieswrite_query
: Execute INSERT/UPDATE/DELETE queriescreate_table
: Create new tableslist_tables
: List all tables in databasedescribe_table
: Show table schema
Related Servers
MongoDB MCP Server
A server for performing CRUD operations on a MongoDB database.
CData SAP BusinessObjects BI
A read-only MCP server for SAP BusinessObjects BI, powered by the CData JDBC Driver.
CData Google Sheets MCP Server
A read-only MCP server for Google Sheets, enabling LLMs to query live data using the CData JDBC Driver.
MongoDB
Interact with MongoDB databases and MongoDB Atlas.
NetSuite MCP Server by CData
A read-only MCP server that allows LLMs to query live NetSuite data. Requires the CData JDBC Driver for NetSuite.
Notion Content Database
Manage content databases in Notion using the Notion API.
D&D 5E MCP Server
Access Dungeons & Dragons 5th Edition content, including spells, classes, and monsters, via the Open5e API.
Momento MCP Server
An MCP server providing a simple interface to Momento's serverless caching service.
Finance MCP Server
Provides real-time financial data from Yahoo Finance.
LanceDB
Interact with on-disk documents using agentic RAG and hybrid search via LanceDB.