OpenMLDB
openmldb.ai
What it is
OpenMLDB is a free, open-source machine learning database and feature platform for keeping features consistent between training and inference. It uses SQL to create feature-engineering scripts, deploy them online, and configure online data sources. Its architecture combines a real-time SQL engine, a batch SQL engine based on a tailored Spark distribution, and a unified execution-plan generator. Documentation says the real-time engine can produce features in a few milliseconds. SQL extensions include LAST JOIN and WINDOW UNION. OpenMLDB has a cluster version for large-scale production applications and a lightweight standalone version for evaluation and demonstration. Listed production capabilities include distributed storage and computing, fault recovery, high availability, scale-out, upgrades, monitoring, and heterogeneous memory support. Integrations include importing Apache Pulsar streams and adding feature-engineering tasks to DolphinScheduler workflows. Kubernetes deployment is described for both offline and online engines, but the documented cluster setup lacks a TaskManager, so LOAD DATA, SELECT INTO, and offline-related functions are unsupported there. The Spark distribution provides Scala, Java, Python, and R interfaces; its precompiled AllinOne version supports Linux and macOS.
Spec sheet
- What it does
- OpenMLDB is an open-source machine learning database and feature platform for consistent features in training and inference.Read 3 Oct 2026 · openmldb.ai
- Batch and real-time engines
- Its architecture includes a real-time SQL engine, a batch SQL engine based on a tailored Spark distribution, and a unified execution plan generator.Read 3 Oct 2026 · openmldb.ai
- Community support
- The project directs users to GitHub Issues for bug reports and feature requests, GitHub Discussions, Slack, and a developer mailing list.Read 3 Oct 2026 · openmldb.ai
- Deployment options
- OpenMLDB has a cluster version for large-scale production applications and a lightweight single-node standalone version for evaluation and demonstration.Read 3 Oct 2026 · openmldb.ai
- DolphinScheduler integration
- OpenMLDB provides a DolphinScheduler task for integrating feature engineering into workflows, including offline import, feature extraction, SQL deployment, and online import.Read 3 Oct 2026 · openmldb.ai
- Kubernetes deployment
- The deployment guide describes Kubernetes deployment for both OpenMLDB's offline and online engines.Read 3 Oct 2026 · openmldb.ai
- Kubernetes limitation
- The documented Kubernetes cluster deployment does not include a TaskManager, so LOAD DATA, SELECT INTO, and offline-related functions are unsupported in that deployment.Read 3 Oct 2026 · openmldb.ai
- Kubernetes requirements
- The Kubernetes deployment tool is tested with Kubernetes 1.19 or later and Helm 3.2.0 or later.Read 3 Oct 2026 · openmldb.ai
- Production capabilities
- The documentation lists distributed storage and computing, fault recovery, high availability, scale-out, upgrades, monitoring, and heterogeneous memory support.Read 3 Oct 2026 · openmldb.ai
- Pulsar integration
- The OpenMLDB Pulsar Connector is described as a way to import real-time data streams from Apache Pulsar into OpenMLDB.Read 3 Oct 2026 · openmldb.ai
- Real-time features
- The documentation says its real-time SQL engine can produce features in a few milliseconds.Read 3 Oct 2026 · openmldb.ai
- Spark distribution
- The OpenMLDB Spark distribution provides Scala, Java, Python, and R interfaces, and its precompiled AllinOne version supports Linux and macOS.Read 3 Oct 2026 · openmldb.ai
- SQL extensions
- OpenMLDB extends SQL for feature engineering with syntax including LAST JOIN and WINDOW UNION.Read 3 Oct 2026 · openmldb.ai
- SQL workflow
- OpenMLDB uses SQL to develop feature engineering scripts, deploy them online, and configure online data sources.Read 3 Oct 2026 · openmldb.ai
Plans and prices
Strong points and limits
Strong points
- Open-source and free
- Combines real-time and batch SQL engines
- Supports standalone and cluster deployments
- Spark distribution provides Scala, Java, Python, and R interfaces
- Lists production capabilities including fault recovery and monitoring
Limits
- Documented Kubernetes cluster setup lacks a TaskManager
- Several offline-related functions are unsupported in that deployment
Who it suits
It suits teams building machine-learning feature workflows with SQL who need online and batch processing or a self-hosted deployment. The lightweight standalone version is intended for evaluation and demonstration, while the cluster version targets large-scale production applications.
Verdict
OpenMLDB offers SQL-based feature engineering across real-time and batch workflows, with standalone and cluster deployment options. Check the documented Kubernetes limitation if those deployments need LOAD DATA, SELECT INTO, or offline-related functions.
Where Specifiction places it
- Feature Store Software#7 of 207.5