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. /docs/server/getting-started
  2. /docs/server/sql-reference
  3. /docs/server/getting-started/authentication
  4. /docs/server/configurations
  5. /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
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