mnemiq vs NatureQuery

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.

NatureQuery turns natural-language questions into SQL, runs them against a connected database, and exports results as Excel spreadsheets or CSV files. Its AI is described as understanding database schemas, and the product can create bar, line, and pie charts from results. Listed database support includes PostgreSQL, MySQL, SQLite, SQL Server, MariaDB, and Amazon Redshift. Teams can invite members and share connections and saved queries using role-based access. The cloud service is available through the web and API. Its free plan costs nothing and includes 50 queries per month, one database connection, and 30 days of query history. Pro costs $20 a month and includes unlimited queries, 10 connections, collaboration for five members, API access, and priority support. Enterprise costs $79 a month and lists unlimited queries, connections, and members, plus SSO / SAML, audit logs and compliance, and dedicated support with an SLA. NatureQuery says credentials and connections are encrypted and query results are not stored.