Recs.
Updated
SpecsUpdate
Pros
Pro ORM that can be plugged into any database, or even custom web service
Sails.js uses Waterline ORM at its backend which means you can store your data in any datastore that you like; all you have to do is make a change to the Waterline adapter, this will allow you to store your data in MySQL/Redis or any other kind of database.
Pro MVC architecture
This could be a huge plus, if you prefer to build your apps using the Model View Controller architecture. Using Sails.js you'll find the task of separating the business logic from the user interface and keeping the interactions between them in a separate layer, extremely easy.
Cons
Con Pathologically bad performance
Sails is so slow that I've found people claiming that Node.js is worthless because of performance. See for example where Sails.js ranks in the benchmarks here:
https://www.techempower.com/benchmarks/#section=data-r14&hw=ph&test=plaintext
In the worst case Express.js is almost 300x faster than Sails.js. I know that Sails.js does more, but it comes at such a high cost that I consider it to be worthless. Better to build on a stronger foundation.