v0.2.0

Install

Control plane

docker pull techsemics/remote-sql-agent:0.2.0
# or, from GitHub's registry
docker pull ghcr.io/semics-tech/remote-sql-agent/control-plane:0.2.0

Worker — pick one:

Route	Use when
rsagent-worker-linux-x64, -win-x64.exe, -darwin-arm64	Nothing is installed on the host. One file, no Node, no dependencies
npm install -g @remote-sql-agent/worker@0.2.0	The host already has Node 24
rsagent-worker-0.2.0-win-x64.zip	Windows, run as a service — install.ps1 from an elevated prompt
rsagent-worker-0.2.0-linux-x64.tar.gz	Linux, run as a systemd unit

Enrol with a token from the dashboard under Administration → Workers:

rsagent-worker-linux-x64 enrol --token rsen_... /etc/rsagent/worker.yaml

A new worker is readOnly until someone raises the ceiling on the
host itself. The control plane cannot raise it.

Verifying a download

sha256sum -c SHA256SUMS --ignore-missing
gh attestation verify rsagent-worker-linux-x64 --repo semics-tech/remote-sql-agent

See the quick start.

---

What's Changed

• fix(server): stop trusting a client-supplied X-Forwarded-For by @semics-tech in #52
• feat(deploy): add deployment routes and stop requiring a checkout to deploy by @semics-tech in #59
• docs: explain what Cloudflare can and cannot sit in front of by @semics-tech in #60
• docs: correct the msdb permissions the worker actually needs by @semics-tech in #61
• fix(dashboard): stop reporting a failed job save as success by @semics-tech in #62
• feat(deploy): add an optional signed wrapper for cross-owner job edits by @semics-tech in #63
• ci(deps): move the workflow actions to their current majors by @semics-tech in #64
• build(deps): take zod 4 across protocol, server and worker by @semics-tech in #65
• build(deps): move the dashboard from react-router-dom 6 to react-router 8 by @semics-tech in #66
• build(deps): take @fastify/rate-limit to 11 by @semics-tech in #68
• build(deps): take vitest 4 and @eslint/js 10, and pin @types/node to the runtime by @semics-tech in #67
• chore(release): cut 0.2.0 with the deployment routes and the write wrapper by @semics-tech in #74

Full Changelog: v0.1.1...v0.2.0