mnemiq vs QueryPlane

mnemiq is an open-source text-to-SQL engine for enterprise data agents, configured and measured against a user's own database. Before execution, a deterministic check verifies that proposed SQL is read-only, uses permitted objects, compiles in the source dialect, and passes EXPLAIN. Access permissions apply before schema retrieval, so the model is not shown tables the caller cannot access. Each answer includes the SQL run, the tables it touched, and the enrichment version used. mnemiq can profile columns and build descriptions, grain, glossary terms, and coded-value meanings; a human owner can certify semantic definitions. Listed databases are PostgreSQL, SQLite, DuckDB, Oracle, Snowflake, and Databricks, with DuckDB as the universal executor. Models can use any OpenAI-compatible /v1 endpoint, including local servers such as vLLM, Ollama, llama.cpp server, and LM Studio. Its MCP server offers two read-only, access-scoped tools: db_read(question) and get_schema(). One process can also serve a workbench and HTTP endpoints for asking, chatting, and retrieving schema. The Apache-2.0 engine is free and runs in the user's environment. Local model hosting keeps schemas, questions, and rows inside the user's network, according to the maker.

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.