Skip to content

About

Auto Ontology is a Python framework for building semantic, graph-based reasoning layers over data. It enables deterministic query generation, better context retrieval, and more explainable AI for LLM and agent workflows.

Resources

Code of conduct

Contributing

Security policy

Stars

13.6k stars

Watchers

56 watching

Forks

Latest commit

 

History

1,391 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Pussy 888 Apk Try Mbeya Slot Download The Pussy888 More Payouts

Download pussy888 malaysia apk, pussy888, pussy888, must mbeya university of science and technology, the pussy888 demo id gives you a chance to experience malaysia s most popular online casino app for free it s the perfect way to test slots Pussy888 With 2026 Premium 2025 Pussy888 All Dapat Client But fishing games and table games without depositing a single ringgit.

Pussy 888 0 1 apk download for android pussy 888 slot machine mobile game, leading Pussy888 Online Gambling With Official Games Pussy888 Pussy888 Interface Via centre of excellence for knowledge skills and applied education in science and technology, pussy 888 apk for android download, pussy888 download latest apk ios malaysia 2026, pussy888 online gambling.

Pussy888 Online Client Slots Pussy888 Ios App Simple

Lepas download game akan dpt free credit lepas menang janji dapat withdraw, pussy888 is the Download Pussy888 Malaysia Apps Out Pussy 888 1 Share Others Real first in malaysia to offer web browser access try pussy88 or puss888 online with easy apk download, pussy888 game list explore every game on malaysia s favorite casino app the pussy888 game list is where the excitement begins for every malaysian player designed to give users a complete view of the casino s vast collection it includes all the latest slot titles classic table games fishing arcade shooters and live casino experiences all within one mobile app whether you re a.

Download pussy888 apk on android or play online on ios available across southeast asia register free deposit rm30 and claim your rm60 welcome bonus today, pussy888 game list 2026 all slots table live casino Telegram Channel Live Technology Pussy888 Is Spins Test Experiences games.

Pussy888 Out Version Pussy888 Is Live Explore

About us who we are at pussy888, pussy888 pussy888, learn about pussy888 malaysia s trusted online casino and sportsbook our mission values and commitment to safe fast and fair gaming for malaysian players, pussy888 ios apk free download enjoy access to over 100 games with a simple easy to use interface play anytime with Pussy888 Instant Telegram Casino Science The Pussy888 Jackpot Money smooth and stable performance.

Pussy888 apk ios download link 2026, pussy888, experience the full pussy888 casino live dealer tables baccarat roulette blackjack dragon tiger and Pussy888 Download Play List Learn About Pussy888 Gaming But Earn more fast payouts via maybank cimb bank touch n go ewallet boost.

Play pussy888 slots live casino games fishing and arcade entertainment on android and ios devices Pussy888 Slots Puss888 Apps Experience The First Available with smoother mobile gameplay cashback rewards and responsive access across asia.

Must Mbeya Table For Free Pussy888 Pussy888 Share Club Available

Description download pussy888 safely with our official step by step guide for android apk ios and pc verify files avoid scams and learn updates bonuses and troubleshooting, when you search for online betting apps then you might get confused as there are a About Us Link Test Pussy888 Is Ton Single Then ton of options available but we always prefer the puss888 apk as it s one of the most trusted and reputed apps for betting your money on various games including the poker casino slots and many others you might find a ton of amazing online betting games in this app to try out and earn huge rewards as.

#1 on the BEAVER leaderboard#2 on the BIRD-Interact leaderboard

Agents can retrieve documents and query databases, but reliability gates agentic analytics: a revenue metric answered faster is worth nothing if the number is wrong. Agents need context to answer accurately: what each business concept means, where it lives, how it connects, how to calculate it, where it comes from, and whether to trust it. An ontology holds that context: a shared, governed map from the concepts people ask about to the data behind them. NVIDIA Auto Ontology is an open library that builds that ontology automatically from enterprise metadata, reconciles definitions across systems, and exposes it to any agent harness through MCP, CLI, and API. It complements the semantic models customers already own, and Apache Ossie keeps it portable.

It enables developers to:

  • Discover: generate enterprise ontologies from metadata; connect existing ontologies and semantic models; build AI-ready knowledge graphs.
  • Ground: give agents trusted business meaning for metrics, entities, and relationships; reconcile inconsistent definitions across systems.
  • Validate: test a draft with real questions before experts certify it; check generated queries against the catalog and the definitions retrieval surfaced; return the SQL and steps with every answer.
  • Expose: serve context to any agent harness through MCP, CLI, and API.
  • Learn: fold certified corrections and usage back into the ontology, so shared context improves with use.

