Dataherald vs Insight O' Mate

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.

Insight O' Mate is a desktop tool that translates plain-English questions into database queries and runs them locally against databases and spreadsheets. It supports MongoDB, Firebase Firestore, Redis, Amazon DynamoDB, Excel, and CSV; the maker says Cassandra, Elasticsearch, Neo4j, and Couchbase are planned. For spreadsheets, it can filter, group, aggregate, and join data across sheets. It is designed for read operations and does not generate write, update, or delete operations, and it provides result visualizations. The hosted language engine receives prompts and collection or field names, while document values, spreadsheet rows, results, connection details, and credentials stay on the user's machine. The engine is described as stateless, does not store prompts, and does not train on user data. Connection strings are kept in the operating system keychain, with an encrypted-file fallback. The app is in public beta and runs on Linux, macOS, and Windows. Its Free plan allows 20 database analyses per day for one founder and one database. Pro costs $29 a month; Ultra costs $79 a month.