Course: ksqlDB 101

Interacting with ksqlDB

2 min
Allison WaltherIntegration Architect (Course Presenter)
Robin MoffattStaff Developer Advocate (Course Author)

Interacting with ksqlDB

There are several ways to interact with ksqlDB, including a command line interface, a web UI, a REST API, and client libraries for Java and other languages.

Command Line Interface (CLI)

The ksqlDB CLI is very similar in look and feel to command line tools for relational databases that you may be familiar with, such as Postgres’s psql or Oracle’s SQL*Plus:

database-purpose

Web UI

One of the simplest ways to interact with ksqlDB is via the web UI in Confluent Cloud. You can develop queries in an interactive editor, view flow diagrams of streams and tables, and manage persistent queries.

diagrams-of-streams

diagrams-of-streams-and-tables

You can also monitor ksqlDB and its processing in the web UI:

web-ui-three

REST API

The ksqlDB REST API provides programmatic access to ksqlDB for managing objects and querying them:

web-ui-four

Client Libraries

ksqlDB’s client libraries wrap the REST API. An official Java client is provided, and there are community projects that provide similar functionality in other languages, including Python and Go.

client-libraries

Use the promo code KSQLDB101 to get $101 of free Confluent Cloud usage

Be the first to get updates and new content

We will only share developer content and updates, including notifications when new content is added. We will never send you sales emails. 🙂 By subscribing, you understand we will process your personal information in accordance with our Privacy Statement.