Mysql – How to insert data to sql database using nodejs and sequelize?

To create the Model based on the data provided by you, I would be breaking down them down into three sub-models, one for config, another one for point and the last one for tooltip since those are the three feature of interest which we’re looking at. So in you models directory

// ./models/configModel.js
const { DataTypes } = require('sequelize');

module.exports = (sequelize) => {
    const Config = sequelize.define('Config', {
        id: {
            type: DataTypes.STRING,
            primaryKey: true
        },
        user_id: {
            type: DataTypes.INTEGER
        },
        imageurl: {
            type: DataTypes.STRING
        },
        name: {
            type: DataTypes.STRING
        },
        server: {
            type: DataTypes.STRING
        },
        size: {
            type: DataTypes.STRING
        },
        imageWidth: {
            type: DataTypes.STRING
        },
        imageHeight: {
            type: DataTypes.STRING
        },
        hide_logo: {
            type: DataTypes.INTEGER
        },
        point_color: {
            type: DataTypes.STRING
        },
        pulse: {
            type: DataTypes.BOOLEAN
        }
    });

    return Config;
};

// ./models/pointModel.js
module.exports = (sequelize) => {
    const Point = sequelize.define('Point', {
        pointId: {
            type: DataTypes.STRING,
            primaryKey: true
        },
        x: {
            type: DataTypes.FLOAT
        },
        y: {
            type: DataTypes.FLOAT
        }
    });

    return Point;
};

// ./models/tooltipModel.js
module.exports = (sequelize) => {
    const Tooltip = sequelize.define('Tooltip', {
        tooltipId: {
            type: DataTypes.STRING,
            primaryKey: true
        },
        title: {
            type: DataTypes.STRING
        },
        price: {
            type: DataTypes.STRING
        },
        link: {
            type: DataTypes.STRING
        },
        tooltipThumbnailUrl: {
            type: DataTypes.STRING
        },
        right: {
            type: DataTypes.STRING
        },
        left: {
            type: DataTypes.STRING
        },
        top: {
            type: DataTypes.STRING
        }
    });

    return Tooltip;
};

Once the three models have been created; then I would define a /saveData route inside my app.js or server.js file(this is opinionated and for simplicity I used, you can follow the routes folder approach as well) where the POST request happens.

const express = require('express');
const bodyParser = require('body-parser');
const db = require('./config'); // Your database config
const Config = require('./models/configModel');
const Point = require('./models/pointModel');
const Tooltip = require('./models/tooltipModel');

const app = express();

app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: true }));

// Rest of your code including your db sync code...

app.post('/saveData', async (req, res) => {
    const dataToSave = req.body;

    // Save config data
    const config = await Config.create(dataToSave.config);

    // Save points data
    for(let point of dataToSave.points) {
        const tooltip = await Tooltip.create(point.tooltip);
        point.tooltip = tooltip.id;
        const savedPoint = await Point.create(point);
    }

    res.send({ message: 'Data fetch Success' });
});

// Some other code

app.listen(3000, () => {
    console.log('Server is running on port 3000');
});

This code will start the server on port 3000. You can then send a POST request from you app or via some client to http://localhost:3000/saveData with your data object in the body to save the data to the database. Hope this helps.