Dataherald vs Text2SQL.ai

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.

Text2SQL.ai converts natural-language requests into SQL and also provides query explanation, fixing, and optimization. Users can supply database tables, columns, and relationships as schema context so generated queries can reflect their database structure. Its Insights view combines a generated query with its results, a chart, and an explanation. Direct connections are supported for MySQL, PostgreSQL, and SQL Server; other databases can use extraction scripts or AI schema parsing. Safe Mode validates generated queries to help guard connected databases against accidental or malicious modifications. The cloud service is available on the web and through an API, with desktop apps for Windows, macOS, and Linux included in Pro subscriptions. The public API supports SQL generation for Pro and higher plans, and requests use plan credits. Pro includes 100 API requests per month, with additional requests listed at $0.05 each. Pricing starts at $29/user/mo, and a free trial is offered without a stated duration. The maker says it stores database schemas and SQL-related chat messages, but not actual database data. For the desktop app, it says credentials stay on the device and only schema names go to AI providers.