Skip to main content
Glama

mcp-sqlserver

A powerful Model Context Protocol (MCP) server for Microsoft SQL Server. Connects AI assistants (Claude, Gemini, Kiro, OpenAI, Copilot, Cursor) directly to your SQL Server databases with enterprise-grade security controls.

39 tools across 7 categories: schema discovery, query execution, DDL, stored procedures, performance/DBA diagnostics, developer utilities, and server management.

npm version GitHub release

Changelog: See CHANGELOG.md for version history or GitHub Releases for detailed release notes.

What's New in v1.3

  • Multi-server support — Define dev/staging/prod servers in one config, switch with server parameter

  • list_servers tool — See all configured connections at a glance

  • Per-server security — Each server gets its own security mode, row limits, and blocked databases

  • Backward compatible — Existing single-server configs work without any changes

Related MCP server: mcp-ohmy-sql

What's New in v1.2

  • 16 new tools — DBA diagnostics, code generation, ER diagrams, schema diff, data sampling, and more

  • SQL injection protection — All queries now use parameterized inputs and escaped identifiers

  • ISO date formatting — Dates display as 2025-01-27 instead of raw JavaScript Date strings

  • Streamable HTTP transport — Host the MCP server remotely with --http <port>

  • Health check — Verify connection status and server responsiveness

Features

Server Management (1 tool)

Tool

Description

list_servers

List all configured server connections with host, database, auth, and security mode

Multi-server: Every tool accepts an optional server parameter to target a specific named server. Omit it to use the default server.

Schema Discovery (9 tools)

Tool

Description

list_databases

List all accessible databases on the instance

list_schemas

List schemas in a database

list_tables

List tables with row counts and sizes

list_views

List views in a database

describe_table

Detailed column info: types, defaults, nullability, identity, computed

get_foreign_keys

Foreign key relationships for a table

get_indexes

Index information with included columns

get_constraints

PK, unique, check, and default constraints

get_triggers

Trigger definitions on a table

Query Execution (3 tools)

Tool

Description

execute_query

Run SELECT queries with automatic row limits

execute_mutation

Run INSERT/UPDATE/DELETE/MERGE (requires readwrite mode)

export_query

Export query results as CSV or JSON format

DDL Operations (1 tool)

Tool

Description

execute_ddl

Run CREATE/ALTER/DROP statements (requires admin mode)

Stored Procedures (3 tools)

Tool

Description

list_procedures

List stored procedures in a database

describe_procedure

View parameters and source code of a procedure

execute_procedure

Execute with named parameters (requires readwrite mode)

Performance & DBA (16 tools)

Tool

Description

get_query_plan

Estimated execution plan for any query

get_active_queries

Currently running queries from sys.dm_exec_requests

get_table_stats

Row count, total/used/unused size, and fragmentation %

get_index_usage

Index seeks, scans, lookups, and update statistics

get_missing_indexes

Missing index suggestions with ready-to-use CREATE INDEX DDL

get_server_info

Server version, edition, CPU count, memory, uptime

get_database_info

Database size, file layout, status, recovery model, object counts

get_wait_stats

Top server wait statistics — identifies CPU, I/O, lock bottlenecks

get_deadlocks

Recent deadlock events from the system_health Extended Events session

get_blocking_chains

Current blocking chains — which sessions are blocking others

get_long_transactions

Long-running open transactions that may be holding locks

get_space_usage

Detailed disk space usage by table (data, index, unused)

get_backup_history

Recent backup history: type, size, duration, device path

get_query_store_stats

Top resource-consuming queries from Query Store (SQL Server 2016+) — sortable by CPU, duration, reads, writes, or executions

rebuild_index

Rebuild or reorganize a fragmented index (requires admin mode)

health_check

Connection health check with latency, version, active sessions

Developer Utilities (6 tools)

compare_schemas — Schema Diff

Compare two databases side-by-side. Shows tables, columns, and type differences — perfect for dev vs prod comparison.

compare_schemas(source_database: "DevDB", target_database: "ProdDB")

Output includes: tables only in source/target, columns only in source/target, and column type/nullability differences.

