Skip to main content
Glama
Sign In
enesjakozh

SQL Server MCP

by cwilby
GitHub
TypeScript
MIT License
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

Integrations

  • Enables Windsurf (Codeium's AI assistant) to connect to and interact with Microsoft SQL Server databases.

  • Offers GitHub integration for issue reporting and troubleshooting related to the MCP server functionality.

mcp-node-mssql

Usage

Cursor

See the official Cursor docs for more information.

  1. Open (or create) the mcp.json file (it should be in ~/.cursor/mcp.json or <project-root>/.cursor/mcp.json, but see Cursor docs for more details).
  2. Add the following details and save the file:
{ "mcpServers": { "mssql": { "command": "npx", "args": [ "-y", "mcp-node-mssql" ], "env": { "DB_HOST": "localhost", "DB_PORT": "1433", "DB_USERNAME": "<username>", "DB_PASSWORD": "<password>", "DB_DATABASE": "<database>" } } } }

Windsurf

See the official Windsurf docs for more information.

  1. Open the Windsurf MCP Configuration Panel
  2. Click Add custom server.
  3. Add the following details and save the file:
{ "mcpServers": { "mssql": { "command": "npx", "args": [ "-y", "mcp-node-mssql" ], "env": { "DB_HOST": "localhost", "DB_PORT": "1433", "DB_USERNAME": "<username>", "DB_PASSWORD": "<password>", "DB_DATABASE": "<database>" } } } }

Claude Code

See the official Claude Code docs for more information.

You can add a new MCP server from the Claude Code CLI. But modifying the json file directly is simpler!

  1. Open the Claude Code configuration file (it should be in ~/.claude.json).
  2. Find the projects > mcpServers section and add the following details and save the file:
{ "projects": { "mcpServers": { "mssql": { "command": "npx", "args": [ "-y", "mcp-node-mssql" ], "env": { "DB_HOST": "localhost", "DB_PORT": "1433", "DB_USERNAME": "<username>", "DB_PASSWORD": "<password>", "DB_DATABASE": "<database>" } } } } }

Issues and Troubleshooting

Before doing anything else, please make sure you are running the latest version!

If you run into problems using this MCP server, please open an issue on GitHub!

Development

Installation

npm install

Build

npm run build

Running the Development Server Locally

To test your local development version of the MCP server rather than using the published package, follow these steps:

  1. Build the project:
npm run build
  1. Create or modify your mcp.json file to reference your local build:
{ "mcpServers": { "mssql": { "command": "node", "args": [ "/path/to/your/local/mcp-node-mssql/dist/index.js" ], "env": { "DB_HOST": "localhost", "DB_PORT": "1433", "DB_USERNAME": "<username>", "DB_PASSWORD": "<password>", "DB_DATABASE": "<database>" } } } }
  1. Place this mcp.json file in one of the following locations:
    • For Cursor: In your home directory (~/.cursor/mcp.json) or in your project directory (.cursor/mcp.json)
    • For Windsurf: Use the MCP Configuration Panel to add the custom server
  2. Restart your AI assistant (Cursor or Windsurf) to load the new configuration.

This allows you to instantly test changes to the MCP server without having to publish a new version.

You must be authenticated.

A
security – no known vulnerabilities
A
license - permissive license
A
quality - confirmed to work

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

Tools

A Model Context Protocol server that enables AI assistants (Cursor, Windsurf, Claude Code) to interact with Microsoft SQL Server databases by providing connectivity through environment-configurable connections.

  1. Usage
    1. Cursor
    2. Windsurf
    3. Claude Code
  2. Issues and Troubleshooting
    1. Development
      1. Installation
      2. Build
      3. Running the Development Server Locally

    Related MCP Servers

    • MSSQL MCP Server

      JexinSam
      -
      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

    • Microsoft SQL Server MCP Server

      RichardHan
      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

    • ClickHouse MCP Server

      dubin555
      -
      security
      -
      license
      -
      quality
      A Model Context Protocol server that enables AI assistants to securely interact with ClickHouse databases, supporting table exploration and SQL query execution through a controlled interface.
      Last updated -
      6
      Python
      Apache 2.0

    • SQLite MCP Server

      santos-404
      -
      security
      A
      license
      -
      quality
      A Model Context Protocol server implementation that enables AI assistants to execute SQL queries and interact with SQLite databases through a structured interface.
      Last updated -
      6
      TypeScript
      MIT License

    View all related MCP servers

    ID: o4qk49s0sp