Engineering Blog

Design decisions and mechanisms inside the engines, and the services opened on them. Dates and numbers come from repository history and recorded source inspections.

Text-to-SQL2 min read

Before a question becomes SQL: a Text-to-SQL engine built on semantic contracts and AST validation, and the QueryMind deployments it runs

The hard part of turning language into SQL is not generation but meaning and boundaries. Injecting metric contracts into the syntax tree, rejecting forbidden nodes before execution, running read-only — the design and five months in the field.

MCP publishing2 min read

Publishing approved queries as MCP tools: QueryMind Connect, which never regenerates SQL per call

The most dangerous way to open enterprise data to an AI client is to let the model write SQL on every call. Here only administrator-frozen definitions become tools, every call runs under argument, permission and output limits — and a real call recorded on November 8, 2026.

Controlled generation2 min read

The database decides, the model composes: a controlled-generation engine built on four packet layers, and the Taste Edition service opened on it

In a long-form generation system some decisions must not be left to the model: what to reference, in which order and length to write, whether a draft passed. How D1–D4 distillation packets, database gates, checks and a publish gate moved those decisions into the system — and forty days of unattended serialization.

Knowledge publishing2 min read

From one approved snapshot to HTML, JSON-LD, facts.json and answer pages: a structured-knowledge publishing engine, and the FactMind service opened on it

The facts AI search reads must come from the same approved content people read. A site-control gate, five kinds of output from one snapshot, consistent corrections, and a loop that measures exposure in numbers.

Document reasoning2 min read

A rule engine that keeps 'unknown' as a result state: document reasoning for court auction files, and the Jupgo service opened on it

Confirmed absence and unobtained information are different inputs. Extracting tenant lists as three states — absent, unknown, value — a decision function that calls no model, conservative assumptions written into the result, and the record from app to MCP.

Text-to-SQL

Why SQL validation starts before SQL.

Meaning, scope, and permission are separate concerns.

Text-to-SQL

Why approval is an execution boundary.

A prepared query still needs current access.

Text-to-SQL

What makes a data answer inspectable?

Result grounding and the limits of numeric checks.

Technology milestones

Only dates confirmed in repository history.

  1. MCP publishing

    Approved-query MCP call recorded — QueryMind Connect in Claude

  2. Text-to-SQL

    First real-customer database freeze reported

  3. Knowledge publishing

    GEO engine deployed — AI answers, sources, exposure engine, answer pages, crawl queue

  4. MCP publishing

    Controlled-generation MCP stage one — six Taste Edition read tools

  5. MCP publishing

    Document-reasoning MCP connector — Jupgo in Claude and ChatGPT

  6. Controlled generation

    Unattended serialization, one episode a day — Taste Edition episode 18

  7. Controlled generation

    Four database gates added to the controlled-generation engine

  8. Knowledge publishing

    Knowledge-publishing engine public — FactMind homepage; first self-service registration the next day

  9. Text-to-SQL

    Oracle-based university records database connected

  10. Text-to-SQL

    First field deployment of the Text-to-SQL engine (QueryMind)

  11. Text-to-SQL

    Metric contracts injected by the server into the SQL syntax tree (request → contract)

  12. Document reasoning

    Document-reasoning engine first commit — auction prediction and serving

  13. Engineering

    On-premise small-LLM provider (OpenAI-compatible) supported

  14. Text-to-SQL

    Text-to-SQL engine repository begins