Introduction
Cogworks turns a SQLite database into a full REST + realtime backend — collections, auth, file storage, rules, hooks, and an admin UI — compiled to one executable with no external services to run.
Cogworks is a fork of vaultbase-sh/vaultbase by Khalid M. Sheet. Its main divergence is a server rewrite from Elysia to Hono, plus the feature set documented here.
Real SQL tables
Section titled “Real SQL tables”Every collection is a native SQLite table — fast queries, real indexes, no JSON-blob soup.
Batteries-included auth
Section titled “Batteries-included auth”Password, TOTP, passkeys, OAuth2, email OTP, anonymous, API tokens — all built in.
Realtime
Section titled “Realtime”WebSocket + SSE with per-record rule filtering and reconnect resume.
Extensible
Section titled “Extensible”Hooks, custom routes, cron, and queue workers in sandboxed-ish JS with a rich helper API.