1.1 What is AI Enrichment

AI enrichment is the process of adding a layer of descriptive, business-centric metadata to your database schema without altering the underlying data or structure.

You can enable this capability in Oracle SQL Developer for VS Code, where you can annotate your database objects (schemas, tables, and columns) with crucial context, synonyms, and natural language descriptions.

By using annotations to declare the intent of your data, you can make your database more understandable and AI-ready for LLMs and natural language querying. This enrichment enables LLMs to generate more accurate, context-aware SQL queries.

The AI enrichment feature in Oracle SQL Developer for VS Code offers several key capabilities to streamline this process:

  • It allows you to capture descriptions and annotations for schemas, tables, and columns.

  • It allows you to organize tables into groups that align with your application domains.

  • It surfaces intelligent opportunities to add enrichment where it's required most.