MSSQL
About
Enables robust SQL query execution and database connection management for Microsoft SQL Server with comprehensive error handling and security features.
Details
- Author
- knight0zh
- Repository
- knight0zh/mssql-mcp-server
- GitHub stars
- 4
- License
- MIT License
- Categories
- Design, Developer Tools, Search, Database, Frontend, Security, Infrastructure
Jump to
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
MSSQLCommand (node, npx, python, etc.)mssql-mcp-serverEnvironment-
MSSQL_HOST
localhost -
MSSQL_PORT
1433 -
MSSQL_USER
sa -
MSSQL_ENCRYPT
false -
MSSQL_DATABASE
master -
MSSQL_PASSWORD
yourpassword -
MSSQL_CONNECTION_STRING
Server=localhost;Database=master;User Id=sa;Password=yourpassword; -
MSSQL_TRUST_SERVER_CERTIFICATE
true
Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
-
MSSQL_HOST
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Add the server to your MCP settings configuration file:
{
"mcpServers": {
"mssql": {
"command": "mssql-mcp-server",
"env": {
"MSSQL_CONNECTION_STRING": "Server=localhost;Database=master;User Id=sa;Password=yourpassword;",
// Or individual connection parameters:
"MSSQL_HOST": "localhost",
"MSSQL_PORT": "1433",
"MSSQL_DATABASE": "master",
"MSSQL_USER": "sa",
"MSSQL_PASSWORD": "yourpassword",
"MSSQL_ENCRYPT": "false",
"MSSQL_TRUST_SERVER_CERTIFICATE": "true"
}
}
}
}
To install MSSQL Database Connector for Claude Desktop automatically via Smithery:
npx -y @smithery/cli install @knight0zh/mssql-mcp-server --client claude
npm install mssql-mcp-server
npm install
query
Execute a SQL query on a MSSQL database. Parameters: connectionString (optional string), host (optional string), port (optional number), database (optional string), username (optional string), password (optional string), query (required string), encrypt (optional boolean), trustServerCertificate (optional boolean)
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mssql": {
"env": {
"MSSQL_HOST": "localhost",
"MSSQL_PORT": "1433",
"MSSQL_USER": "sa",
"MSSQL_ENCRYPT": "false",
"MSSQL_DATABASE": "master",
"MSSQL_PASSWORD": "yourpassword",
"MSSQL_CONNECTION_STRING": "Server=localhost;Database=master;User Id=sa;Password=yourpassword;",
"MSSQL_TRUST_SERVER_CERTIFICATE": "true"
},
"args": [],
"command": "mssql-mcp-server"
}
}
}Linux
{
"env": {
"MSSQL_HOST": "localhost",
"MSSQL_PORT": "1433",
"MSSQL_USER": "sa",
"MSSQL_ENCRYPT": "false",
"MSSQL_DATABASE": "master",
"MSSQL_PASSWORD": "yourpassword",
"MSSQL_CONNECTION_STRING": "Server=localhost;Database=master;User Id=sa;Password=yourpassword;",
"MSSQL_TRUST_SERVER_CERTIFICATE": "true"
},
"args": [],
"command": "mssql-mcp-server"
}Macos
{
"env": {
"MSSQL_HOST": "localhost",
"MSSQL_PORT": "1433",
"MSSQL_USER": "sa",
"MSSQL_ENCRYPT": "false",
"MSSQL_DATABASE": "master",
"MSSQL_PASSWORD": "yourpassword",
"MSSQL_CONNECTION_STRING": "Server=localhost;Database=master;User Id=sa;Password=yourpassword;",
"MSSQL_TRUST_SERVER_CERTIFICATE": "true"
},
"args": [],
"command": "mssql-mcp-server"
}Windows
{
"env": {
"MSSQL_HOST": "localhost",
"MSSQL_PORT": "1433",
"MSSQL_USER": "sa",
"MSSQL_ENCRYPT": "false",
"MSSQL_DATABASE": "master",
"MSSQL_PASSWORD": "yourpassword",
"MSSQL_CONNECTION_STRING": "Server=localhost;Database=master;User Id=sa;Password=yourpassword;",
"MSSQL_TRUST_SERVER_CERTIFICATE": "true"
},
"args": [],
"command": "mssql-mcp-server"
}MSSQL MCP Server
A Model Context Protocol (MCP) server for connecting to Microsoft SQL Server databases. This server provides tools for executing SQL queries and managing database connections.
Installation
Installing via Smithery
To install MSSQL Database Connector for Claude Desktop automatically via Smithery:
npx -y @smithery/cli install @knight0zh/mssql-mcp-server --client claude
Manual Installation
npm install mssql-mcp-server
Usage
Add the server to your MCP settings configuration file:
{
"mcpServers": {
"mssql": {
"command": "mssql-mcp-server",
"env": {
"MSSQL_CONNECTION_STRING": "Server=localhost;Database=master;User Id=sa;Password=yourpassword;",
// Or individual connection parameters:
"MSSQL_HOST": "localhost",
"MSSQL_PORT": "1433",
"MSSQL_DATABASE": "master",
"MSSQL_USER": "sa",
"MSSQL_PASSWORD": "yourpassword",
"MSSQL_ENCRYPT": "false",
"MSSQL_TRUST_SERVER_CERTIFICATE": "true"
}
}
}
}
Tools
query
Execute a SQL query on a MSSQL database.
Parameters
- connectionString (string, optional): Full connection string (alternative to individual parameters)
- host (string, optional): Database server hostname
- port (number, optional): Database server port (default: 1433)
- database (string, optional): Database name (default: master)
- username (string, optional): Database username
- password (string, optional): Database password
- query (string, required): SQL query to execute
- encrypt (boolean, optional): Enable encryption (default: false)
- trustServerCertificate (boolean, optional): Trust server certificate (default: true)
Either connectionString OR (host + username + password) must be provided.
Example
const result = await use_mcp_tool({
server_name: 'mssql',
tool_name: 'query',
arguments: {
host: 'localhost',
username: 'sa',
password: 'yourpassword',
query: 'SELECT * FROM Users',
},
});
Development
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
