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
- Run KalamDB locally in minutes
- Learn the SQL surface for tables, queries, subscriptions, and storage
- Review authentication and bootstrap flows
- Configure storage, OIDC, and observability
- Review security and production settings before deployment
Choose Your Path
I am building AI agents or a chat application
Start with Getting Started, then continue to TypeScript Setup, Realtime Subscriptions, and Topic Consumers & ACK.
I want a backend-as-a-service alternative I can control
Start with Getting Started, then read Authentication & Bootstrap, SQL Reference, Security, and OIDC & Issuer Trust.
I need PostgreSQL compatibility
Start with PostgreSQL Extension Getting Started, then read PostgreSQL Extension Architecture, SQL Syntax, and Data Type Conversions.
I need advanced data and operations guidance
Start with Vector Search, Topic Pub-Sub, Storage Tiers, Clustering, and OpenTelemetry (OTEL).
Questions New Users Ask
What should I read first?
If you are new, start at 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 the TypeScript 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 TypeScript Setup to Topic Consumers & ACK, Agent Runtime, and AI Agent Coding Guidelines.
Where do I learn production deployment and observability?
Read Security, Advanced Configuration, OIDC & Issuer Trust, Jaeger, and OpenTelemetry (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: