Dataherald vs Kyligence
Dataherald
github.comKyligence
kyligence.ioSide by side
| Figure | Dataherald | Kyligence |
|---|---|---|
| Price from | — | — |
| Free plan | — | — |
| Free trial | — | Yes |
| Open source | — | — |
| Web | Yes | Yes |
| Linux | — | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 0 | 0 |
| Spec score · AI Database Assistants | 7.7 (#11) | 7.9 (#9) |
| Deployment | The quick start describes self-hosting the engine with Docker, with Mongo running in a separate container for application data. | Kyligence Cloud can be deployed through its portal, cloud templates, or the Azure and AWS Marketplaces. |
| Intended users | The documentation is intended for developers building natural-language interfaces from structured data in their own projects and contributors to the engine. | Kyligence describes its platform as serving organizations across financial services, manufacturing, and retail. |
| Security | The quick start says database connection data is encrypted before storage in MongoDB using an ENCRYPT_KEY and recommends changing the default MongoDB username and password. | The security page describes end-to-end encryption, row- and column-level permissions, and data backup and recovery. |
| What it does | Dataherald is a natural language-to-SQL engine that lets users ask questions in plain English about structured or relational data through an API. | Kyligence Zen is a metrics platform for defining, managing, and analyzing business metrics across an organization. |
In their own words
Dataherald
Dataherald is an open-source natural language-to-SQL engine that exposes an API for asking questions about relational data in plain English. Its stated uses include helping business users query warehouses, embedding data Q&A in SaaS products, and creating ChatGPT plug-ins for proprietary data. The project targets developers building natural-language interfaces or contributing to the engine. Self-hosting uses Docker, with MongoDB in a separate container for application data. Listed warehouse connections are PostgreSQL, BigQuery, Databricks, and Snowflake. Included SQL-generation approaches are LangChain SQL Agent, LangChain SQL Chain, LlamaIndex SQL Generator, and Dataherald SQL Agent. A context store can include business and database details, validated question-and-SQL examples, and table information; active learning from usage is also described. An evaluator assigns confidence scores to generated SQL. The modular architecture allows implementations to be changed through .env configuration. Startup requires an OpenAI API key, organization ID, and encryption key. Connection data is encrypted before Mongo storage. The repository uses Apache-2.0 licensing.
Kyligence
Kyligence helps organizations define, govern, and analyze business metrics through a shared catalog and semantic layer. Kyligence Zen provides a place to manage metrics for use in downstream BI tools and applications, while Kyligence Copilot lets users ask questions about metrics in natural language, analyze them, and receive recommendations. For multidimensional analysis, Kyligence Enterprise returns standard SQL query responses on petabyte-scale data lakes. The platform also lists SQL, MDX, and REST API interfaces, and connects with tools such as Excel, Power BI, Tableau, MicroStrategy, and Cognos. Supported data connectors include Impala, Oracle, Greenplum, GBase, MySQL, Snowflake, and Azure Synapse. Deployment options include cloud and on-premises, described as a hybrid model; listed cloud platforms include AWS, Microsoft Azure, Huawei Cloud, and Google Cloud. Security measures include end-to-end encryption, row- and column-level controls, backups, and recovery mechanisms. Kyligence lists SOC 2 Type 1, ISO 27001, and ISO 9001 certifications. Pricing is on request, and a free trial is offered; trial terms may limit use to internal evaluation in a non-production environment for up to 30 days unless otherwise specified in writing.