Wes Caldwell

Work / Developer tool ยท VS Code extension

Fleet DB Client

Every server and database in the fleet, one click away in VS Code. Production hosts physically can't be opened read-write by accident.

Role
Author
Status
v0.1.0 packaged
Year
2026
Link
Private
๐Ÿ”’ sentinel ยท orders_dbfleet-db โ€บ sentinel โ€บ mysqlโ–ˆโ–ˆโ–ˆโ–ˆ PRODUCTION โ€” READ-ONLY SESSION โ–ˆโ–ˆโ–ˆโ–ˆSET SESSION TRANSACTION READ ONLY; --safe-updatesRO> SELECT COUNT(*) FROM orders;+----------+ | 1,284 | +----------+RO> UPDATE orders SET status='x';ERROR 1792: Cannot execute statement in a READ ONLY transaction.โœ“ nothing changed. ssh-only ยท tailnet ยท 0 ports exposedIllustration
1 clickserver โ†’ SSH, database โ†’ SQL
0database ports exposed
RO>enforced on production

The problem

Generic database clients don't know which host is production. One wrong tab and a hosting server with a dozen client databases is exposed to a stray UPDATE.

What I built

  • A sidebar tree generated from the SSH config: click a server for a terminal, click a database for a SQL console, and the same inventory works from the command line.
  • Hosts flagged read-only get SET SESSION TRANSACTION READ ONLY and --safe-updates, an RO> prompt, a red banner before the shell opens, and a lock on the tab.
  • SSH-only access over Tailscale. No database port is ever opened or tunnelled across the public internet.

Stack

TypeScriptVS Code Extension APISSHMariaDB / MySQLTailscale

Integrated Autonomy

Your AI department.

I learn how your business actually runs, find the bottlenecks and build the AI systems that remove them: agents, automations, sites and the infrastructure under them. No packages or templates, and it runs on hardware you own wherever that makes sense.