Natural Language SQL vs QueryPlane

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.

QueryPlane is an app builder for internal tools and data applications connected to databases and data warehouses. A drag-and-drop builder lets users assemble tables, charts, and forms without frontend code. Plain-English prompts generate schema-aware SQL and interface components, while JavaScript with full IDE support can transform query data. Listed database connections include PostgreSQL, Snowflake, MySQL, MongoDB, BigQuery, Databricks, ClickHouse, Redshift, SQLite, CockroachDB, MariaDB, Supabase, Neon, PlanetScale, TimescaleDB, and AlloyDB. Read-only mode can help prevent accidental changes to production data, and viewer, editor, and admin roles provide access controls. QueryPlane says credentials are encrypted, database contents are not stored, and queries run in real time, though query metadata may be cached. It is available on the web and as self-hosted software. The Free plan is free and allows up to 3 apps, 1 database connection, and 50 AI prompts per month. Pro is $49 a month, with a 14-day trial listed.