{"library":"sails-mssql","type":"library","category":null,"description":"SQL Server adapter for Sails.js and Waterline ORM (v2.1.10, supporting Sails 1.x). Enables MSSQL database integration via Sails models, with raw SQL query support. Active maintenance with irregular releases. Key differentiator: native SQL Server support for the Sails ecosystem, leveraging tedious driver. Consider using a more modern driver like mssql directly for non-Sails projects.","language":"javascript","status":"active","version":"2.1.10","tags":["javascript","sails","sails-mssql","sails-sqlserver","sql server","sqlserver","microsoft","azure","adapter"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install sails-mssql","imports":["// In .sailsrc or config/datastores.js:\nmodule.exports.datastores = {\n  default: {\n    adapter: require('sails-mssql'),\n    url: 'mssql://username:password@host:port/database'\n  }\n};","// In Sails model file (api/models/User.js):\nmodule.exports = {\n  datastore: 'default',\n  attributes: { name: 'string' }\n};","// In custom Sails action or service:\nconst result = await sails.getDatastore().sendStatement({ text: 'SELECT * FROM users' });"]},{"cmd":"yarn add sails-mssql","imports":[]},{"cmd":"pnpm add sails-mssql","imports":[]}],"homepage":"https://github.com/intel/sails-mssql#readme","github":"git://github.com/intel/sails-mssql","docs":null,"changelog":null,"pypi":null,"npm":"sails-mssql","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}