Edit Page

Available Database Adapters

This file is meant to be an up to date, comprehensive list of all of the core adapters available for the Sails.js framework, and a reference of a few of the community adapters out there. If you see out of date information on this page, or if you want to add an adapter you made, please just submit a pull request to this file, adding to the list of community adapters below.

Officially supported database adapters

sails-disk

https://github.com/balderdashy/sails-disk/

Write to your computer's hard disk, or a mounted network drive. Not suitable for at-scale production deployments, but great for a small project, and essential for developing in environments where you may not always have a database set up. This adapter is bundled with Sails and works out of the box with zero configuration.

Interfaces implemented:
  • Semantic
  • Queryable
  • Streaming
sails-memory

https://github.com/balderdashy/sails-memory/

Pretty much like Disk, but doesn't actually write to disk, so it's not persistent. Not suitable for at-scale production deployments, but useful when developing on systems with little or no disk space.

Interfaces implemented:
  • Semantic
  • Queryable
  • Streaming
sails-mysql

https://github.com/balderdashy/sails-mysql/tree/0.12.x

MySQL is the world's most popular relational database. http://en.wikipedia.org/wiki/MySQL

Interfaces implemented:
  • Semantic
  • Queryable
  • Streaming
  • Migratable
sails-postgres

https://github.com/balderdashy/sails-postgresql/tree/for-sails-0.12

PostgreSQL is another popular relational database.

Interfaces implemented:
  • Semantic
  • Queryable
  • Streaming
  • Migratable
sails-mongo

https://github.com/balderdashy/sails-mongo/tree/0.12.x

MongoDB is the leading NoSQL database.

Interfaces implemented:
  • Semantic
  • Queryable
  • Streaming
sails-redis

https://github.com/balderdashy/sails-redis/

Redis is an open source, BSD licensed, advanced key-value store.

Interfaces implemented:
  • Semantic
  • Queryable

Can I contribute to a core adapter?

Definitely! Get started by reading the Sails project contribution guide.

Community supported database adapters

Is your database not supported by one of the core adapters? Good news! There are many different community database adapters for Sails.js and Waterline available on NPM.

Learn how to install and configure community adapters.

Here are a few highlights:

sails-orientdb

https://github.com/appscot/sails-orientdb

OrientDB is an Open Source NoSQL DBMS with the features of both Document and Graph DBMSs.

Interfaces implemented:
  • Semantic
  • Queryable
  • Associations
  • Migratable
sails-filemaker

https://github.com/geistinteractive/sails-filemaker

FileMaker, is cross platform relational database and development platform. It has been owned and published by Apple since 1988.

Interfaces implemented:
  • Semantic
sails-derby

https://github.com/dash-/node-sails-derby

Apache Derby is an open source relational database implemented entirely in Java and available under the Apache License, Version 2.0.

Interfaces implemented:
  • Semantic
  • Queryable
  • Associations
  • SQL

Add your custom adapter to this list

Have you written a Sails adapter? Submit a PR to this file and add it here!

Is something missing?

If you notice something we've missed or could be improved on, please follow this link and submit a pull request to the sails-docs repo. Once we merge it, the changes will be reflected on the website the next time it is deployed.

Sails logo
  • Home
  • Get started
  • Support
  • Documentation
  • Documentation

For a better experience on sailsjs.com, update your browser.

Documentation

Reference Concepts App structure | Upgrading Contribution guide | Tutorials More

Concepts

  • Assets
    • Default Tasks
    • Disabling Grunt
    • Task Automation
  • Blueprints
    • Blueprint Actions
    • Blueprint Routes
  • Configuration
    • The local.js file
    • Using `.sailsrc` Files
  • Controllers
    • Generating Controllers
    • Routing to Controllers
  • Custom Responses
    • Adding a Custom Response
    • Default Responses
  • Deployment
    • FAQ
    • Hosting
    • Scaling
  • Extending Sails
    • Adapters
      • Available Adapters
      • Custom Adapters
    • Generators
      • Available Generators
      • Custom Generators
    • Hooks
      • Hook Specification
        • .configure()
        • .defaults
        • .initialize()
        • .routes
      • Installable Hooks
      • Project Hooks
      • Using Hooks
  • File Uploads
    • Uploading to GridFS
    • Uploading to S3
  • Globals
    • Disabling Globals
  • Internationalization
    • Locales
    • Translating Dynamic Content
  • Logging
    • Custom log messages
  • Middleware
    • Conventional Defaults
  • Models and ORM
    • Associations
      • Dominance
      • Many-to-Many
      • One Way Association
      • One-to-Many
      • One-to-One
      • Through Associations
    • Attributes
    • Lifecycle callbacks
    • Model Settings
    • Models
    • Query Language
    • Validations
  • Policies
    • Sails + Passport
  • Programmatic Usage
    • Tips and Tricks
  • Realtime
    • Multi-server environments
    • On the client
    • On the server
  • Routes
    • Custom Routes
    • URL Slugs
  • Security
    • Clickjacking
    • Content Security Policy
    • CORS
    • CSRF
    • DDOS
    • P3P
    • Socket Hijacking
    • Strict Transport Security
    • XSS
  • Services
    • Creating a Service
  • Sessions
  • Testing
  • Views
    • Layouts
    • Locals
    • Partials
    • View Engines

Built with Love

The Sails framework is maintained by a web & mobile studio in Austin, TX, with the help of our contributors. We created Sails in 2012 to assist us on Node.js projects. Naturally we open-sourced it. We hope it makes your life a little bit easier!

Sails:
  • What is Sails?
  • Treeline IDE
  • Contribute
  • Logos/artwork
About:
  • The Sails Company
  • Security
  • News
  • Legal
Help:
  • Get started
  • Documentation
  • Docs
  • Enterprise
  • Hire us

© 2012-2018 The Sails Company. 
The Sails framework is free and open-source under the MIT License.