node package manager
Love JavaScript? Your insights can make it even better. Take the 2017 JavaScript Ecosystem Survey »


Microsoft Azure SDK for Node.js - SQL Database Management

This project provides a Node.js package that makes it easy to manage Microsoft Azure SQL Database. Right now it supports:

  • Node.js version: 0.6.15 or higher
  • API version: 2012-03-01


  • Manage server
  • Manage database
  • Manage firewall rule
  • Manage service objective
  • Manage database copy
  • Manage database operation
  • Manage DAC (dedicated administrator connection)

How to Install

npm install azure-mgmt-sql

How to Use


This library support management certificate authentication. To authenticate the library for the REST API calls, you need to

  • Have a management certificate set up in your Microsoft Azure subscription. You can do this by
  • Obtain the .pem file of your certificate. If you used Microsoft Azure Xplat-CLI to set it up. You can run azure account cert export to get the .pem file.
  • Open the .pem file in a text editor to get the cert value and key value.

Create the SqlManagementClient

var fs            = require('fs'),
    sqlManagement = require('azure-mgmt-sql');
var sqlManagementClient = sqlManagement.createSqlManagementClient(sqlManagement.createCertificateCloudCredentials({
  subscriptionId: '<your subscription id>',
  pem: fs.readFileSync('<your pem file>')

Manage Database

var sqlDatabaseName = "database01";
// Create a SQL database server. 
  administratorUserName: "<your admin user name>",
  administratorPassword: "<your admin password>",
  location: "West US"
}, function (err, result) {
  if (err) {
  } else {
    sqlServerName = result.serverName;;
    // Create a SQL database. 
    sqlManagementClient.databases.create(result.serverName, {
      name: sqlDatabaseName,
      edition: common.Constants.SqlAzureConstants.WEB_EDITION,
      collationName: common.Constants.SqlAzureConstants.DEFAULT_COLLATION_NAME,
      maximumDatabaseSizeInGB: common.Constants.SqlAzureConstants.WEB_1GB
    }, function (err, result) {
      if (err) {
      } else {;

Related projects