Advertise
MCP.so
Sign In
M

MSSQL DBA MCP Server

@dba-i

Repository

Basic information

Category

Databases

Transports

stdio

Author

dba-i

Submitted by

Evgenii Vaniukov

About MSSQL DBA MCP Server

The server provides context to an LLM, empowering models to complete various Database Administration tasks, such as improving table health, optimizing existing indexes, and identifying missing ones. The server aims to find the best way to provide context so the LLMs can maximize

#dba#database-administration

MSSQL DBA MCP Server config

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

{
  "mcpServers": {
    "mssql-dba": {
      "command": "npx",
      "args": [
        "@dba-i/mssql-dba"
      ],
      "env": {
        "DB_HOST": "host",
        "DB_PORT": "1433",
        "DB_USER": "user",
        "DB_PASSWORD": "password",
        "DB_NAME": "database name",
        "TRUST_SERVER_CERTIFICATE": "true",
        "ENCRYPT": "false",
        "MAX_POOL": "10",
        "MIN_POOL": "0",
        "IDLE": "30000"
      }
    }
  }
}

MSSQL DBA MCP Server 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 MSSQL DBA?

MSSQL DBA is an MCP (Model Context Protocol) server that provides structured database context to LLMs, enabling automated SQL Server administration tasks such as index optimization, query performance tuning, and schema health analysis. It is built for database administrators and developers working with Microsoft SQL Server.

How to use MSSQL DBA?

Configure the server by adding an entry to your MCP client’s configuration file (e.g., claude_desktop_config.json) using the npx command and supplying required environment variables (host, port, user, password, database name). Optional parameters include trust server certificate, encryption, and connection pooling settings. The server currently supports only SQL Server Authentication.

Key features of MSSQL DBA

  • Provides prompts to optimize SQL queries and indexes.
  • Exposes tools for table metadata, index health, and missing indexes.
  • Retrieves server-level information (version, timezone).
  • Analyzes database collation and identifies mismatches.
  • Generates optimization scripts with rollback and maintenance procedures.

Use cases of MSSQL DBA

  • Automate index maintenance and missing index detection.
  • Optimize slow-running SQL queries with schema-level suggestions.
  • Assess and report on index health across specified tables.
  • Detect and resolve collation mismatches within a database.

Frequently asked questions

1

What prerequisites are needed to run MSSQL DBA?

Create a SQL Server login with `VIEW SERVER STATE` and `VIEW DEFINITION` permissions, and ensure the server uses SQL Server Authentication. The server runs via `npx` and Node.js.

2

Does MSSQL DBA support Windows Authentication or other transport methods?

No, the server currently supports only SQL Server Authentication. It uses the stdio transport and runs as an MCP client tool via `npx`.

3

Where does MSSQL DBA store data or context?

The server does not persist data; it connects to a live SQL Server instance and returns context to the LLM in real time. No local storage is involved.

4

What are the optional configuration parameters?

Optional environment variables include `TRUST_SERVER_CERTIFICATE`, `ENCRYPT`, `MAX_POOL`, `MIN_POOL`, and `IDLE` for connection pooling behavior.

5

Can MSSQL DBA work with databases that have collation differences?

Yes, it provides a `get-collation-mismatches` tool that identifies columns with collation settings differing from the database default.

Comments

More Databases MCP servers

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

4

Postgres Mcp

crystaldba

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

3.0K

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

Advertise