跪拜 Guibai
← All articles
Artificial Intelligence

NVIDIA Auto Ontology Puts a Human-Certified Semantic Layer Between Agents and Enterprise Data

By 冬奇Lab ·
Read original on juejin.cn ↗ Google Translate ↗ Alt translation

Agents that query enterprise data now have a way to fail loud instead of wrong: certified definitions and explicit refusal on low coverage turn silent data corruption into a visible, fixable event. That's the difference between a demo and a tool you can attach to a production reporting pipeline.

Summary

Enterprise data agents routinely produce runnable SQL with wrong numbers because column names like `revenue` don't carry tax treatment or metric ownership. NVIDIA's Auto Ontology tackles that by generating a context layer from metadata: it extracts business terms, audited SQL expressions, and table relationships, then requires a human to test and certify them before any agent uses them. The three-step Generate-Certify-Answer loop writes everything to PostgreSQL with pgvector embeddings.

The key behavior is honest refusal. When retrieval candidates can't support a query, the agent reports a coverage score and says it can't answer, rather than fabricating a result. The system exposes read-only MCP tools, a REST endpoint, and Skills; it supports ten databases including PostgreSQL, Snowflake, ClickHouse, and DuckDB, and works with any OpenAI-compatible model endpoint.

Deployment caveats matter: ingestion endpoints on ports 3001/3002 have no authentication, all default passwords must be changed, and the project does not accept external pull requests. Also, despite the repo description mentioning deterministic query generation, SQL is still written by an LLM; only the definitions are human-certified and validated.

Takeaways
— Auto Ontology builds its context layer by extracting business terms, SQL attributes (like gross margin formulas), and table relationships from metadata, then having humans certify them.
— The core loop is Generate → Certify → Answer: generate from metadata, certify with human testing, then answer with retrieval, SQL generation, validation, and repair.
— When retrieved candidates can't support a query, the agent returns a coverage score and explicitly says it cannot answer, rather than guessing.
— The default LLM is nvidia/nemotron-3.5-lightning-30b-a3b, and any OpenAI-compatible endpoint can be used for the four model roles: REASONING, NON_REASONING, EMBED, RERANK.
— MCP integration (read-only) exposes check_readiness, search_terms, get_term, get_term_columns, get_term_sql_attributes, get_sql_attribute, describe_table, check_answerable, and ask_question.
— Ingestion endpoints on ports 3001 and 3002 have no authentication; default credentials must be changed before deployment.
— The project accepts no external pull requests; contributions go through issues only.
— Compiling the Wide World Importers sample produced 31 terms.
Conclusions

The honest refusal mechanism treats low evidence as a first-class output, not an error state. That's a more practical reliability design for enterprise query agents than forcing a confident answer, because it converts silent wrong results into a checkable coverage number.

The repo description's 'deterministic query generation' claim is softer than it sounds: SQL is still LLM-generated, only the definitions are human-certified and the output is validated. Teams that require fully reproducible queries need to verify this distinction themselves.

Auto Ontology is deliberately additive, designed to coexist with existing semantic models rather than replace them. That positions it as a compatibility layer for agent consumption, which makes adoption easier but also means its value depends on how much certification effort a team is willing to invest.

Concepts & terms
Semantic layer
A layer of business definitions and relationships placed between an AI agent and a database, so the agent interprets column names and metrics consistently rather than guessing from literal names.
MCP (Model Context Protocol)
A protocol that lets AI applications and agents connect to external tools and data sources; Auto Ontology exposes its read-only query capabilities as MCP tools.
pgvector
A PostgreSQL extension that stores and queries vector embeddings, used here to index semantic representations of terms and columns for retrieval.
Deterministic query generation
A claim that query results are reproducible; in Auto Ontology this applies to human-certified definitions and validation steps, not to the LLM's SQL writing itself.
Source: juejin.cn ↗ Google Translate ↗ Backup ↗