Auto Ontology MCP: open-source semantic layer lets Claude and ChatGPT query your DB safely
solyarisoftware · x · 2026-11-22
auto-ontology-mcp (Apache-2.0, 531 stars) brings NVIDIA Auto Ontology's semantic layer to any MCP client so Claude or ChatGPT can understand your database before writing SQL — no LLM API key needed.
- Builds an ontology from schema, data distributions and key relationships; AI-generated SQL is checked for nonexistent columns, off-ontology joins, and one-to-many double counting before execution.
- Safety: read-only connections, SQL guards, transaction rollback, 30s timeout, 500-row cap. Deterministic work stays on the server.
- Includes a personal knowledge base exportable as an Obsidian vault with backlinks, echoing Karpathy's LLM Wiki idea.
- Caveats: connection strings with passwords stored in plaintext locally; MySQL/DuckDB untested on real servers.
More from coding & agent
- Ex-Meta engineer: AI usage generates a fragile codebase — 90% AI code didn't 2X output — bibryam · 2026-11-22
- App Store Connect CLI 7.1.0 Adds Product Page A/B Test Results in the Terminal — rudrank · 2026-11-22
- 10 skills to fix the cookie-cutter look of AI-generated websites, drop into Claude Code or Cursor — sven_ai · 2026-11-22
- A catalog of 2,256 real agent use cases with copyable prompts, from bill-negotiating bots to 11-agent trading teams — sven_ai · 2026-11-22
- Dev ports Inkling-2-Mini to a single AMD R9700: 196K context at ~110 tok/s — abhinand05 · 2026-11-22
- Disney Parks MCP Server offers structured queries for attractions, dining and Lightning Lane status — modelcontextprotocol · 2026-11-22