Natural Language SQL vs SQLer

Natural Language SQL turns plain-English questions about databases into SQL, validates and runs the query, then streams back results. It connects to PostgreSQL and MySQL, including multiple databases of the same type in parallel. Hybrid retrieval combines BM25 and sentence-transformer vectors to select schema context for a question. Users can review and edit generated SQL before execution, while the interface shows progress through query stages. Results can be sorted, paginated at 50 rows per page, downloaded as CSV or JSON, or copied as tab-separated text. SELECT queries receive a default limit, explicit result counts are capped at 1,000 rows, and execution times out after 30 seconds by default. INSERT, UPDATE and DELETE are allowed by default, with warning banners; the project recommends a read-only database user to block writes. Ollama runs locally by default, keeping questions, schema and generated SQL on the user’s machine. OpenAI, Gemini and Groq are optional cloud providers and receive the question, relevant schema portion and SQL context. The project is free under GPL-3.0. Its recommended Docker setup needs Docker 20.10 or later with Compose v2 and about 10 GB of free disk space.

SQLer turns natural-language questions into SQL for relational databases, giving developers a way to add question-to-query generation to an application. It lists MS SQL, MySQL, PostgreSQL and SQLite. Developers can supply company vocabulary, business rules, schema descriptions and question-to-SQL examples to shape generation. Schema information can be set up through direct connection, GATHERer or manual upload of SQL DDL files, and refreshed as schemas and metadata change. GATHERer runs as a Kubernetes container in the customer's application environment and transfers gathered setup information to SQLer with developer permission. SQLer generates SQL for the customer's application to execute; its product page says results remain in the customer's environment and lists single-tenant security. When a schema spans separate databases, separate queries are required for each database. DaaX reports 96% equivalence to expert-written SQL on a customer benchmark of 300 production queries. SQLer is available through web and API platforms. Its free plan includes 50 NL2SQL queries per month; paid plans start at $199 a month for 2,500 monthly queries.