KalamDB Admin UI Guide

The Admin UI is served by the KalamDB server at /ui and is the fastest way to run SQL, inspect metadata, and monitor operations.

Access The UI

Open:

http://localhost:8080/ui/sql

If server setup is not complete, finish bootstrap first from Authentication & Bootstrap.

Sign In

Use a real DBA/system account you created during setup. There is no universal hardcoded production credential.

After login, the UI stores auth state using secure cookie/token flow from /v1/api/auth/* endpoints.

SQL Studio

SQL Studio is the primary workspace:

• namespace/table explorer
• multi-tab SQL editor
• results and execution details
• schema context and recent query history

Starter query:

SELECT * FROM system.namespaces LIMIT 100;

Main Navigation Areas

• Dashboard: health and high-level runtime indicators
• SQL Studio: query execution and schema exploration
• Streaming: topic monitoring and stream operations
• Users: user/role administration
• Jobs: background job tracking (flush/retention/cleanup)
• Live Queries: active subscription inspection
• Logging: server/job/audit log views
• Settings: runtime configuration values exposed by the backend

Practical Operator Workflow

1. Check node health and queue pressure in Dashboard.
2. Validate schema and data paths in SQL Studio.
3. Inspect Jobs for flush and maintenance behavior.
4. Review Live Queries and Streaming for realtime workload behavior.
5. Verify production guardrails in Settings before rollout.