harshad-webx/mssql-mcp-server

3.2

If you are the rightful owner of mssql-mcp-server 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.

The MSSQL MCP Server is a secure, read-only server that provides AI assistants with access to Microsoft SQL Server databases, enabling schema discovery, query execution, and business intelligence insights.

Tools

Functions exposed to the LLM to take actions

execute_query

Execute read-only SQL SELECT queries against your database.

get_table_schema

Get comprehensive schema information for a specific table.

search_tables

Search for tables and views by name pattern.

analyze_query

Analyze SQL query performance and get optimization recommendations.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

harshad-webx

Claim Ownership

Verify you have write access to the repository

Repository

https://github.com/harshad-webx/mssql-mcp-server

GitHub Stars

License

MIT License

Last publish date

2025-05-23

Last update date

2025-05-30

Server configs

in claude desktop

{
  "mcpServers": {
    "mssql": {
      "command": "mssql-mcp-server",
      "env": {
        "DB_SERVER": "your-server.com",
        "DB_DATABASE": "YourDatabase",
        "DB_USERNAME": "your_username",
        "DB_PASSWORD": "your_password",
        "DB_PORT": "1433",
        "DB_ENCRYPT": "true"
      }
    }
  }
}

via npx in claude desktop

{
  "mcpServers": {
    "mssql": {
      "command": "npx",
      "args": ["@harshad-webx/mssql-mcp-server"],
      "env": {
        "DB_SERVER": "your-server.com",
        "DB_DATABASE": "YourDatabase",
        "DB_USERNAME": "your_username",
        "DB_PASSWORD": "your_password",
        "DB_PORT": "1433",
        "DB_ENCRYPT": "true"
      }
    }
  }
}