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

v0.1.1

Install

Control plane

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

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.1.1	The host already has Node 24
rsagent-worker-0.1.1-win-x64.zip	Windows, run as a service — install.ps1 from an elevated prompt
rsagent-worker-0.1.1-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

• refactor(protocol): stop publishing the protocol package to npm by @semics-tech in #50
• fix(server): ship tsx in the image instead of fetching it at boot by @semics-tech in #51

Full Changelog: v0.1.0...v0.1.1

v0.1.0

Install

Control plane

docker pull techsemics/remote-sql-agent:0.1.0
# or, from GitHub's registry
docker pull ghcr.io/semics-tech/remote-sql-agent/control-plane:0.1.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.1.0	The host already has Node 24
rsagent-worker-0.1.0-win-x64.zip	Windows, run as a service — install.ps1 from an elevated prompt
rsagent-worker-0.1.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

• Add Claude Code GitHub Workflow by @semics-tech in #24
• fix(ci): green the pipeline and enforce conventional pull request titles by @semics-tech in #25
• ci(deps): bump actions/checkout from 4 to 7 by @dependabot[bot] in #5
• ci: make dependabot pull requests able to pass their own checks by @semics-tech in #27
• docs: correct the GitHub repository name throughout by @semics-tech in #22
• fix(server): stop reporting a re-key on a worker's first connection by @semics-tech in #17
• fix(dashboard): clear the optimistic Starting state when a job finishes between polls by @semics-tech in #18
• fix(server): let the shortest throttle window win when notification rules disagree by @semics-tech in #20
• ci(deps): bump pnpm/action-setup from 4 to 6 by @dependabot[bot] in #1
• ci(deps): bump softprops/action-gh-release from 2 to 3 by @dependabot[bot] in #3
• ci(deps): bump docker/login-action from 3 to 4 by @dependabot[bot] in #6
• build(deps): bump @fastify/cors from 10.1.0 to 11.3.0 by @dependabot[bot] in #13
• feat(dashboard): make a running job observable while it runs by @semics-tech in #23
• perf(server): stop loading every job definition to describe schedules by @semics-tech in #19
• fix(server): detach an instance when its configuration is removed by @semics-tech in #21
• ci(deps): bump actions/setup-node from 4 to 7 by @dependabot[bot] in #2
• build(deps): bump mssql and @types/mssql by @dependabot[bot] in #9
• build(deps-dev): bump typescript from 5.9.3 to 6.0.3 by @dependabot[bot] in #10
• ci(deps): bump actions/attest-build-provenance from 2 to 4 by @dependabot[bot] in #28
• build(deps): bump pino from 9.14.0 to 10.3.1 by @dependabot[bot] in #14
• build(deps-dev): bump @types/node from 22.20.1 to 26.1.2 by @dependabot[bot] in #15
• build(deps-dev): bump eslint from 9.39.5 to 10.8.0 by @dependabot[bot] in #16
• test(dashboard): cover the front end in a real browser with Playwright by @semics-tech in #29
• build(deps): take React 19, Vite 8, plugin-react 6 and Monaco 0.56 by @semics-tech in #30
• build: move the whole toolchain to Node 24 LTS by @semics-tech in #31
• build(deps): bump the minor-and-patch group across 1 directory with 4 updates by @dependabot[bot] in #32
• feat(deploy): publish to npm, Docker Hub and GitHub releases from one tag by @semics-tech in #33
• fix(worker): spawn pnpm through a shell on Windows for the SEA build by @semics-tech in #45
• fix(worker): name the Windows executable win-x64, not win32-x64 by @semics-tech in #46
• chore(release): 0.1.0-rc.1 by @semics-tech in #47
• fix(deploy): download release artifacts one at a time, by name by @semics-tech in #48
• chore(release): cut 0.1.0, the first published release by @semics-tech in #49

New Contributors

• @semics-tech made their first contribution in #24
• @dependabot[bot] made their first contribution in #5

Full Changelog: https://github.com/semics-tech/remote-sql-agent/commits/v0.1.0