Dataherald vs YourQL
Dataherald
github.comYourQL
yourquerylanguage.comSide by side
| Figure | Dataherald | YourQL |
|---|---|---|
| Price from | — | Free |
| Free plan | — | Yes |
| Free trial | — | — |
| Open source | — | — |
| Web | Yes | — |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| API | Yes | — |
| Self-hosted | Yes | — |
| Plans published | 0 | 1 |
| Spec score · AI Database Assistants | 7.7 (#11) | 7.3 (#16) |
| Credentials | The quick start requires an OpenAI API key, an organization ID, and an encryption key before starting the engine. | Provider API keys and database credentials are stored in the local database and are sent only to the configured LLM provider or connected database as applicable. |
| Product | Dataherald is a natural language-to-SQL engine that exposes an API for asking questions about relational data in plain English. | YourQL is a desktop application for asking questions about databases in plain English and getting queries, interactive tables, charts, and summaries. |
Plans
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.
YourQL
YourQL is a free desktop app for asking database questions in plain English and receiving SQL, interactive tables, charts, and summaries. It runs on Linux, macOS, and Windows and supports databases and sources including MySQL, MariaDB, PostgreSQL, SQLite, SQL Server, Snowflake, BigQuery, Redshift, CSV, Excel, and Google Sheets. Users can configure OpenAI, Anthropic Claude, Ollama, or a custom OpenAI-compatible HTTP endpoint. YourQL reads a database schema, sends a prompt to the configured model, runs the resulting SQL, and can return errors for a correction and retry. Exploration queries offer configurable strict, moderate, or relaxed safety modes; the maker says source queries are limited to SELECT statements and writes are forbidden. Conversations, settings, and connection details are stored locally. Data is sent to a cloud only when a cloud model provider is configured. The maker says the app has no telemetry or analytics. Users can add database-specific prompts and descriptions, activate reusable Markdown skills, and export discussions as PDF, HTML, or Markdown. The official site describes YourQL as work in progress.