An ontology matters most when:

  • questions are varied, open-ended, and ambiguous;
  • data spans many disparate sources with overlapping or conflicting definitions;
  • meanings must be reused and governed across runs, teams, and agents;
  • the model or its context budget can't hold the full documentation;
  • users ask in business terms and need routing to the right source and grain.

With one well-modeled source and a fixed set of questions, direct SQL may be enough.

Quickstart

This runs Auto Ontology with Docker Compose against Wide World Importers, Microsoft's sample sales database. You need Docker with Compose v2, uv, and an NVIDIA API key (nvapi-...) from build.nvidia.com.

  1. Clone the repository and create .env:

    git clone https://github.com/NVIDIA/auto-ontology.git &&cd auto-ontology cp .env.example .env

    Then set these values in .env:

    DEFAULT_MODELS_API_KEY=nvapi-...AUTH_SECRET=<a long random string, e.g. from openssl rand -base64 32>APP_URL=http://localhost:3000POSTGRES_PASSWORD=<a new password>CONNECTION_STRINGS=postgresql://postgres:<the same password>@postgres:5432/wideworldimportersAUTO_ONTOLOGY_ADMIN_PASSWORD=<a new password>PGADMIN_PASSWORD=<a new password>

    Compose publishes Postgres, pgAdmin, and the web app on the host, so replace each default password before you start it. .env.example also sets an API key per model role: replace each nvapi-your-api-key-here with your key, or delete those lines so they fall back to DEFAULT_MODELS_API_KEY.

  2. Start Postgres and load the sample database. The seed script lives in auto-ontology-eval; pass it the Postgres password you set:

    docker compose up -d --wait postgres git clone https://github.com/NVIDIA/auto-ontology-eval.git ../auto-ontology-eval (cd ../auto-ontology-eval && uv sync && cp .env.example .env && \ POSTGRES_PASSWORD='<the same password>' \ uv run python scripts/seed/seed_wwi.py --database-name wideworldimporters --drop)
  3. Build and start the rest of the stack:

    docker compose up -d --build
  4. Open http://localhost:3000 and sign in with AUTO_ONTOLOGY_ADMIN_EMAIL and AUTO_ONTOLOGY_ADMIN_PASSWORD from .env. Go to Settings → Semantic Compilation and turn it on. Ingestion runs at startup; compilation starts immediately and reports Semantic compilation is ready when it finishes.

  5. Ask a question in Chat:

    What was revenue for the USB food flash drive - sushi roll in Pennsylvania in June 2015?

    The agent resolves revenue, product, and state to terms in the ontology, follows their relationships to the joins it needs, and runs the query. The answer comes back with its SQL and the steps that produced it, so you can check the result against the source:

    Answer: Revenue for USB food flash drive - sushi roll in Pennsylvania in June 2015 was $588.80, from 3 invoice lines. SQL: SELECT SUM(il.extendedprice) AS revenue, COUNT(*) AS invoice_lines FROM sales.invoicelines il JOIN sales.invoices i ON il.invoiceid = i.invoiceid JOIN warehouse.stockitems si ON il.stockitemid = si.stockitemid JOIN sales.customers c ON i.customerid = c.customerid JOIN application.cities ct ON c.deliverycityid = ct.cityid JOIN application.stateprovinces sp ON ct.stateprovinceid = sp.stateprovinceid WHERE si.stockitemname = 'USB food flash drive - sushi roll' AND sp.stateprovincename = 'Pennsylvania' AND i.invoicedate >= '2015-06-01' AND i.invoicedate < '2015-07-01' Steps: Resolved terms: Invoice Line (revenue), Stock Item, State Province, Invoice Joined: invoice line -> invoice -> customer -> city -> state province Validated the filter values against the data, then executed 
  6. Ask something the data can't answer. Wide World Importers has no advertising data, so a question about ad spend has nothing to resolve against. An agent connected through MCP checks answerability first and asks you to clarify:

    You: What was return on ad spend for the sushi roll flash drive in June 2015? Agent: check_answerable -> coverage 0.5; no term covers "ad spend" Agent: I can find revenue for that product, but this data has no advertising spend, so I can't compute return on ad spend. Do you want June 2015 revenue instead, or is ad spend tracked in another source I should connect? 

If the UI loads without its left navigation after a restart, the browser is holding a stale session cookie. Clear site data for localhost:3000 and sign in again. For other setup failures, see the setup skill's troubleshooting guide.

How it works

Auto Ontology works in two stages: it generates an ontology that people certify, and the agent answers questions from it.

