Lets assistants explore and query SQL Server databases with RAG support, on Windows and on macOS via Docker SQL Server.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add sql-server-tharanabope -- npx -y @tharanabopearachchi/sql-server-mcp~/.codex/config.toml
[mcp_servers.sql-server-tharanabope]
command = "npx"
args = ["-y", "@tharanabopearachchi/sql-server-mcp"]
# codex mcp add sql-server-tharanabope -- npx -y @tharanabopearachchi/sql-server-mcp~/.cursor/mcp.json
{
"mcpServers": {
"sql-server-tharanabope": {
"command": "npx",
"args": [
"-y",
"@tharanabopearachchi/sql-server-mcp"
]
}
}
}.vscode/mcp.json
{
"servers": {
"sql-server-tharanabope": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@tharanabopearachchi/sql-server-mcp"
]
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"sql-server-tharanabope": {
"command": "npx",
"args": [
"-y",
"@tharanabopearachchi/sql-server-mcp"
]
}
}
}claude_desktop_config.json
{
"mcpServers": {
"sql-server-tharanabope": {
"command": "npx",
"args": [
"-y",
"@tharanabopearachchi/sql-server-mcp"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"sql-server-tharanabope": {
"command": "npx",
"args": [
"-y",
"@tharanabopearachchi/sql-server-mcp"
]
}
}
}