Raw SQL MCP
mcpotherio.github.KifoPL/RawSqlMcp · v0.1.0
Execute raw SQL queries against SQL Server, SQLite, PostgreSQL, MySQL, and MariaDB.
run it
on your own machines, one way per deploy methodgenerated from the record, not tested yet
#!/usr/bin/env bash # rawsqlmcp (io.github.KifoPL/RawSqlMcp), recipe baremetal (generated). # Generated by Hub for toolset "my-agent"; started by mcp-my-agent-rawsqlmcp.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 rawsqlmcp (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/rawsqlmcp WorkingDirectory=/var/lib/mcp/rawsqlmcp ExecStart=/opt/mcp/my-agent/bin/rawsqlmcp.sh Restart=on-failure RestartSec=5 NoNewPrivileges=true ProtectSystem=strict ProtectHome=true PrivateTmp=true ReadWritePaths=/var/lib/mcp/rawsqlmcp [Install] WantedBy=multi-user.target
connect to it
copy what your client needsdnx [email protected] --yes # env: RawSqlMcp__Databases__Default__Provider, RawSqlMcp__Databases__Default__ConnectionString, RawSqlMcp__ConnectionStrings__Default
{
"mcpServers": {
"rawsqlmcp": {
"command": "dnx",
"args": [
"[email protected]",
"--yes"
],
"env": {
"RawSqlMcp__Databases__Default__Provider": "${RawSqlMcp__Databases__Default__Provider}",
"RawSqlMcp__Databases__Default__ConnectionString": "${RawSqlMcp__Databases__Default__ConnectionString}",
"RawSqlMcp__ConnectionStrings__Default": "${RawSqlMcp__ConnectionStrings__Default}"
}
}
}
}
#!/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 rawsqlmcp -e "RawSqlMcp__Databases__Default__Provider=${RawSqlMcp__Databases__Default__Provider}" -e "RawSqlMcp__Databases__Default__ConnectionString=${RawSqlMcp__Databases__Default__ConnectionString}" -e "RawSqlMcp__ConnectionStrings__Default=${RawSqlMcp__ConnectionStrings__Default}" -- dnx [email protected] --yes
{
"mcpServers": {
"rawsqlmcp": {
"command": "dnx",
"args": [
"[email protected]",
"--yes"
],
"env": {
"RawSqlMcp__Databases__Default__Provider": "${RawSqlMcp__Databases__Default__Provider}",
"RawSqlMcp__Databases__Default__ConnectionString": "${RawSqlMcp__Databases__Default__ConnectionString}",
"RawSqlMcp__ConnectionStrings__Default": "${RawSqlMcp__ConnectionStrings__Default}"
}
}
}
}
{
"servers": {
"rawsqlmcp": {
"type": "stdio",
"command": "dnx",
"args": [
"[email protected]",
"--yes"
],
"env": {
"RawSqlMcp__Databases__Default__Provider": "${RawSqlMcp__Databases__Default__Provider}",
"RawSqlMcp__Databases__Default__ConnectionString": "${RawSqlMcp__Databases__Default__ConnectionString}",
"RawSqlMcp__ConnectionStrings__Default": "${RawSqlMcp__ConnectionStrings__Default}"
}
}
}
}
name: my-agent target: local servers: - hub: io.github.KifoPL/RawSqlMcp
- 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.