The ontology answers six questions, each with its own element:

QuestionElementIn Auto Ontology
What does it mean?ConceptA term, such as Customer or Invoice Line, with a description and synonyms
Where is it?MappingColumn attributes tie each term to the tables and columns that hold it
What's connected?RelationshipJoins between tables, including bridge tables: declared keys, plus inferred links confirmed against the data
How do I calculate it?MetricSQL attributes: reviewed SQL under a term, such as a margin, reused so answers compute each measure the same way
Where does it come from?LineageEach term and attribute links to its source tables and columns, and each answer returns its SQL
Should I use it?CertificationExperts certify names, descriptions, and attributes, and certified elements are marked as reviewed

Generate: the ingestion service builds a first draft from the source databases, and people refine it. Semantic compilation starts once you turn it on in Settings → Semantic Compilation.

  • Catalog ingest: read tables, columns, keys, views, and query history; tag PII if you turn on PII detection; embed tables and columns in pgvector.
  • Per table: profile values with SQL. A model finds foreign key candidates and junction tables, writes column descriptions, and names the terms.
  • Across tables: group copies of a schema into term families, and link foreign keys to the terms they reference, keeping an inferred link only when the data confirms it. A model attaches foreign key columns left unlinked, suggests SQL attributes from query history and for bridge tables, and describes each column attribute.
  • Output: the ontology in Postgres with embeddings in pgvector, which you can import or export as Ossie YAML.
  • Certify: test the draft with real questions in Chat, or with check_answerable and ask_question over MCP. Refine terms, descriptions, and SQL attributes in the UI or through the API, and certify them once they're correct. Edits are re-embedded right away, and the next compilation keeps them, except which semantic foreign key each join uses, which every compilation re-selects.

The Generate tool flow shows which steps call a model and which are SQL or rules.

The result is a semantic graph you can explore in the UI. In this example, one compilation of Wide World Importers produced 31 terms; selecting Order shows its description, related terms, mapped columns, and SQL attributes:

Semantic graph of the Wide World Importers ontology, with the Order term selected

Answer: the reasoning model answers each question in a loop, choosing one tool at a time:

  • retrieve: search the semantic layer by meaning and by name for business concepts, column meanings, and named calculations. Results come back as tables and columns with their descriptions and stored values, definitions with their SQL, and join paths. The model searches again whenever something is missing.
  • run_sql: look at stored values or test a draft. Before the query runs, table and column names are checked against the catalog, and tables against what retrieve showed.
  • submit: give the final query and an explanation. The query is checked and run, and an error goes back to the model to fix. A question about the data itself, such as which tables exist or what a term means, is answered in words: retrieve looks it up with purpose=information, and submit returns the answer without SQL.
  • Result: the answer comes back with its SQL and the steps it took, and a chart in Chat.

No tool calls a language model except predict, which answers predictive questions when KUMO_RFM_API_URL is set; see Predictions. If the model reaches its tool-call limit without an accepted query, the agent reports that the question can't be answered from this data. The Answer tool flow shows the loop, its tools, and its limits.

In Chat, each answer shows its SQL, and you can view the rows, download them as CSV, or read them as a chart:

Chat answering which products drive the most revenue and highest customer count, with the generated SQL and a revenue chart

Auto Ontology is compatible with Apache Ossie, the open standard for exchanging semantic models. Ossie includes a converter for Auto Ontology, which Auto Ontology uses to import and export model definitions as Ossie YAML. Use Settings → Import / Export, or POST /api/model/import and POST /api/model/export.

The services behind both stages, and how clients reach them:

flowchart LR subgraph clients["Clients"] direction TB ui["Browser: web UI"] rest["Scripts: REST API with API tokens"] mcpc["MCP clients: Cursor, Claude Desktop, agents"] end mcp["MCP server: read-only tools (FastMCP, port 3003)"] fe["Web app, auth, API gateway (Next.js, port 3000)"] subgraph private["Private network"] direction TB be["Backend: text-to-SQL agent, catalog and ontology APIs (FastAPI, port 3001)"] ing["Ingestion and semantic compilation (FastAPI, port 3002)"] pg[("Postgres + pgvector: app data, catalog, ontology, embeddings")] end src[("Source databases: 10 connectors")] models["Model endpoints: NVIDIA NIM or OpenAI-compatible (reasoning, non-reasoning, embed, rerank)"] vault["Vault (optional): connection credentials"] kumo["KumoRFM (optional): predictions"] ui --> fe rest --> fe mcpc --> mcp mcp -- "public API" --> fe fe --> be fe -- "users, sessions, settings" --> pg be -- "trigger ingest and compile" --> ing be --> pg ing --> pg be -- "run SQL" --> src ing -- "read schema, sample values" --> src be --> models ing --> models be -.-> vault ing -.-> vault be -.-> kumo 
Loading
ComponentTechnologyRolePort
FrontendNext.js, Better Auth, PrismaWeb UI for chat, catalog, analytics, and settings; auth and RBAC; public API gateway3000
BackendFastAPI (Python 3.12+), LangChainText-to-SQL agent, catalog, ontology APIs3001
Ingestion serviceFastAPI (Python 3.12+)Ingestion and semantic compilation3002
MCP serverFastMCPRead-only agent tools over the public API3003
Postgres + pgvectorPostgreSQL 17Catalog, ontology, app data, vector store5432
HashiCorp VaultOptionalConnection credential storagen/a

