OwnPG
mcpotherio.github.devops-infinity/ownpg · v0.1.2
PostgreSQL DBA tools over MCP, scoped to one database and one schema.
run it
on your own machines, one way per deploy methodgenerated from the record, not tested yet
# once, as root: cargo install --locked ownpg --version 0.1.2 --root /usr/local #!/usr/bin/env bash # ownpg (io.github.devops-infinity/ownpg), recipe baremetal (generated). # Generated by Hub for toolset "my-agent"; started by mcp-my-agent-ownpg.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 -- ownpg [Unit] Description=MCP server ownpg (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/ownpg WorkingDirectory=/var/lib/mcp/ownpg ExecStart=/opt/mcp/my-agent/bin/ownpg.sh Restart=on-failure RestartSec=5 NoNewPrivileges=true ProtectSystem=strict ProtectHome=true PrivateTmp=true ReadWritePaths=/var/lib/mcp/ownpg [Install] WantedBy=multi-user.target
connect to it
copy what your client needsownpg # env: OWNPG_HOST, OWNPG_PORT, OWNPG_USER, OWNPG_PASSWORD
{
"mcpServers": {
"ownpg": {
"command": "ownpg",
"args": [],
"env": {
"OWNPG_HOST": "${OWNPG_HOST}",
"OWNPG_PORT": "${OWNPG_PORT}",
"OWNPG_USER": "${OWNPG_USER}",
"OWNPG_PASSWORD": "${OWNPG_PASSWORD}"
}
}
}
}
#!/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 ownpg -e "OWNPG_HOST=${OWNPG_HOST}" -e "OWNPG_PORT=${OWNPG_PORT}" -e "OWNPG_USER=${OWNPG_USER}" -e "OWNPG_PASSWORD=${OWNPG_PASSWORD}" -- ownpg
{
"mcpServers": {
"ownpg": {
"command": "ownpg",
"args": [],
"env": {
"OWNPG_HOST": "${OWNPG_HOST}",
"OWNPG_PORT": "${OWNPG_PORT}",
"OWNPG_USER": "${OWNPG_USER}",
"OWNPG_PASSWORD": "${OWNPG_PASSWORD}"
}
}
}
}
{
"servers": {
"ownpg": {
"type": "stdio",
"command": "ownpg",
"args": [],
"env": {
"OWNPG_HOST": "${OWNPG_HOST}",
"OWNPG_PORT": "${OWNPG_PORT}",
"OWNPG_USER": "${OWNPG_USER}",
"OWNPG_PASSWORD": "${OWNPG_PASSWORD}"
}
}
}
}
name: my-agent target: local servers: - hub: io.github.devops-infinity/ownpg
- 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.