SQL Server Express MCP Server
Facilitates interaction with Microsoft SQL Server Express, supporting database operations such as querying, table management, and schema inspection via natural language MCP commands.
hanweg
README
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
--usernameand--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
Recommended Servers
VeyraX MCP
Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.
Exa Search
A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.
Neon Database
MCP server for interacting with Neon Management API and databases
AIO-MCP Server
🚀 All-in-one MCP server with AI search, RAG, and multi-service integrations (GitLab/Jira/Confluence/YouTube) for AI-enhanced development workflows. Folk from
Persistent Knowledge Graph
An implementation of persistent memory for Claude using a local knowledge graph, allowing the AI to remember information about users across conversations with customizable storage location.
Hyperbrowser MCP Server
Welcome to Hyperbrowser, the Internet for AI. Hyperbrowser is the next-generation platform empowering AI agents and enabling effortless, scalable browser automation. Built specifically for AI developers, it eliminates the headaches of local infrastructure and performance bottlenecks, allowing you to
Search1API MCP Server
A Model Context Protocol (MCP) server that provides search and crawl functionality using Search1API.
Supabase MCP Server (used by Deploya.dev)
Enables Cursor and Windsurf to safely interact with Supabase databases by providing tools for database management, SQL query execution, and Supabase Management API access with built-in safety controls.
Database Explorer
A powerful Model Context Protocol (MCP) tool for exploring and managing different types of databases including PostgreSQL, MySQL, and Firestore.
Supabase MCP Server
This server enables interaction with Supabase PostgreSQL databases through the MCP protocol, allowing seamless integration with Cursor and Windsurf IDEs for secure and validated database management.