Dataherald vs NatureQuery

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.

NatureQuery turns natural-language questions into SQL, runs them against a connected database, and exports results as Excel spreadsheets or CSV files. Its AI is described as understanding database schemas, and the product can create bar, line, and pie charts from results. Listed database support includes PostgreSQL, MySQL, SQLite, SQL Server, MariaDB, and Amazon Redshift. Teams can invite members and share connections and saved queries using role-based access. The cloud service is available through the web and API. Its free plan costs nothing and includes 50 queries per month, one database connection, and 30 days of query history. Pro costs $20 a month and includes unlimited queries, 10 connections, collaboration for five members, API access, and priority support. Enterprise costs $79 a month and lists unlimited queries, connections, and members, plus SSO / SAML, audit logs and compliance, and dedicated support with an SLA. NatureQuery says credentials and connections are encrypted and query results are not stored.