sp00ky

The Reactive, Local-First Framework for SurrealDB

⚠️ Under active development — not production-ready. APIs may change without notice.

Documentation · Example App · CLI · Contributing

Features

• Live Queries — Your UI updates instantly when data changes
• Local-First — Works offline using IndexedDB, syncs when back online
• End-to-End Type Safety — Generated TypeScript definitions from your SQL schema
• Optimistic UI — Immediate feedback for user actions while syncing in the background

Quick Start

Install

pnpm add @spooky-sync/client-solid

Generate Types with CLI

npx @spooky-sync/cli generate

Usage (SolidJS)

import { useQuery } from '@spooky-sync/client-solid';
import { db } from './db';

const ThreadList = () => {
  const threads = useQuery(() => db.query('thread').select('*').all());

  return (
    <ul>
      <For each={threads.data}>{(thread) => <li>{thread.title}</li>}</For>
    </ul>
  );
};

Packages

Package	Description
@spooky-sync/core	Core client SDK — sync engine, caching, reactivity
@spooky-sync/client-solid	SolidJS bindings (useQuery, etc.)
@spooky-sync/query-builder	Type-safe query builder
@spooky-sync/backend	Backend SDK: durable workflows (step.do) on sp00ky's job engine
@spooky-sync/cli	CLI for schema generation
@spooky-sync/query-allowlist	Records the query allowlist from an app's q* module (spky generate)
mono424/spooky-ssp	SSP sidecar (Docker)
mono424/spooky-scheduler	Scheduler service, and the operator dashboard and MCP server it serves on port 9668 (Docker)

Example App

Check out the full-featured reference app built with SolidJS:

cd example/app-solid && pnpm install && pnpm dev

Documentation

• Grok Bot template recipe — source material for a public Bot template under apps/grok-bot

Full documentation is available at mono424.github.io/sp00ky.

• Secrets in migrations — inject vault secrets into schema via {{KEY}} placeholders, and spky env set --file.

Contributing

Contributions are welcome! This is a monorepo — see the individual package directories under packages/ for details.

License

MIT

---

Star History

---