vicagbasi/mssql-mcp

3.2

If you are the rightful owner of mssql-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

A comprehensive Model Context Protocol (MCP) server for Microsoft SQL Server database analysis and modernization.

Tools

Functions exposed to the LLM to take actions

test_connection

Test database connectivity and get server information.

list_connections

List all available named database connections.

list_databases

List all available databases on the SQL Server instance.

list_tables

List all tables in a specific schema (default: dbo).

describe_table

Get detailed schema information including columns, data types, and constraints.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

vicagbasi

Claim Ownership

Verify you have write access to the repository

Repository

https://github.com/vicagbasi/mssql-mcp

License

MIT License

Last publish date

2025-06-26

Last update date

2025-08-06

Server configs

in claude desktop

{
  "mcpServers": {
    "mssql-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": ["mssql-mcp-server"],
      "env": {
        "WINDOWS_USERNAME": "your-domain-username",
        "WINDOWS_PASSWORD": "your-secure-password",
        "WINDOWS_DOMAIN": "YOUR-DOMAIN",
        "MSSQL_CONNECTION_STRING": "Data Source=main-server; Initial Catalog=MainDB; Integrated Security=SSPI; TrustServerCertificate=True;"
      }
    }
  }
}

in vs code

{
  "mcp": {
    "servers": {
      "mssql-mcp": {
        "type": "stdio",
        "command": "npx",
        "args": ["mssql-mcp-server"],
        "env": {
          "WINDOWS_USERNAME": "your-domain-username",
          "WINDOWS_PASSWORD": "your-secure-password",
          "WINDOWS_DOMAIN": "YOUR-DOMAIN",
          "MSSQL_CONNECTION_STRING": "Data Source=main-server; Initial Catalog=MainDB; Integrated Security=SSPI; TrustServerCertificate=True;"
        }
      }
    }
  }
}

in cursor

{
  "mcp": {
    "servers": {
      "mssql-mcp": {
        "type": "stdio",
        "command": "npx",
        "args": ["mssql-mcp-server"],
        "env": {
          "WINDOWS_USERNAME": "your-domain-username",
          "WINDOWS_PASSWORD": "your-secure-password",
          "WINDOWS_DOMAIN": "YOUR-DOMAIN",
          "MSSQL_CONNECTION_STRING": "Data Source=main-server; Initial Catalog=MainDB; Integrated Security=SSPI; TrustServerCertificate=True;"
        }
      }
    }
  }
}