Azure SQL modules for JavaScript

  • Article

Work with data stored in Azure SQL Database from JavaScript. The management library provides an interface to make it easy to manage Microsoft Azure SQL databases.

Client package

Install the npm module

Install the SQL Server client npm module

npm install tedious

Example

This example connects to a SQL Server database and perform a simple query.

const Connection = require('tedious').Connection;
const Request = require('tedious').Request;

const config = {
  userName: 'your-username',
  password: 'your-password',
  server: 'path-to-server',
  options: {
    database: 'database-name',
    encrypt: true
  }
};

const connection = new Connection(config);
connection.on('connect', err => {
  err ? console.log(err) : executeStatement();
});

const query = 'SELECT * from TableName';
const executeStatement = () => {
  const request = new Request(query, (err, rowCount) => {
    err ? console.log(err) : console.log(rowCount);
  });

  request.on('row', columns => {
    columns.forEach(column => console.log(column.value));
  });

  connection.execSql(request);
};

Management package

Install npm modules

Install the Azure SQL Server management npm module

npm install @azure/arm-sql

Samples

For more code samples that use various Azure packages, explore the JavaScript samples.