This article showcases the power of combining the LangChain framework with an LLM hosted on MySQL HeatWave GenAI. Our goal is to create an agent that can answer the question, "What is the current weather in Fahrenheit?". To do this, the agent must first fetch the weather (which is in Celsius) and then convert it to Fahrenheit, a classic multi-step task. This agent will demonstrate how a Large Language Model (LLM) can use tools and a logical sequence of steps to solve a problem.

This post will guide you through building a simple RAG workflow using the popular LangChain framework, powered entirely by the in-database AI capabilities of MySQL HeatWave GenAI. We will ingest a public blog post, index it in the HeatWave Vector Store, and use a HeatWave-hosted LLM to answer questions based on its content following the LangChain guide to creating vector stores and using them for RAG.

Ready to grow your querying skills? This post introduces curious newcomers to the WHERE clause in MySQL, showing how simple conditions, clever operators, and cheerful library metaphors can help you filter data like a pro. Find the exact records you need using approachable SQL examples—no dusty catalogs required!

We’re introducing a powerful set of enhancements aimed at boosting service availability and manageability thereby simplifying migrations from AWS Aurora, RDS, or MySQL on EC2, and improving performance.

This blog post shows the performance evaluation of the BLOB_INLINE_SIZE column option for NDB tables in comparison without it, as well as the benefits of batching BLOB read and writes.

Curious about what's inside your MySQL tables? This post introduces beginners to the SELECT statement, using friendly library metaphors, approachable SQL examples, and helpful tips—including how to alias column names. Get ready to start exploring your data with confidence!

Having explored the innovative MySQL HeatWave technology that converts Natural Language into SQL (Ask Your Database Anything: Natural Language to SQL in MySQL HeatWave), our next article in this series, dives into a practical use case demonstrating how an AI DBA Assistant can significantly simplify your query generation workflow. In MySQL, there are 3 specialized […]

The post Let Your AI DBA Assistant Write Your MySQL Queries first appeared on dasini.net - Diary of a MySQL expert.

This blog gives you a complete overview of MySQL HeatWave sessions so you can plan your agenda, mark your calendar, and make the most of the event.

Learn how to responsibly update or delete your MySQL data—including the concept of soft deletes—using engaging library metaphors and practical SQL examples. This post guides beginners through UPDATE and DELETE statements, safety tips, and real-world scenarios.

Natural Language to SQL in MySQL HeatWave makes data accessible to everyone, not just SQL experts. By turning plain English into optimized queries, it removes barriers and speeds up insights. While best practices help ensure accuracy, the feature already shows how LLMs are transforming the way we work with data. With the NL_SQL routine, asking your database questions is as simple as asking a colleague.

The post Ask Your Database Anything: Natural Language to SQL in MySQL HeatWave first appeared on dasini.net - Diary of a MySQL expert.