database.js

const mysql = require('mysql');
const db = mysql.createConnection({
  connectionLimit : 10,
  host     : process.env.DATABASE_HOST,
  user     : process.env.DATABASE_USER,
  password : process.env.DATABASE_PASSWORD,
  database : process.env.DATABASE_NAME
});

db.connect(function(err) {
    if (err) throw err;
});

module.exports = db

env-sample

DATABASE_HOST=
DATABASE_USER=
DATABASE_PASSWORD=
DATABASE_NAME=
PORT=3000
SMTPUSER=
SMTPPASS=

relatorio.controller.js

const dbi = require('../../db/database');
const XLSX = require('xlsx');
const fs = require('fs');
const exec = require('child_process').exec;

exports.gerarRelatorioDiario = (req, res, next) => {
    const sql = `SELECT * FROM table t    
    WHERE t.id = ? AND T.data_atualizacao BETWEEN DATE_ADD(NOW(), INTERVAL - 1 DAY) AND NOW()`
    dbi.query(sql,[1234], async function (error, results, fields) {
        if(error) {
            res.status(500).json({ errors: [{ msg: "Houve um erro ao consultar dados"}]});
        }
    const ws = XLSX.utils.json_to_sheet(results);
    const wb = XLSX.utils.book_new();
    XLSX.utils.book_append_sheet(wb, ws, "Relatório");
    await XLSX.writeFile(wb, 'planilha.xlsx');
    next();
    });
}