Browser and API clients go through the web app on port 3000, and MCP clients through the MCP server on port 3003, which calls the same public API. Keep ports 3001 and 3002 on a private network: FastAPI trusts the user identity the frontend forwards in the x-auto-ontology-user-id header, and the ingestion service's endpoints (ingest, delete, reset, compile) have no authentication of their own.

Full pipeline detail, with tool-flow diagrams for generating an ontology and answering a question: docs/architecture.md.

Use it from your agent

MCP server

The MCP server gives any MCP client read-only tools over the ontology. Each user signs in through Auto Ontology, and every call runs with that user's permissions.

JobTools
Readinesscheck_readiness: can this deployment answer anything at all
Termssearch_terms, get_term, get_term_columns, get_term_sql_attributes, get_sql_attribute, describe_table
Answerabilitycheck_answerable: does the ontology cover this question
Questionsask_question: the answer, the SQL, and the rows

Run the server against your deployment:

AUTO_ONTOLOGY_API_URL=http://localhost:3000 \ uvx --from "git+https://github.com/NVIDIA/auto-ontology.git#subdirectory=mcp" auto-ontology-mcp

Cursor (~/.cursor/mcp.json):

{ "mcpServers": { "auto-ontology": { "url": "http://localhost:3003/mcp" } } }

Claude Desktop (claude_desktop_config.json), bridged with mcp-remote:

{ "mcpServers": { "auto-ontology": { "command": "npx", "args": ["mcp-remote", "http://localhost:3003/mcp"] } } }

Restart the client after editing its config, then sign in when it prompts. Sign-in, configuration, and troubleshooting are in docs/mcp.md.

Agent skills

Three skills teach a coding agent to work with Auto Ontology. Start at AGENTS.md.

SkillCovers
nvidia-ontology-setupInstall, connect sources, compile, prove readiness
nvidia-ontology-managementInspect, model, certify, import/export, and publish
nvidia-ontology-queryAsk questions and validate the SQL, rows, and answer

REST API

Ask a question with POST /api/chat/completions on the web app's origin. Mint an API token under the user menu → API Tokens. The response is a server-sent event stream: a result event carries the answer, and data: [DONE] ends the stream.

curl -N http://localhost:3000/api/chat/completions \ -H "x-api-key: $AUTO_ONTOLOGY_API_TOKEN" \ -H "Content-Type: application/json" \ -d '{"question": "How many orders shipped last week?"}'
importjsonimportosimportrequestsresponse=requests.post( "http://localhost:3000/api/chat/completions", headers={"x-api-key": os.environ["AUTO_ONTOLOGY_API_TOKEN"]}, json={"question": "How many orders shipped last week?"}, stream=True, timeout=900, ) response.raise_for_status() forlineinresponse.iter_lines(decode_unicode=True): ifnotlineornotline.startswith("data:"): continuepayload=line.removeprefix("data:").strip() ifpayload=="[DONE]": breakevent=json.loads(payload) ifevent["type"] =="result": print(event["answer"]["response"]) print(event["answer"]["sql_code"]) elifevent["type"] =="error": raiseRuntimeError(event["message"])

Event types, multi-turn conversations, and the gateway trust boundary are in docs/conversation-api.md. Every other operation is in the OpenAPI spec.

Connectors, models, and predictions

Sources

Auto Ontology connects to ten engines:

  • PostgreSQL
  • MySQL
  • Databricks
  • Snowflake
  • ClickHouse
  • Trino
  • Apache Kyuubi
  • HeavyDB
  • DuckDB
  • SQLite

Add connections under Settings → Connections, or list them in CONNECTION_STRINGS. DuckDB and SQLite are connection-string only. See docs/connections.md for URL schemes, scoping, and credential storage.

