dasini.net – Diary of a MySQL expert

Bridging natural language processing with semi-structured data brings both opportunity and complexity.

MySQL HeatWave GenAI’s NL2SQL feature shows how natural language can simplify data interaction — even for JSON documents. Yet, because JSON embeds both data and metadata within a single column, LLMs may struggle without explicit schema cues.

By creating well-structured views that reveal JSON’s internal organization, you can transform unstructured data into a relational format the model understands — improving both query accuracy and overall usability.

This approach highlights how MySQL HeatWave continues to evolve as a powerful engine for intelligent, natural language–driven analytics.

In the previous episode we’ve seen how to use an OCI Bastion session in order to provide a restricted and time-limited access to administer our MySQL instance.
One more step to our Discovering MySQL Database Service journey.

In this episode, we’ll learn how to connect to our MySQL Database Service instance using the fantastic MySQL Shell – an interactive Javascript, Python, or SQL interface supporting development and administration for the MySQL Server.