What can you do with this server?

The mcp-mssqlserver server enables interaction with Microsoft SQL Server databases through the following tools: * Execute SQL Queries (execute_query): Run any SQL statement including SELECT, INSERT, UPDATE, and DELETE, returning recordsets or affected row counts. * List Databases (list_databases): Enumerate all available databases on the connected SQL Server instance. * List Tables (list_tables): Discover all tables in the current database, with an optional filter by schema name. * Describe Table (describe_table): Inspect a table's structure, including column names, data types, nullability, default values, and primary key markers. * Get Table Indexes (get_table_indexes): Retrieve index information for a table, including index type, uniqueness, primary key status, and indexed columns. * Get Foreign Keys (get_foreign_keys): List all foreign key constraints on a table along with their referenced tables and columns.

Which integrations are available for this server?

Provides a remote MCP endpoint for n8n's MCP Client Tool node to interact with SQL Server databases.

How do I use mcp-mssqlserver?

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., "@mcp-mssqlserver list all tables in the database" 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.

de en es zh

mcp-mssqlserver

by ferronicardoso

Overview Schema Related Servers Score Discussions

JavaScript

Remote

MCP Server for Microsoft SQL Server

Docker Publish GHCR Node.js

Production-oriented MCP server for Microsoft SQL Server, exposing database operations to MCP clients (Claude Desktop, VS Code Copilot, Cursor, and compatible hosts).

Features

Query execution (SELECT, INSERT, UPDATE, DELETE)
Database discovery and schema introspection
Table metadata inspection (columns, types, nullability, defaults, PK)
Index and foreign key discovery
Environment-driven configuration for secure deployment

Related MCP server: SQL Query Tools MCP Server

Available Tools

Tool	Description
`execute_query`	Executes a SQL statement and returns recordsets or affected rows
`list_tables`	Lists tables from `INFORMATION_SCHEMA.TABLES` (optional schema filter)
`describe_table`	Returns table column metadata and primary key markers
`list_databases`	Lists all SQL Server databases
`get_table_indexes`	Lists table indexes, type, uniqueness, PK, and indexed columns
`get_foreign_keys`	Lists table foreign keys and referenced targets

Requirements

Node.js 18+
Access to a Microsoft SQL Server instance
Network connectivity from MCP host to SQL Server (host:port)

Configuration

Set connection settings using environment variables:

Variable	Required	Default	Description
`MSSQL_HOST`	No	`localhost`	SQL Server host or IP
`MSSQL_PORT`	No	`1433`	SQL Server TCP port
`MSSQL_DATABASE`	Yes	—	Default database
`MSSQL_AUTH_MODE`	No	`sql`	Authentication mode: `sql` or `windows`
`MSSQL_USER`	Yes*	—	SQL login user (required only in `sql`)
`MSSQL_PASSWORD`	Yes*	—	SQL login password (required only in `sql`)
`MSSQL_ENCRYPT`	No	`false`	Enables encrypted connection
`MSSQL_TRUST_SERVER_CERTIFICATE`	No	`true`	Trusts server certificate when encryption is enabled

* Required when MSSQL_AUTH_MODE=sql.

| MCP_TRANSPORT | No | stdio | Transport mode: stdio (default, for npx/Claude Desktop/VS Code) or http (Streamable HTTP, for Docker/remote clients such as n8n) | | MCP_HTTP_PORT | No | 3001 | Port for the HTTP server (only used when MCP_TRANSPORT=http) | | MCP_HTTP_HOST | No | 0.0.0.0 | Bind address for the HTTP server (only used when MCP_TRANSPORT=http) |

Note: the published Docker image always runs in http mode and does not build the msnodesqlv8 native driver (used only for MSSQL_AUTH_MODE=windows). Windows Authentication is only available when running the server directly on a Windows host via npx/npm start.

Usage

Run directly from GitHub

npx github:ferronicardoso/mcp-mssqlserver

Claude Code (CLI)

claude mcp add mssqlserver --scope user -- npx -y github:ferronicardoso/mcp-mssqlserver

--scope controls where the server registration is stored:

Scope	Stored in	Visible to
`local` (default)	project-local, untracked	only you, only in this project
`project`	`.mcp.json` at the project root	anyone who clones the repo (commit it to share)
`user`	your global Claude Code config	you, across every project

