Mcp Sqlserver

Name: Mcp Sqlserver
Author: bilims

@bilims

Repository

About Mcp Sqlserver

No overview available yet

#mcp-sqlserver #sql-server #database-management

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mcp-sqlserver": {
      "command": "npx",
      "args": [
        "-y",
        "@bilims/mcp-sqlserver"
      ],
      "env": {
        "SQLSERVER_HOST": "your-server-host",
        "SQLSERVER_DATABASE": "your-database",
        "SQLSERVER_USERNAME": "your-username",
        "SQLSERVER_PASSWORD": "your-password"
      }
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Mcp Sqlserver?

Mcp Sqlserver is a Model Context Protocol (MCP) server that enables AI agents to securely interact with Microsoft SQL Server databases. It provides CRUD operations, schema introspection, stored procedure execution, transaction management, and bulk operations for production environments.

How to use Mcp Sqlserver?

Install and configure via NPX (recommended), global npm installation, or from source. Create a .env file with SQL Server credentials and add the server configuration (command, args, env) to your Claude Desktop MCP settings (claude_desktop_config.json). The server exposes 22 tools accessible from any MCP‑compatible client.

Key features of Mcp Sqlserver

Complete CRUD operations (SELECT, INSERT, UPDATE, DELETE)
Schema introspection for databases, tables, columns, and indexes
Stored procedure execution with parameters and multiple result sets
Transaction management with isolation levels and savepoints
High‑performance bulk insert, batch update/delete, and CSV/JSON import
All queries use parameterized inputs to prevent SQL injection

Use cases of Mcp Sqlserver

AI‑powered data analysis and reporting on SQL Server databases
Automated database maintenance and schema exploration
Intelligent application backends that query and modify data on demand
Bulk data loading and transformation tasks via AI agents
Secure, controlled database operations within MCP‑compatible chat assistants

FAQ from Mcp Sqlserver

What are the runtime requirements?

Node.js 20+, TypeScript 5.0+, and Microsoft SQL Server 2016+ are required.

How is data kept secure?

All queries use parameterized inputs to prevent SQL injection, DDL operations are blocked in custom queries, and connections include validation, health checks, and timeout controls.

Where does the server store configuration?

Database credentials and connection pool settings are stored in a .env file or passed as environment variables in the MCP client configuration.

Which transports are supported?

The server uses the standard MCP transport. It is designed for use with Claude Desktop and any MCP‑compatible client.

What is the maximum number of tools available?

22 tools are provided, covering core database operations, stored procedures, transaction management, and bulk operations.

Comments

More Databases MCP servers

MCP MongoDB Server

kiliczsh

A Model Context Protocol Server for MongoDB

281

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K