Generative AI Database Explorer
With Generative AI Database Explorer, you can explore your database schema and stored procedures using Generative AI. This tool helps you understand your database schema and stored procedures by generating SQL queries based on the schema and explaining the schema and stored procedures in the database to the user based on the stored schema.
Although there are many other tools available that perform similar functions, this tool produces a semantic model of the database schema, combined with a data dictionary and enriched using Generative AI.
The reason that this approach of enriching a semantic model rather than just querying the database directly is:
- Many databases are not normalized and have grown organically over time. This can make it difficult to understand the schema and stored procedures by just looking at the table & column names.
- Data dictionaries are often not maintained or are incomplete, but can still be useful to provide additional information about the schema.
- Additional grounding information may need to be provided by a user to ensure that the Generative AI can provide accurate information.
- Enables greater control and the database owner can review and adjust the semantic model to ensure it is correct.
- The semantic model can be stored in version control and used as an asset that is deployed as part of another application.
