The following describes sample code to query SQL Server using Node JS

const sql = require('mssql')

const config = {
  user: 'username',
  password: 'your_password',
  server: 'server',
  database: 'databasename',
}

async function querySqlserverDatabase() {
  try {
    await sql.connect(config)
    const result = await sql.query('SELECT * FROM table_name')
    console.log(result.recordset)
  } catch (err) {
    console.error(err)
  }
}

querySqlserverDatabase()