Models

Auto Ontology uses four model roles. With an nvapi- key, each defaults to an NVIDIA NIM on build.nvidia.com:

RoleDefault modelWhat it does
REASONINGnvidia/nemotron-3.5-lightning-30b-a3bRuns the answering agent and check_answerable, builds the ontology, and detects PII
NON_REASONINGnvidia/nemotron-3.5-lightning-30b-a3bRewrites follow-up questions, plans charts, writes PQL for predictions, and runs the quick steps of interactive analysis
EMBEDnvidia/nemotron-3.5-embed-1bIndexes tables, columns, terms, and SQL attributes in pgvector, and matches each question to them
RERANKnvidia/nemotron-3.5-rerank-8bPicks the term that owns each bridge-table SQL attribute during compilation; not used to answer questions

To use self-hosted NIM or any OpenAI-compatible endpoint, set <ROLE>_ENDPOINT, <ROLE>_API_KEY, and <ROLE>_MODEL. Any field you leave unset falls back to DEFAULT_MODELS_<FIELD>, so the simplest setup fills in DEFAULT_MODELS_* and overrides only what differs; *_API_KEY also falls back to the legacy NVIDIA_API_KEY. Use models that support structured output, and keep the embedding model the same for ingestion and queries. .env.example documents every variable.

Predictions

Set KUMO_RFM_API_URL (and KUMO_RFM_API_KEY if your endpoint requires one) and the agent routes predictive questions to KumoRFM. KumoRFM is a hosted service: to answer, the agent uploads the connected tables to it, capped by KUMO_MAX_TABLES (20 by default) and KUMO_MAX_ROWS_PER_TABLE (unlimited unless set). Review what that sends, and complete your organization's data review, before you enable it.

Benchmarks

To run a text-to-SQL benchmark such as BIRD, refer to auto-ontology-eval, which scores the same model with and without the ontology on NeMo Gym.

Contributing

We welcome contributions: bug fixes, connectors, documentation, and examples. Please read the Contributing Guidelines before submitting pull requests.

To integrate an agent platform, application, or storage provider with Auto Ontology, open an integration request.

Reference

TopicDoc
Kubernetes deployment with HelmDEPLOYMENT.md
Architecture and pipeline stepsdocs/architecture.md
Connections, scoping, and Vaultdocs/connections.md
Authentication, SSO, and API tokensdocs/authentication.md
Conversation APIdocs/conversation-api.md
MCP serverdocs/mcp.md
REST APIdocs/openapi/auto-ontology-api.json

License

Auto Ontology is licensed under the Apache License, Version 2.0. SPDX identifier: Apache-2.0.

Each NVIDIA-authored source file in this repository carries an SPDX header of the form:

SPDX-FileCopyrightText: Copyright (c) 2024-2026, NVIDIA CORPORATION & AFFILIATES. All rights reserved. SPDX-License-Identifier: Apache-2.0 

Third-party open-source components used by Auto Ontology are enumerated, with their upstream licenses and project URLs, in THIRD_PARTY_NOTICES.md. Components added by the container images are listed separately in CONTAINER_THIRD_PARTY_NOTICES.md.

Notice and Disclaimer

NOTICE AND DISCLAIMER: This software automatically retrieves, accesses or interacts with external materials. Those retrieved materials are not distributed with this software and are governed solely by separate terms, conditions and licenses. You are solely responsible for finding, reviewing and complying with all applicable terms, conditions, and licenses, and for verifying the security, integrity and suitability of any retrieved materials for your specific use case. This software is provided "AS IS", without warranty of any kind. The author makes no representations or warranties regarding any retrieved materials, and assumes no liability for any losses, damages, liabilities or legal consequences from your use or inability to use this software or any retrieved materials. Use this software and the retrieved materials at your own risk.

External materials Auto Ontology interacts with at run time:

  • Model endpoints you configure, by default the NVIDIA API catalog (integrate.api.nvidia.com, ai.api.nvidia.com), under each provider's and model's terms.
  • The KumoRFM service, only when KUMO_RFM_API_URL is set, under Kumo's terms.
  • Your source databases, under your agreements for those systems.

Security

Report security vulnerabilities as described in SECURITY.md.

About

Auto Ontology is a Python framework for building semantic, graph-based reasoning layers over data. It enables deterministic query generation, better context retrieval, and more explainable AI for LLM and agent workflows.

Resources

Code of conduct

Contributing

Security policy

Stars

13.6k stars

Watchers

56 watching

Forks

Releases

Packages

Contributors

Languages