Environment variables can be passed with repeated --env KEY=VALUE flags before the --, e.g.:

Bash (Linux/macOS/WSL):

claude mcp add mssqlserver --scope user \
  --env MSSQL_HOST=localhost \
  --env MSSQL_PORT=1433 \
  --env MSSQL_DATABASE=master \
  --env MSSQL_AUTH_MODE=sql \
  --env MSSQL_USER=sa \
  --env MSSQL_PASSWORD=your-password \
  -- npx -y github:ferronicardoso/mcp-mssqlserver

PowerShell:

claude mcp add mssqlserver --scope user `
  --env MSSQL_HOST=localhost `
  --env MSSQL_PORT=1433 `
  --env MSSQL_DATABASE=master `
  --env MSSQL_AUTH_MODE=sql `
  --env MSSQL_USER=sa `
  --env MSSQL_PASSWORD=your-password `
  -- npx -y github:ferronicardoso/mcp-mssqlserver

Codex CLI

Bash (Linux/macOS/WSL):

codex mcp add mssqlserver \
  --env MSSQL_AUTH_MODE=sql \
  --env MSSQL_HOST=localhost \
  --env MSSQL_PORT=1433 \
  --env MSSQL_DATABASE=master \
  --env MSSQL_USER=sa \
  --env MSSQL_PASSWORD=your-password \
  npx -- -y github:ferronicardoso/mcp-mssqlserver

PowerShell:

codex mcp add mssqlserver `
  --env MSSQL_AUTH_MODE=sql `
  --env MSSQL_HOST=localhost `
  --env MSSQL_PORT=1433 `
  --env MSSQL_DATABASE=master `
  --env MSSQL_USER=sa `
  --env MSSQL_PASSWORD=your-password `
  npx -- -y github:ferronicardoso/mcp-mssqlserver

For Windows Authentication instead, drop MSSQL_USER/MSSQL_PASSWORD and set MSSQL_AUTH_MODE=windows:

Bash (Linux/macOS/WSL):

codex mcp add mssqlserver \
  --env MSSQL_AUTH_MODE=windows \
  --env MSSQL_HOST=localhost \
  --env MSSQL_PORT=1433 \
  --env MSSQL_DATABASE=master \
  npx -- -y github:ferronicardoso/mcp-mssqlserver

PowerShell:

codex mcp add mssqlserver `
  --env MSSQL_AUTH_MODE=windows `
  --env MSSQL_HOST=localhost `
  --env MSSQL_PORT=1433 `
  --env MSSQL_DATABASE=master `
  npx -- -y github:ferronicardoso/mcp-mssqlserver

This registers the server in ~/.codex/config.toml. To remove it, run codex mcp remove mssqlserver.

Claude Desktop configuration

%APPDATA%\\Claude\\claude_desktop_config.json:

{
  "mcpServers": {
    "mssqlserver": {
      "command": "npx",
      "args": ["github:ferronicardoso/mcp-mssqlserver"],
      "env": {
        "MSSQL_HOST": "localhost",
        "MSSQL_PORT": "1433",
        "MSSQL_DATABASE": "master",
        "MSSQL_AUTH_MODE": "sql",
        "MSSQL_USER": "sa",
        "MSSQL_PASSWORD": "your-password"
      }
    }
  }
}

VS Code MCP configuration

.vscode/mcp.json:

{
  "servers": {
    "mssqlserver": {
      "command": "npx",
      "args": ["github:ferronicardoso/mcp-mssqlserver"],
      "env": {
        "MSSQL_HOST": "localhost",
        "MSSQL_PORT": "1433",
        "MSSQL_DATABASE": "master",
        "MSSQL_AUTH_MODE": "sql",
        "MSSQL_USER": "sa",
        "MSSQL_PASSWORD": "your-password"
      }
    }
  }
}

Run with Docker (HTTP transport)

The published image runs in Streamable HTTP mode by default, for use as a remote MCP endpoint (e.g. from n8n's MCP Client Tool node or any Streamable HTTP-compatible client):

Bash (Linux/macOS/WSL):

docker run -d --name mcp-mssqlserver \
  -p 3001:3001 \
  -e MSSQL_HOST=host.docker.internal \
  -e MSSQL_PORT=1433 \
  -e MSSQL_DATABASE=master \
  -e MSSQL_AUTH_MODE=sql \
  -e MSSQL_USER=sa \
  -e MSSQL_PASSWORD=your-password \
  ghcr.io/ferronicardoso/mcp-mssqlserver:latest

PowerShell:

docker run -d --name mcp-mssqlserver `
  -p 3001:3001 `
  -e MSSQL_HOST=host.docker.internal `
  -e MSSQL_PORT=1433 `
  -e MSSQL_DATABASE=master `
  -e MSSQL_AUTH_MODE=sql `
  -e MSSQL_USER=sa `
  -e MSSQL_PASSWORD=your-password `
  ghcr.io/ferronicardoso/mcp-mssqlserver:latest

The MCP endpoint is then available at http://localhost:3001/mcp.

Local Development

git clone https://github.com/ferronicardoso/mcp-mssqlserver
cd mcp-mssqlserver
npm install
npm run build

Start the compiled server:

npm start

Build and Commit Workflow

This repository intentionally tracks dist/ to support npx github:user/repo usage.

The project uses a Husky pre-commit hook to:

build TypeScript (npm run build)
stage generated artifacts (git add dist)

Manual fallback:

npm run build
git add dist

Security Notes

Never commit real credentials or .env files.
Prefer least-privilege SQL users for production use.
For public or untrusted networks, enable encryption (MSSQL_ENCRYPT=true) and configure certificates appropriately.

Windows Authentication (Integrated Security)

To use Windows Authentication with Integrated Security (process account), configure:

MSSQL_AUTH_MODE=windows
MSSQL_HOST=sqlserver.company.local
MSSQL_PORT=1433
MSSQL_DATABASE=master

License

Install Server

license - permissive license

quality

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

–Release cycle

–Releases (12mo)

Commit activity

Resources

GitHub Repository

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Tools

Related MCP Servers

mcp-server-mssql
Databases Developer Tools
daedalus
A
license
Not graded
quality
C
maintenance
Provides tools to connect, query, and manage Microsoft SQL Server databases through the MCP protocol, including support for stored procedures, transactions, and schema inspection.
Updated 4 months ago (2026-04-21 19:28 UTC)
MIT
SQL Query Tools MCP Server
Databases Security
negrip
F
license
A
quality
D
maintenance
MCP server for connecting to SQL Server in readonly mode. Allows any MCP client to explore the schema and run SELECT queries against a SQL Server database.
Updated 5 months ago (2026-04-01 20:52 UTC)
6
mssql-mcp-server
Databases Developer Tools
thochi
A
license
Not graded
quality
D
maintenance
MCP server for executing SQL queries and managing connections to Microsoft SQL Server databases.
Updated 2 years ago (2025-02-15 13:10 UTC)
3,043
1
MIT
SJSINGLE_AI SQL Server MCP
Databases AI & Machine Learning
DhruviPatel712
A
license
Not graded
quality
C
maintenance
MCP server for Microsoft SQL Server enabling safe read-only queries, schema discovery, and natural-language query via LangChain.
Updated 2 months ago (2026-06-27 10:03 UTC)
MIT

View all related MCP servers

Related MCP Connectors

mcp
MCP server for managing Prisma Postgres.
Supabase
MCP server for interacting with the Supabase platform
classquill-mcp
Read-only MCP server for ClassQuill, a tutoring-business-management platform.

View all MCP Connectors

Latest Blog Posts

Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)
By Om-Shree-0709 on July 25, 2026.
mcp
Agent Identity
OAuth 2.1
Your AI Chatbot Just Exposed Your CEO's Salary to an Intern
By Om-Shree-0709 on July 2, 2026.
Agent Identity
MCP Security
OAuth Delegation
Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/ferronicardoso/mcp-mssqlserver'

If you have feedback or need assistance with the MCP directory API, please join our Discord server

MCP Server for Microsoft SQL Server

Features

Available Tools

Requirements

Configuration

Usage

Run directly from GitHub

Claude Code (CLI)

Codex CLI

Claude Desktop configuration

VS Code MCP configuration

Run with Docker (HTTP transport)

Local Development

Build and Commit Workflow

Security Notes

Windows Authentication (Integrated Security)

License

Maintenance

Resources

Looking for Admin?

Tools

Related MCP Servers

mcp-server-mssql

SQL Query Tools MCP Server

mssql-mcp-server

SJSINGLE_AI SQL Server MCP

Related MCP Connectors

Latest Blog Posts

MCP directory API