ksqlDB

The ksqlDB entry appears in the sidebar when a ksqlDB server is configured (alginte.ksqldb.url — see Configuration); like every optional upstream, an absent menu entry just means it’s not configured. Three tabs:

Editor — a SQL editor with an execute button and a result panel. A mode switch distinguishes the two kinds of requests:
- Statement — DDL/DML: CREATE STREAM …, INSERT INTO …, SHOW STREAMS;
- Query — pull queries that return rows: SELECT … WHERE …;, with LIMIT for ranges.
Streams — the server’s streams (name, type, backing topic, key/value formats), refreshed automatically each time you return to the tab.
Tables — the same view for tables.

The ksqlDB Editor tab with the Query and Statement mode radio and the result panel — The ksqlDB editor: Query/Statement mode switch above the SQL editor, results below.

A minimal end-to-end session — create the riders topic first (Topics guide), then in Statement mode:

CREATE STREAM riders (
  riderId VARCHAR KEY,
  city VARCHAR,
  distanceKm DOUBLE
) WITH (
  KAFKA_TOPIC = 'riders',
  VALUE_FORMAT = 'JSON'
);

INSERT INTO riders (riderId, city, distanceKm) VALUES ('r1', 'Ljubljana', 12.5);

Then switch to Query mode for a point lookup:

SELECT * FROM riders WHERE riderId = 'r1';

The editor executes pull queries and statements. Continuous push queries (EMIT CHANGES) hold a connection open indefinitely and are rejected with a clear message — use a dedicated consumer (or the topic’s Live messages view) to follow a stream continuously.

Connect Configuration

Get Started

Installation

Streams builder

Guides

Operate

Editions