Skip to Content
Overview

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

  1. Run KalamDB locally in minutes
  2. Learn the SQL surface for tables, queries, subscriptions, and storage
  3. Review authentication and bootstrap flows
  4. Configure storage, OIDC, and observability
  5. 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
CapabilityWhat it gives you
USER tablesper-user/tenant isolation
SHARED tablesglobal app data scope
STREAM tablesephemeral realtime state with TTL
live subscriptionspush-based UI/state updates
topics + consumersqueue-like worker processing
vector searchsemantic retrieval with cosine distance
storage commandsexplicit flush/compact/manifest tooling

Release Information

For the latest published versions and artifacts, use:

Last updated on