SqlServerMcp
mcpotherio.github.Nithish1206/SqlServerMcp · v1.0.6
MCP server for SQL Server: schema inspection, safe read-only queries, query plan analysis
run it
on your own machines, one way per deploy methodgenerated from the record, not tested yet
#!/usr/bin/env bash # sqlservermcp (io.github.Nithish1206/SqlServerMcp), recipe baremetal (generated). # Generated by Hub for toolset "my-agent"; started by mcp-my-agent-sqlservermcp.service. set -euo pipefail export HOST=127.0.0.1 PORT=8101 exec uvx mcp-proxy --host 127.0.0.1 --port 8101 --pass-environment -- dnx [email protected] --yes [Unit] Description=MCP server sqlservermcp (toolset my-agent), generated by Hub After=network-online.target Wants=network-online.target [Service] Type=simple User=mcp Group=mcp EnvironmentFile=/etc/mcp/my-agent.env Environment=HOME=/var/lib/mcp/sqlservermcp WorkingDirectory=/var/lib/mcp/sqlservermcp ExecStart=/opt/mcp/my-agent/bin/sqlservermcp.sh Restart=on-failure RestartSec=5 NoNewPrivileges=true ProtectSystem=strict ProtectHome=true PrivateTmp=true ReadWritePaths=/var/lib/mcp/sqlservermcp [Install] WantedBy=multi-user.target
connect to it
copy what your client needsdnx [email protected] --yes # env: ConnectionStrings__MyDb, Query__DefaultTop, Query__MaxTop
{
"mcpServers": {
"sqlservermcp": {
"command": "dnx",
"args": [
"[email protected]",
"--yes"
],
"env": {
"ConnectionStrings__MyDb": "${ConnectionStrings__MyDb}",
"Query__DefaultTop": "${Query__DefaultTop}",
"Query__MaxTop": "${Query__MaxTop}"
}
}
}
}
#!/usr/bin/env bash
# Registers every server with Claude Code (run once; `claude mcp list` to check).
set -euo pipefail
set -a; [ -f .env ] && source .env; set +a
claude mcp add sqlservermcp -e "ConnectionStrings__MyDb=${ConnectionStrings__MyDb}" -e "Query__DefaultTop=${Query__DefaultTop}" -e "Query__MaxTop=${Query__MaxTop}" -- dnx [email protected] --yes
{
"mcpServers": {
"sqlservermcp": {
"command": "dnx",
"args": [
"[email protected]",
"--yes"
],
"env": {
"ConnectionStrings__MyDb": "${ConnectionStrings__MyDb}",
"Query__DefaultTop": "${Query__DefaultTop}",
"Query__MaxTop": "${Query__MaxTop}"
}
}
}
}
{
"servers": {
"sqlservermcp": {
"type": "stdio",
"command": "dnx",
"args": [
"[email protected]",
"--yes"
],
"env": {
"ConnectionStrings__MyDb": "${ConnectionStrings__MyDb}",
"Query__DefaultTop": "${Query__DefaultTop}",
"Query__MaxTop": "${Query__MaxTop}"
}
}
}
}
name: my-agent target: local servers: - hub: io.github.Nithish1206/SqlServerMcp
- not probed yet: tools unpinned, ingest lists them
tools
Not probed yetThe tools appear once the hub or its worker has listed this entry. Running it still works: your client lists them on first start.