KalamDB Server Docs
Use these server docs to run KalamDB, build a SQL-first backend for AI agents and realtime apps, configure authentication, operate storage, and deploy production services.
If you are comparing backend-as-a-service options, KalamDB gives you a self-hosted realtime data layer with SQL, authentication, tenant isolation, live subscriptions, topics, and vector search in one runtime.
Start Here
- /docs/server/getting-started
- /docs/server/sql-reference
- /docs/server/getting-started/authentication
- /docs/server/configurations
- /docs/server/security
Choose Your Path
I am building AI agents or a chat application
Start with /docs/server/getting-started, then continue to /docs/ts-sdk/setup, /docs/ts-sdk/subscriptions, and /docs/ts-sdk/consumers.
I want a backend-as-a-service alternative I can control
Start with /docs/server/getting-started, then read /docs/server/getting-started/authentication, /docs/server/sql-reference, /docs/server/security, and /docs/server/configurations/oidc.
I need PostgreSQL compatibility
Start with /docs/pg-kalam/getting-started, then read /docs/pg-kalam/architecture, /docs/pg-kalam/sql-syntax, and /docs/pg-kalam/type-conversions.
I need advanced data and operations guidance
Start with /docs/server/architecture/table-types, /docs/server/architecture/vector-search, /docs/server/topic-pubsub, /docs/server/architecture/storage-tiers, /docs/server/architecture/clustering, and /docs/server/configurations/otel.
Questions New Users Ask
What should I read first?
If you are new, start at /docs/server/getting-started. It takes you from running KalamDB locally to creating your first table and sending your first SQL query.
Can frontend clients execute SQL directly against KalamDB?
Yes. Use /docs/ts-sdk for browser and app-facing clients. USER tables keep the same SQL scoped to the signed-in user, and live subscriptions push updates over WebSockets.
Where do I start for workers, automation, and advanced agent flows?
Go from /docs/ts-sdk/setup to /docs/ts-sdk/consumers, /docs/ts-sdk/agents, and /docs/server/getting-started/ai-agent-guidelines.
Where do I learn production deployment and observability?
Read /docs/server/security, /docs/server/configurations/logging, /docs/server/configurations/advanced, /docs/server/configurations/oidc, /docs/server/integrations/dex, /docs/server/integrations/jaeger, and /docs/server/configurations/otel.
Core Capabilities
KalamDB combines:
- SQL query and DDL workflows
- user-isolated and shared table models
- live query subscriptions over WebSocket
- topic consume/ack worker patterns
- vector search with
EMBEDDING(n)columns and cosine ranking - hot + cold storage lifecycle in one runtime
| Capability | What it gives you |
|---|---|
USER tables | per-user/tenant isolation |
SHARED tables | global app data scope |
STREAM tables | ephemeral realtime state with TTL |
| live subscriptions | push-based UI/state updates |
| topics + consumers | queue-like worker processing |
| vector search | semantic retrieval with cosine distance |
| storage commands | explicit flush/compact/manifest tooling |
Release Information
For the latest published versions and artifacts, use: