Last updated
March 16, 2026
MCP profile
Github Dba I Mssql Dba
An MCP server that provides [describe what your server does]
Developer ToolsPackageJavaScript/TypeScriptOpen SourceExternal
Visibility
Public
ByRegistry
About This MCP Server
The server provides context to an LLM, empowering models to complete various Database Administration tasks, such as optimizing queries, 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 their potential in completing DBA tasks. For feedback, questions, or support, please join our Discord!
Tools & Endpoints1
Example Workflow
• 127 executions over the past week
• Average duration: 5,234ms (Critical performance)
• High logical reads: 45,000+ pages per execution
• Execution plan ID: 142
• Orders table: 2.5M rows, clustered index on OrderID
• Customers table: 500K rows, missing index on CustomerRegion
• Current indexes show fragmentation >30%
• customer_orders_report_schema_optimizations.sql - New filtered index on Orders(CustomerID, OrderDate) INCLUDE (TotalAmount) and non-clustered index on Customers(CustomerRegion, CustomerID)
• customer_orders_report_rollback_script.sql - DROP statements for safe rollback
• Detailed documentation explaining why each optimization improves query performance
What Problems It Solves
- There is a partial list of existing clients at modelcontextprotocol.io. Consult their documentation to install the MCP server.
Specifications
Status
live
Industry
Developer Tools
Category
General
Server type
Package
Language
JavaScript/TypeScript
License
Open Source
Verified
Yes
Hosting
Hosting Options
- Package
API
Integrate this server into your application. Choose a connection method below.
1
Configure
Configuration
json
{
"mcpServers": {
"mssql-dba": {
"command": "npx",
"args": ["@dba-i/mssql-dba"],
"env": {
// Required Parameters
"DB_HOST": "host",
"DB_PORT": "1433",
"DB_USER": "dbai",
"DB_PASSWORD": "password",
"DB_NAME": "database name",
// Optional Parameters
"TRUST_SERVER_CERTIFICATE": "true",
"ENCRYPT": "false",
"MAX_POOL": "10",
"MIN_POOL": "0",
"IDLE": "30000"
}
}
}
}Performance
Usage
Quick Reference
- Name
- Github Dba I Mssql Dba
- Function
- An MCP server that provides [describe what your server does]
- Available Tools
- The MCP server exposes the following tools organized by scope:
- Transport
- Package
- Language
- JavaScript/TypeScript
- Source
- External (Registry)
- License
- Open Source
Get started
Ready to integrate this MCP server?
Book a demo to see how this server fits your workflow, or explore the full catalog.