MCP Sqlserver

@bilims

Basic information

About MCP Sqlserver

No overview available yet

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

MCP Sqlserver 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"
      }
    }
  }
}

MCP Sqlserver tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

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

Frequently asked questions

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

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397