Mcp Sqlexpress
What is Mcp Sqlexpress
mcp-sqlexpress is an MCP server designed for interacting with Microsoft SQL Server Express, supporting both Windows and SQL Server authentication methods.
Use cases
Use cases include developing applications that need to perform CRUD operations on SQL Server databases, managing database schemas, and integrating SQL Server functionalities into desktop applications.
How to use
To use mcp-sqlexpress, clone the repository, create and activate a virtual environment, install the necessary dependencies, and configure it in the ‘claude_desktop_config.json’ file with appropriate server and authentication settings.
Key features
Key features include tools for getting allowed databases, executing SELECT, INSERT, UPDATE, DELETE queries, creating new tables, listing all tables in a database, and showing table schema.
Where to use
mcp-sqlexpress can be used in various fields that require database management and interaction, particularly in applications that utilize Microsoft SQL Server Express for data storage and retrieval.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Mcp Sqlexpress
mcp-sqlexpress is an MCP server designed for interacting with Microsoft SQL Server Express, supporting both Windows and SQL Server authentication methods.
Use cases
Use cases include developing applications that need to perform CRUD operations on SQL Server databases, managing database schemas, and integrating SQL Server functionalities into desktop applications.
How to use
To use mcp-sqlexpress, clone the repository, create and activate a virtual environment, install the necessary dependencies, and configure it in the ‘claude_desktop_config.json’ file with appropriate server and authentication settings.
Key features
Key features include tools for getting allowed databases, executing SELECT, INSERT, UPDATE, DELETE queries, creating new tables, listing all tables in a database, and showing table schema.
Where to use
mcp-sqlexpress can be used in various fields that require database management and interaction, particularly in applications that utilize Microsoft SQL Server Express for data storage and retrieval.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
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
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
