MSSQL DBA

Name: MSSQL DBA
Author: dba-i

@dba-i

关于 MSSQL DBA

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

基本信息

分类

数据库

传输方式

stdio

发布者

dba-i

提交者

Evgenii Vaniukov

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "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"
      }
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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.

FAQ from MSSQL DBA

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.

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.

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.

What are the optional configuration parameters?

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

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.

数据库分类下的更多 MCP 服务器

MongoDB Lens

furey

🍃🔎 MongoDB Lens: Full Featured MCP Server for MongoDB Databases

204

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