How do I use MSSQL MCP Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@MSSQL MCP Server show me the top 10 customers by total sales" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

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

Related MCP server: 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

# Install dependencies npm install # Run in development mode npm run dev # Build npm run build # Run tests npm test # Run linter npm run lint # Format code npm run format