mnemiq vs SQL Mocker
mnemiq
agenticfabriq.comSQL Mocker
sqlmocker.comSide by side
| Figure | mnemiq | SQL Mocker |
|---|---|---|
| Price from | Free | $10/mo |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Web | Yes | Yes |
| API | Yes | — |
| Self-hosted | Yes | — |
| Plans published | 2 | 5 |
| Spec score · AI SQL Generators | 7.8 (#8) | 7.5 (#14) |
| Database support | The page lists PostgreSQL, SQLite, DuckDB, Oracle, Snowflake, and Databricks, with DuckDB as the universal executor. | The homepage lists 17 supported systems: SQL Server, PostgreSQL, MySQL, Oracle, SQLite, MariaDB, Snowflake, BigQuery, Amazon Redshift, Databricks, SAP HANA, IBM Db2, Teradata, Microsoft Access, ClickHouse, DuckDB, and MongoDB. |
| Purpose | mnemiq is an open-source text-to-SQL engine for enterprise data agents that can be configured and measured on a user's own database. | SQL Mocker generates SQL from natural-language questions using a reviewed copy of database schema metadata. |
Plans
SQL Mocker
- ExploreFree
- Starter$10 a month
- Pro$20 a month
- Business$39 a month
- EnterprisePriced on request
In their own words
mnemiq
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.
SQL Mocker
SQL Mocker is a web app that generates SQL from natural-language questions using a reviewed copy of database schema metadata. Users can provide schema details through a file, pasted metadata, manual setup, or results from an extraction script run in their own database. Its workspace can detect, review, edit, or add table relationships, including ones missing from the supplied metadata. Existing SQL can also be submitted for explanation, review, improvement, formatting, conversion, troubleshooting, or mapping columns and joins. SQL Mocker can generate dummy data from a schema to preview results and test query logic without production rows. Its homepage lists 17 supported database systems, including SQL Server, PostgreSQL, MySQL, Oracle, Snowflake, BigQuery, and MongoDB. It says it needs no database credentials for schema-based generation and does not connect to a live customer database. Generated SQL is presented for review and copying; users run it themselves in their own database tool. Saved projects sync to the user account and are cached in the browser, with backup files available from History. The free Explore plan includes 50 AI queries total and five saved projects; paid plans are marked as coming soon.