kalamdb

name	kalamdb
description	KalamDB router skill — open ONE targeted reference after routing. Covers CLI (kalam init/dev), Rust/Dart/TypeScript SDKs, SQL, auth, ops, PG extension. Use for KalamDB contributor or app integration work.
license	Apache-2.0
compatibility	codex, claude-code, opencode, agent-skills
metadata	{"repo":"KalamDB","audience":"contributors","scope":"router"}

KalamDB

Router only. Do not preload all references.

Token Discipline

1. Read this file first.
2. Open one reference from the task table.
3. Open a second file only when the task clearly spans areas (e.g. init + Dart SDK).
4. For method signatures and flags, open the listed *-api.md file — not the whole SDK tree.
5. Open one example file when you need copy-paste patterns.
6. Full file list: references/INDEX.md (use only when unsure).

Working Rules

• Prefer owning crate/abstraction; follow storage boundaries and TableId conventions.
• No SQL rewrite passes in hot paths.
• Update this skill when user-facing CLI, SQL, SDK, or runbook behavior changes.
• Template-first: for new apps, pick the closest kalam init --template scaffold and extend it — do not build equivalent boilerplate from scratch when a template exists. Catalog: cli-templates.md.
• Schema-first: for app work, edit schema.sql before writing app/domain code, run generation, and treat generated SDK/ORM types as source of truth. Do not hand-write duplicate row models first.
• AI assistant chat: always include visible thinking/typing and frontend token streaming. Use direct CREATE USER TABLE for conversation/message rows, direct CREATE STREAM TABLE for token rows, and a topic/source from user message inserts for the agent. Do not add an app users table or fake user_id tenancy columns for authenticated USER-table data; KalamDB auth already supplies the user identity.

Task Router

Task	Reference	API detail	Example
New project / kalam init	cli-init.md + cli-templates.md	—	cli-templates.md
Local dev / kalam dev	cli-dev.md	—	cli-workflows.md
Full-stack React + agent	cli-templates.md + cli-dev.md	—	full-stack-react-agent.md
Migrations, link, status	cli-lifecycle.md	—	cli-workflows.md
kalam.toml config	kalam-toml.md	—	kalam.toml
SQL shell, kalam login, flags	cli.md	—	cli-workflows.md
Rust app / kalam-client	rust-sdk.md	rust-sdk-api.md	rust-sdk.md
Flutter / Dart / kalam_link	dart-sdk.md	dart-sdk-api.md	dart-sdk.md
TypeScript client	typescript-client-sdk.md	typescript-client-api.md	typescript-client.md
TypeScript FILE columns	typescript-files.md	—	typescript-files.md
TypeScript ORM / schema gen	typescript-orm.md	—	typescript-orm.md
TypeScript React live UI	typescript-react.md	—	typescript-react.md
Topic workers (TS)	typescript-consumer.md	—	typescript-consumer.md
SQL syntax / DDL	sql-syntax.md	—	sql-patterns.md
Auth / RBAC / JWT	auth.md	—	—
Server server.toml	server-configuration.md	—	server-configuration.toml
REST / WebSocket protocol	api-websocket.md	—	—
Architecture / crate map	architecture.md	—	—
Ops / cluster	operations.md	—	—
PostgreSQL extension	pg-extension.md	—	pg-extension.md
Tests / benchmarks	testing.md	—	—
Debugging	troubleshooting.md	—	—
Choosing integration surface	integrations.md	—	—
Repo change checklist	—	—	agent-change-checklist.md

Quick Commands

cd backend && cargo run --bin kalamdb-server
cd cli && cargo build --release && cargo test --test smoke
cargo nextest run

New app: pick a template → kalam init --template <id> → kalam dev. Extend the scaffold; avoid rebuilding from scratch.

Repo-Local Deep Skills

For internals after routing: mvcc, raft, datafusion, rust-skills in the main KalamDB repo.