CINXE.COM

<!DOCTYPE html><html><head><meta http-equiv="content-type" content="text/html;charset=utf-8"> <title>Sequelize - Node.js ORM for Postgres, MySQL, SQLite</title><link rel="shortcut icon" type="image/x-icon" href="/v1/favicon.ico"><link rel="stylesheet" href="/v1/stylesheets/style.css"><script src="javascripts/jquery-1.10.2.min.js"></script><script>fromGithub = function (partialId, url) { var $partial = $("#" + partialId) $partial.load(url, function () { hljs.highlightBlock($partial.get(0)); }); }</script><meta name="robots" content="noindex"></head><body id="home"><div role="navigation" class="navbar navbar-default navbar-fixed-top"><div class="container-liquid"><div class="col-sm-3 navbar-left"><section><a class='navbar-brand' href='/v1/'><img src="images/logo-small.png"><span>Sequelize</span></a><div class="clearfix"></div></section></div><div class="col-sm-8 navbar-right"><section><button type="button" data-toggle="collapse" data-target=".navbar-collapse" class="navbar-toggle"><span class="sr-only">Toggle navigation</span><span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span></button><div class="navbar-collapse collapse"><ul class="nav navbar-nav"></ul><ul class="nav navbar-nav navbar-right"><li class="active"><a href='/v1/'><span class="glyphicon glyphicon-home"></span><span class="spacer"> </span><span class="text">Home</span></a></li><li><a href='/v1/docs/1.7.8/installation'><span class="glyphicon glyphicon-info-sign"></span><span class="spacer"> </span><span class="text">Docs</span></a></li><li><a href='/v1/articles/getting-started'><span class="glyphicon glyphicon-book"></span><span class="spacer"> </span><span class="text">Articles</span></a></li><li><a href='/v1/blog'><span class="glyphicon glyphicon-comment"></span><span class="spacer"> </span><span class="text">Blog</span></a></li><li><a class='search' href='/v1/search'><i class="fa fa-search"></i><span class="spacer"> </span><span class="text">Search</span></a></li></ul></div></section></div></div></div><section class="beige full-height"><div class="container full-height"><div class="jumbotron full-height"><div class="row full-height"><table class="full-height"><tbody><tr><td class="col-md-4 full-height"><img src="images/logo.png" width="100%"></td><td class="col-md-8 full-height"><h1>Sequelize</h1><p style="margin: 1em 0">The Sequelize library provides easy access to MySQL, MariaDB, SQLite or PostgreSQL databases by mapping database entries to objects and vice versa. To put it in a nutshell, it's an ORM (Object-Relational-Mapper). The library is written entirely in JavaScript and can be used in the Node.JS environment.</p><p class="shortcuts"><a class='btn btn-primary' href='/v1/articles/getting-started' role='button'>Getting started</a><a class='btn btn-default' href='/v1/articles/express' role='button' style='margin-left: 10px'>Use with Express</a><a class='btn btn-default' href='/v1/articles/heroku' role='button' style='margin-left: 10px'>Use on Heroku</a><a href="http://sequelize.readthedocs.org/" role="button" style="margin-left: 10px" class="btn btn-default">API Reference</a><a href="https://github.com/sequelize/sequelize" role="button" style="margin-left: 10px" target="_blank" rel="nofollow" class="btn btn-info">Fork on Github</a></p></td></tr></tbody></table></div></div></div></section><section class="light-blue"><div class="container"><div class="jumbotron"><h2 class="centered">Easy installation</h2><pre class="dark-blue"><code class="bash">$ npm install sequelize $ npm install mysql</code></pre><h2 class="centered">Simple usage</h2><pre class="dark-blue"><code class="javascript">var Sequelize = require('sequelize') , sequelize = new Sequelize('database', 'username', 'password')   var User = sequelize.define('User', { username: Sequelize.STRING, birthday: Sequelize.DATE })   sequelize.sync().success(function() { User.create({ username: 'sdepold', birthday: new Date(1986, 06, 28) }).success(function(sdepold) { console.log(sdepold.values) }) })</code></pre></div></div></section><section class="dark-blue users"><div class="container"><div class="jumbotron"><h2 class="centered">Trusted and used by</h2><div class="row"><div class="col-md-4"><a href='/v1/docs/latest/misc#shutterstock'><img src="images/users/shutterstock.png"></a></div><div class="col-md-4"><a href='/v1/docs/latest/misc#clevertech'><img src="images/users/clevertech.png"></a></div><div class="col-md-4"><a href='/v1/docs/latest/misc#metamarkets'><img src="images/users/metamarkets.png"></a></div></div><div class="row"><div style="text-align: center" class="col-md-4"><a href='/v1/docs/latest/misc#filsh' style='display: inline-block'><img src="images/users/filsh.png"></a></div></div></div></div></section><div class="imprint very-dark-blue"><div class="container"><div class="col-sm-4">漏 Sascha Depold, <a href="https://github.com/sequelize/sequelize-doc/graphs/contributors" target="_blank" rel="nofollow">et al.</a> 2006 - 2022</div><div style="text-align: right" class="col-sm-8"><a href='/v1/imprint'>Imprint</a></div></div></div><script src="javascripts/bootstrap.min.js"></script><script src="javascripts/highlight.pack.js"></script><script src="javascripts/main.js"></script><script type="text/javascript">(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','http://www.google-analytics.com/analytics.js','ga'); ga('create', 'UA-9039631-4', 'sequelizejs.com'); ga('send', 'pageview');</script> </body></html>