generate_code — Code Generation

Generate typed code from any table's schema:

  • TypeScript — interfaces with proper types (number, string, Date, Buffer | null)

  • C# — classes with nullable value types (int?, DateTime?, decimal?)

  • SQL — CREATE TABLE scripts with full column definitions

generate_code(table: "Products", language: "typescript")
→ export interface Products {
    productId: number;
    productName: string;
    unitPrice: number | null;
    ...
  }

generate_insert_scripts — Data Export as INSERT

Generate INSERT statements from existing table data — useful for migration scripts, seed data, or backing up small reference tables.

generate_insert_scripts(table: "Categories", top: 10)
→ INSERT INTO [dbo].[Categories] ([CategoryName], [Description]) VALUES (N'Beverages', N'Soft drinks...');

generate_er_diagram — ER Diagram

Generate a Mermaid ER diagram from foreign key relationships. Paste the output into any Mermaid-compatible renderer (GitHub, Notion, VS Code, etc.).

generate_er_diagram(database: "Northwind")
→ erDiagram
    Products }o--|| Categories : "CategoryID"
    Products }o--|| Suppliers : "SupplierID"
    Orders }o--|| Customers : "CustomerID"
    ...

generate_test_data — Test Data Generation

Generate realistic INSERT statements with fake data based on column names and types. Smart heuristics for common patterns (email, phone, name, city, price, etc.).

generate_test_data(table: "Customers", count: 5)
→ INSERT INTO [dbo].[Customers] (...) VALUES (N'Alice', N'user1@example.com', N'New York', ...);

sample_table — Random Sampling

Get a random sample of rows from any table using NEWID() — useful for AI assistants to understand data patterns without scanning entire tables.

sample_table(table: "Orders", count: 5)

Security

Three Security Modes

Mode

SELECT

INSERT/UPDATE/DELETE

DDL

Stored Procedures

readonly

Yes

No

No

Read-only (list/describe)

readwrite

Yes

Yes

No

Full (execute)

admin

Yes

Yes

Yes

Full (execute)

SQL Injection Protection

All user-provided values are passed as parameterized query inputs (@param). Object identifiers (database, schema, table names) are escaped using SQL Server bracket notation ([name] with ] → ]]).

Additional Security Features

  • Database and schema allow/block lists

  • Automatic row count limits (configurable maxRowCount)

  • Blocked keyword detection (xp_cmdshell, SHUTDOWN, DROP DATABASE, etc.)

  • Column-level data masking for PII protection

  • Query type validation per security mode

Data Masking

Mask sensitive columns in query results:

security:
  maskColumns:
    - pattern: "*.password"
      mask: "***"
    - pattern: "*.ssn"
      mask: "XXX-XX-XXXX"
    - pattern: "dbo.users.email"
      mask: "***@***.***"

Pattern format: [schema.]table.column (use * as wildcard)

Authentication

Method

Config type

Requirements

SQL Server

sql

user + password

Windows (NTLM)

windows

user + password + optional domain

Windows (SSPI)

windows

No credentials needed; requires msnodesqlv8

Azure AD

azure-ad

clientId + clientSecret + tenantId

Windows Authentication

NTLM — Works out of the box, no extra packages:

connection:
  host: YOUR_SERVER\SQLEXPRESS
  authentication:
    type: windows
    user: YourUsername
    password: YourPassword
    domain: YOUR_DOMAIN
  trustServerCertificate: true

SSPI / Integrated Security — Uses current Windows login session:

npm install msnodesqlv8
connection:
  host: YOUR_SERVER\SQLEXPRESS
  authentication:
    type: windows
  trustServerCertificate: true

Note: When using npx, optional dependencies like msnodesqlv8 may not be installed automatically. For SSPI, consider installing globally (npm install -g @tugberkgunver/mcp-sqlserver msnodesqlv8) or use NTLM mode instead.

Transport

stdio (Default)

Standard input/output transport — used by MCP clients like Claude Desktop, VS Code, Cursor, etc.

Streamable HTTP

For remote hosting or web integrations:

