MSSQL MCP Server

by knight0zh
MIT License
3

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

# 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

License

MIT

-
security - not tested
A
license - permissive license
-
quality - not tested

A Model Context Protocol server that enables executing SQL queries and managing connections with Microsoft SQL Server databases.

  1. Installation
    1. Installing via Smithery
    2. Manual Installation
  2. Usage
    1. Tools
      1. query
    2. Development
      1. License

        Related MCP Servers

        • -
          security
          A
          license
          -
          quality
          Enables execution of SQL queries and management of Microsoft SQL Server database connections through the Model Context Protocol.
          Last updated -
          10
          TypeScript
          MIT License
          • Apple
          • Linux
        • -
          security
          A
          license
          -
          quality
          A Model Context Protocol server that enables secure and structured interaction with Microsoft SQL Server databases, allowing AI assistants to list tables, read data, and execute SQL queries with controlled access.
          Last updated -
          12
          Python
          MIT License
          • Linux
          • Apple
        • -
          security
          F
          license
          -
          quality
          A Model Context Protocol server that enables SQL query execution, database management, and business intelligence capabilities through MySQL connections.
          Last updated -
          JavaScript
        • A
          security
          A
          license
          A
          quality
          A Model Context Protocol server that enables secure interaction with Microsoft SQL Server databases, allowing AI assistants to list tables, read data, and execute SQL queries through a controlled interface.
          Last updated -
          1
          30
          Python
          MIT License
          • Linux
          • Apple

        View all related MCP servers

        ID: k89rro1mlh