tinysqld

tinySQL DBMS daemon (tinysqld)

The enterprise DBMS entry point, separate from cmd/server so the older HTTP/gRPC API server stays compatible. It opens the OpenEnterprise product profile, requires durable storage, starts the job scheduler through that profile, exposes a minimal HTTP DBMS API for DB health, storage, scheduler, WAL and recovery state, and shuts down gracefully on a signal.

go build ./cmd/tinysqld

./tinysqld -data ./tinysqld-data -storage disk -tenant default -http 127.0.0.1:8088

Flags

HTTP API

Unauthenticated:

• GET /healthz — DB health snapshot; 503 if storage is closed or closing.
• GET /readyz — readiness plus health; 503 while not ready or unhealthy.

Authenticated when -auth is set, via Authorization: Bearer <token> or X-TinySQL-Auth: <token>:

• GET /api/status — runtime status, backend stats, DB health.
• GET /api/analytics/vector — vector-cache analytics (requires -analytics).
• POST /api/exec, POST /api/query
• GET /api/catalog/tables
• GET /api/catalog/columns (real table schemas from sys.columns)
• GET /api/jobs, GET /api/job-history
• POST /api/jobs/run

SQL request body; POST /api/jobs/run takes name instead of sql:

{
  "tenant": "default",
  "sql": "SELECT name FROM users",
  "timeout_ms": 5000
}

Status responses include a health object:

{
  "ok": true,
  "storage_mode": "disk",
  "scheduler_running": true,
  "wal_active": false,
  "advanced_wal_active": false,
  "recovery": {
    "mode": "memory",
    "recovered_transactions": 0,
    "recovered_operations": 0,
    "truncated": false
  }
}