mcp-sqlserver --config mssql-mcp.yaml --http 3000

This starts:

  • MCP endpoint: http://localhost:3000/mcp

  • Health check: http://localhost:3000/health → {"status":"ok","mode":"readonly"}

Includes CORS support for browser-based clients.

Quick Start

Install

npm install -g @tugberkgunver/mcp-sqlserver

Configure

Create mssql-mcp.yaml in your working directory:

connection:
  host: localhost
  port: 1433
  database: MyDatabase
  authentication:
    type: sql
    user: sa
    password: YourPassword123
  trustServerCertificate: true

security:
  mode: readonly
  maxRowCount: 1000
  blockedDatabases:
    - master
    - msdb
    - tempdb
    - model

See config.example.yaml for all options.

Multi-Server Configuration

Define multiple named servers to manage dev/staging/prod from a single config:

defaultServer: dev

connections:
  dev:
    host: dev-server.example.com
    database: MyDatabase
    authentication:
      type: sql
      user: sa
      password: DevPass123
    trustServerCertificate: true
    security:
      mode: admin
      maxRowCount: 5000

  prod:
    host: prod-server.example.com
    database: MyDatabase
    authentication:
      type: sql
      user: readonly_user
      password: ProdReadOnly
    security:
      mode: readonly
      blockedDatabases: [master, msdb, tempdb, model]

# Global security defaults (applied to all servers unless overridden)
security:
  maxRowCount: 1000
  blockedKeywords: [xp_cmdshell, SHUTDOWN, DROP DATABASE]

Then use the server parameter in any tool call:

list_tables(server: "prod", database: "MyDatabase")
health_check(server: "dev")
compare_schemas(source_database: "DevDB", target_database: "StagingDB", server: "dev")

MCP Client Configuration

{
  "mcpServers": {
    "mssql": {
      "command": "npx",
      "args": ["-y", "@tugberkgunver/mcp-sqlserver"],
      "env": {
        "MSSQL_HOST": "localhost",
        "MSSQL_DATABASE": "MyDatabase",
        "MSSQL_USER": "sa",
        "MSSQL_PASSWORD": "YourPassword123"
      }
    }
  }
}

With a config file:

{
  "mcpServers": {
    "mssql": {
      "command": "npx",
      "args": ["-y", "@tugberkgunver/mcp-sqlserver", "--config", "/path/to/mssql-mcp.yaml"]
    }
  }
}

Add to .vscode/mcp.json:

{
  "servers": {
    "mssql": {
      "command": "npx",
      "args": ["-y", "@tugberkgunver/mcp-sqlserver"],
      "env": {
        "MSSQL_HOST": "localhost",
        "MSSQL_DATABASE": "MyDatabase",
        "MSSQL_USER": "sa",
        "MSSQL_PASSWORD": "YourPassword123"
      }
    }
  }
}

Add to ~/.cursor/mcp.json:

{
  "mcpServers": {
    "mssql": {
      "command": "npx",
      "args": ["-y", "@tugberkgunver/mcp-sqlserver"],
      "env": {
        "MSSQL_HOST": "localhost",
        "MSSQL_DATABASE": "MyDatabase",
        "MSSQL_USER": "sa",
        "MSSQL_PASSWORD": "YourPassword123"
      }
    }
  }
}

Add to .kiro/settings/mcp.json:

{
  "mcpServers": {
    "mssql": {
      "command": "npx",
      "args": ["-y", "@tugberkgunver/mcp-sqlserver"],
      "env": {
        "MSSQL_HOST": "localhost",
        "MSSQL_DATABASE": "MyDatabase",
        "MSSQL_USER": "sa",
        "MSSQL_PASSWORD": "YourPassword123"
      }
    }
  }
}

Add to ~/.gemini/settings.json:

