Sign Up for Free

RunKit +

Try any Node.js package right in your browser

This is a playground to test code. It runs a full Node.js environment and already has all of npm’s 1,000,000+ packages pre-installed, including sails-sqlserver-adapter with all npm packages installed. Try it out:

var sailsSqlserverAdapter = require("sails-sqlserver-adapter")

This service is provided by RunKit and is not affiliated with npm, Inc or the package authors.

sails-sqlserver-adapter v2.1.0

a MsSql adapter for Waterline and Sails.js

Sails Sqlserver Adapter

Build Status

A Waterline adapter for working with the Microsoft SqlServer database.

This version works with Sails 1.x. All Waterline Adapter Interfaces and methods are implemented based on the postgres implementation.

This is largely a port of sails-postgresql


$ npm install sails-sqlserver-adapter


An example configuration below.

Check MsSql Driver Options and Tarn Pool Options for more details. The options are passed verbatim to downstream driver.

module.exports.datastores = {
    default: {
        adapter: 'sails-sqlserver-adapter',
        host: process.env.DB_HOST,
        port: process.env.DB_PORT,
        user: process.env.DB_USER,
        password: process.env.DB_PASS,
        database: process.env.DB_NAME,
        schemaName: 'dbo',  //note: schema specified in model takes precedence
        requestTimeout: 15000,
        options: {
            encrypt: false,
            appName: 'myapp'
        pool: {
            max: 25,
            min: 5,
            idleTimeoutMillis: 30000

Running Test

The repo is configured to run all the tests in Docker containers. The composition uses two container

  1. sql server 2017 container spec published by Microsoft
  2. A container for testing the package based on official Node 10 release

To run the tests in docker env

$ docker-compose up

The github repo is configure to run the tests in Travis-CI on code push. The status of the build can be seen at the top of the repo


If you have further questions or are having trouble, click here.


The Sails framework is free and open-source under the MIT License.

RunKit is a free, in-browser JavaScript dev environment for prototyping Node.js code, with every npm package installed. Sign up to share your code.
Sign Up for Free