Enable MySQL HeatWave REST Service (MRS)

Introduce the MySQL HeatWave REST Service (MRS), a fully managed, integrated solution that lets you create RESTful API endpoints instantly, directly from your MySQL HeatWave databases.

There’s no need for backend coding, middleware, or third-party frameworks to provide streamlined and secure access to your data over HTTPS. '

With MRS, you can:

Eliminate complexity: Connect your apps to your data with simple HTTP requests, no additional backend layers required.
Accelerate development: Build progressive web apps, AI-powered solutions, and dashboards faster by auto-generating REST endpoints mapped to your MySQL schemas and tables.
Leverage built-in security and scalability: Role-based access, flexible authentication, and a high-performance HTTP server are all included out of the box for easy yet robust operations.

Whether you’re a frontend developer, data analyst, or full-stack engineer, the MySQL HeatWave REST Service lets you focus on building innovative applications while Oracle handles the REST infrastructure for you.

Step-by-Step: How to Deploy and Enable MRS for MySQL VsExten:

1. I took the MySQL from Docker 😁

2.Added the MySQL Shell for VS Code

FYR !

3.Run docker & took local admin login details.

4.Add Database connection as below
FYR

5.In the connection I have DB schema called shopdb ,customer is a table ran in notebook to see the records as below

6.Let's enable the MRS to DB connection level

7.Add MySQL database schema to the MRS Service by simply right clicking on the schema in the DATABASE CONNECTIONS view and select Add Schema to REST Service from the popup menu. Verify details and click OK and the schema will be added to the MRS Service.

In next Add the Table to Rest services

Ensure the desired CRUD operations are selected (READ is selected by default) and again remove the checkmark from the Requires Authentication flag to make the object publicly available.

The below is reference of CRUD selection!!

Now that a REST Service has been created and the MySQL Router has been started, we can access the REST endpoints with a web browser.

In Postman I tested as successfully

In a similar way, you can try for the rest of the endpoints to access the data.

With MRS, you get more than just REST endpoints:

• Role-based access and endpoint control to govern who can access (and change) what.
• Flexible authentication including MySQL user accounts or external identity providers.
• Automatic API generation for CRUD, joins, and even in-database ML/LLM operations, letting you build AI-powered apps with ease.
• Integration with familiar tools like MySQL Shell and Visual Studio Code.

Conclusion:

The MySQL HeatWave REST Service represents the next evolution in how applications connect to MySQL natively, simply, and securely. With just a few steps, you can expose secure, high-performance APIs on your HeatWave-accelerated data, cut down on stack complexity, and accelerate your innovation.