{
  "mcpServers": {
    "mssql": {
      "command": "npx",
      "args": ["-y", "@tugberkgunver/mcp-sqlserver"],
      "env": {
        "MSSQL_HOST": "localhost",
        "MSSQL_DATABASE": "MyDatabase",
        "MSSQL_USER": "sa",
        "MSSQL_PASSWORD": "YourPassword123"
      }
    }
  }
}
{
  "mcpServers": {
    "mssql": {
      "command": "npx",
      "args": ["-y", "@tugberkgunver/mcp-sqlserver"],
      "env": {
        "MSSQL_HOST": "localhost",
        "MSSQL_DATABASE": "MyDatabase",
        "MSSQL_USER": "sa",
        "MSSQL_PASSWORD": "YourPassword123"
      }
    }
  }
}

Add to ~/.windsurf/mcp.json:

{
  "mcpServers": {
    "mssql": {
      "command": "npx",
      "args": ["-y", "@tugberkgunver/mcp-sqlserver"],
      "env": {
        "MSSQL_HOST": "localhost",
        "MSSQL_DATABASE": "MyDatabase",
        "MSSQL_USER": "sa",
        "MSSQL_PASSWORD": "YourPassword123"
      }
    }
  }
}

On Windows, use cmd as the command wrapper:

{
  "mcpServers": {
    "mssql": {
      "command": "cmd",
      "args": ["/c", "npx", "-y", "@tugberkgunver/mcp-sqlserver", "--config", "path/to/config.yaml"]
    }
  }
}

Environment Variables

Variable

Description

MSSQL_HOST

SQL Server hostname

MSSQL_PORT

SQL Server port (default: 1433)

MSSQL_DATABASE

Default database

MSSQL_USER

SQL auth username

MSSQL_PASSWORD

SQL auth password

MSSQL_MCP_CONFIG

Path to YAML config file

Environment variables override config file values.

Development

git clone https://github.com/gunvertugberk/mcp-sqlserver.git
cd mcp-sqlserver
npm install
npm run build
npm start -- --config ./mssql-mcp.yaml

License

MIT

Available Tools

38 tools
compare_schemasB

Compare schemas between two databases — shows tables, columns, and indexes that differ (useful for dev vs prod comparison)

Inputs: source_database (required), target_database (required), schema, server.

describe_procedureA

Get parameter information and source code for a stored procedure

Inputs: procedure (required), schema, database, server.

describe_tableA

Get detailed column information for a table or view (columns, types, defaults, nullability, identity, computed)

Inputs: table (required), schema, database, server.

execute_mutationA

Execute a data modification query (INSERT, UPDATE, DELETE, MERGE). Requires readwrite or admin security mode.

Inputs: sql (required), database, server.

execute_procedureB

Execute a stored procedure with parameters. Requires readwrite or admin security mode.

Inputs: procedure (required), schema, parameters, database, +1 more.

execute_queryB

Execute a read-only SQL query (SELECT). Automatically applies row limits from configuration.

Inputs: sql (required), database, server.

export_queryB

Execute a SELECT query and return results as CSV or JSON format

Inputs: sql (required), format (required), database, server.

generate_codeB

Generate TypeScript interface, C# class, or CREATE TABLE script from a table's schema

Inputs: table (required), language (required), schema, database, +1 more.

generate_er_diagramB

Generate a Mermaid ER diagram from database foreign key relationships

Inputs: database, schema, server.

generate_insert_scriptsA

Generate INSERT statements from existing table data (for migration/seeding)

Inputs: table (required), schema, database, top, +1 more.

generate_test_dataB

Generate INSERT statements with realistic fake/test data based on table schema

Inputs: table (required), schema, database, count, +1 more.

get_active_queriesB

Show currently running queries on the server (from sys.dm_exec_requests)

Inputs: server.

get_backup_historyB

Get recent backup history for a database from msdb

Inputs: database, top, server.

get_blocking_chainsB

Show current blocking chains — which sessions are blocking others

Inputs: server.

get_constraintsB

Get constraints (PK, unique, check, default) for a table

Inputs: table (required), schema, database, server.

get_database_infoC

Get detailed database information: size, files, status, recovery model

Inputs: database, server.

get_deadlocksA

Get recent deadlock events from the system_health Extended Events session

Inputs: server.

get_foreign_keysC

Get foreign key relationships for a table

Inputs: table (required), schema, database, server.

get_indexesC

