alorenco/mssql-local-mcp
3.1
If you are the rightful owner of mssql-local-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
The MSSQL Local Database MCP Server is a specialized server designed to facilitate communication and operations with a local Microsoft SQL Server database using the Model Context Protocol (MCP).
MSSQL Local Database MCP Server
Prerequisites
- Node.js 14 or higher
Set up project
-
Install Dependencies
Run the following command in the root folder to install all necessary dependencies:pnpm install
-
Build the Project
Compile the project by running:pnpm run build
Configuration Setup
{
"mcpServers": {
"mssql": {
"command": "node",
"args": [ "/home/[user]/mssql-local-mcp/dist/index.js" ],
"env": {
"SERVER_NAME": "127.0.0.1",
"DATABASE_NAME": "master",
"SQL_USERNAME": "user",
"SQL_PASSWORD": "",
"READONLY": "true"
}
}
}
}