ksqlDB for Confluent Platform
ksqlDB is Confluent’s streaming SQL database that developers use to build real-time, event-driven applications on Apache Kafka® using familiar SQL syntax. ksqlDB simplifies real-time data processing by letting you query, transform, and enrich streaming data with simple SQL statements, without writing custom code.
Whether you’re building real-time analytics, event-driven microservices, or continuous data transformations, ksqlDB provides a SQL-based approach to stream processing that scales from development to production.
Note
For new stream processing workloads, Confluent Platform for Apache Flink® is the recommended stream processing engine. ksqlDB remains fully supported for existing applications, and this documentation covers ksqlDB for Confluent Platform.
Why ksqlDB?
ksqlDB takes a SQL-based approach to stream processing on Kafka:
Familiar SQL syntax for stream processing, so you can query and transform streams without writing Java or Scala code
Fully integrated with Confluent Platform and Confluent Cloud—enterprise-grade security, monitoring, and management built-in
Production-ready with features like exactly-once processing, automatic scaling, and fault tolerance
Rich ecosystem support including Schema Registry integration, connectors, and Control Center management
ksqlDB lets developers and data engineers build streaming applications using only SQL, which can reduce time-to-value for SQL-centric, real-time data processing use cases.
ksqlDB quick start
Run ksqlDB locally with Confluent Platform in the ksqlDB Quick Start.
Get started with hosted ksqlDB in Confluent Cloud in the ksqlDB for Confluent Cloud Quick Start.
ksqlDB distributions
Confluent offers ksqlDB in flexible deployment options to meet your needs—from fully managed cloud service to self-hosted enterprise deployments:
- ksqlDB for Confluent Platform
ksqlDB for Confluent Platform is packaged as part of Confluent Platform. This is a commercial component of Confluent Platform. ksqlDB for Confluent Platform includes enterprise features, like role-based access control. You can install it by using the cp-ksqldb-server Docker images or by using TAR, ZIP, or Systemd deployments. For more information, see On-Premises Deployments.
Control Center is a graphical interface for Confluent Platform and provides the convenience of running streaming queries on one or more ksqlDB clusters. For more information, see Manage ksqlDB Using Control Center for Confluent Platform.
- ksqlDB for Confluent Cloud
ksqlDB is available as a hosted offering in Confluent Cloud. For more information, see ksqlDB for Confluent Cloud.
The following table summarizes the distributions.
Project Type |
Docker Images |
TAR, ZIP, Systemd deployment |
|
|---|---|---|---|
ksqlDB for Confluent Platform |
Packaged with Confluent Platform |
|
|
ksqlDB for Confluent Cloud |
Hosted |
|