Get index information for a table

Inputs: table (required), schema, database, server.

get_index_usageC

Get index usage statistics: seeks, scans, lookups, and updates (from sys.dm_db_index_usage_stats)

Inputs: table (required), schema, database, server.

get_long_transactionsB

Show long-running open transactions that may be holding locks

Inputs: server.

get_missing_indexesC

Get missing index suggestions from SQL Server DMVs (sys.dm_db_missing_index_details)

Inputs: database, server.

get_query_planA

Get the estimated execution plan for a SQL query (without executing it)

Inputs: sql (required), database, server.

get_query_store_statsA

Get top resource-consuming queries from Query Store (SQL Server 2016+). Query Store must be enabled on the database.

Inputs: database, sort_by, top, server.

get_server_infoA

Get SQL Server instance information: version, edition, OS, memory, CPU

Inputs: server.

get_space_usageC

Get detailed disk space usage by table in a database

Inputs: database, top, server.

get_table_statsB

Get table statistics: row count, total size, index size, and fragmentation

Inputs: table (required), schema, database, server.

get_triggersB

Get triggers defined on a table

Inputs: table (required), schema, database, server.

get_wait_statsB

Get top server wait statistics — identifies performance bottlenecks (CPU, I/O, locks, etc.)

Inputs: top, server.

health_checkC

Check SQL Server connection health and basic responsiveness

Inputs: server.

list_databasesA

List all accessible databases on the SQL Server instance

Inputs: server.

list_proceduresA

List all stored procedures in a database, optionally filtered by schema

Inputs: database, schema, server.

list_schemasA

List all schemas in the current database

Inputs: database, server.

list_serversA

List all configured SQL Server connections and their details (host, database, auth type, security mode)

Inputs: no named parameters.

list_tablesA

List all tables in a database, optionally filtered by schema

Inputs: database, schema, server.

list_viewsA

List all views in a database, optionally filtered by schema

Inputs: database, schema, server.

rebuild_indexB

Rebuild or reorganize a fragmented index. Requires admin security mode.

Inputs: table (required), index (required), schema, database, +2 more.

sample_tableA

Get a random sample of rows from a table (useful for understanding data patterns)

Inputs: table (required), schema, database, count, +1 more.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3.4/5.0

    Scored across 38 tools

    Disambiguation5/5

    Each tool has a clear, distinct purpose, covering different aspects of SQL Server management like schema comparison, query execution, performance monitoring, and code generation. No two tools appear to do the same thing, and descriptions clearly differentiate them.

    Naming Consistency5/5

    All tool names follow a consistent verb_noun pattern with lowercase and underscores (e.g., describe_table, get_indexes, execute_query). This makes it easy for agents to predict and understand the function of each tool.

    Tool Count2/5

    With 38 tools, the server is overly heavy for typical MCP usage. While the scope is broad, this many tools can overwhelm agents and slow down selection. A more focused set of 15-25 would be more appropriate.

    Completeness4/5

    The tool set covers a wide range of SQL Server operations: discovery, querying, mutation, monitoring, maintenance, and code generation. Minor gaps exist (e.g., no DDL operations like create/alter table or kill session), but the core needs are well addressed.

    Maintenance

    ActivityNo data
    ResponsivenessOutdated data

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      A
      quality
      Not graded
      maintenance
      Enables AI assistants to interact with both local SQL Server and Azure SQL Database through natural language, supporting queries, data manipulation, and schema operations with built-in security features.
      8
      2,101 npm
      1
      -
    • -
      license
      Not graded
      quality
      D
      maintenance
      An MCP server that bridges AI assistants with SQL databases, enabling natural language querying across multiple database types with built-in optimization and security.
      3
      -
    • A
      license
      B
      quality
      D
      maintenance
      An MCP server that connects AI assistants to Microsoft SQL Server databases, enabling schema exploration and read-only queries safely.
      49
      6
      MIT
    • A
      license
      Not graded
      quality
      B
      maintenance
      An MCP server that enables AI assistants to query and manage Microsoft SQL Server databases using natural language.
      142 npm
      5
      MIT