Need help with mean-stack-relational?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

430 Stars 177 Forks MIT License 129 Commits 0 Opened issues


M*EAN (*MySQL, Express, Angular, Node) - A Simple, Scalable and Easy starting point for javascript web development with a relational database ORM

Services available


Need anything else?

Contributors list

# 231,775
47 commits
# 47,999
33 commits
# 367,322
10 commits
# 15,737
3 commits
# 488,350
2 commits
# 467,571
1 commit
# 208,437
1 commit
# 572,233
1 commit

MEAN Stack Relational Mean Stack Build Status

Please use for reference only! No support or updates planned.

The main idea for this repository is shamelessly stolen from It says:

MEAN is a boilerplate that provides a nice starting point for [MySQL], Express, Node.js, and AngularJS based applications. It is designed to give you quick and organized way to start developing of MEAN based web apps with useful modules like sequelize and passport pre-bundled and configured. We mainly try to take care of the connection points between existing popular frameworks and solve common integration problems.

The MongoDB ORM, Mongoose, has been replaced with Sequelize. Switching from mongoose to sequelize allows developers easy access to MySQL, MariaDB, SQLite or PostgreSQL databases by mapping database entries to objects and vice versa.

Addy Osmani's Blog explains SQL databases, being strongly typed in nature are great at enforcing a level of consistency, ensuring many kinds of bad data simply don’t get recorded. By using SQL databases MEAN Stack Relational favors reliability over the performance gains of NoSQL databases.


Deploy to your Heroku account for a demo:


Note: Deploy from main repository view to avoid missing app.json error.

Getting Started

Alright now the fun begins. First clone or download the repo to your computer.

  1. Clone the repository
    git clone [email protected]:jpotts18/mean-stack-relational.git
  2. Go into the repository
    cd mean-stack-relational/
  3. Install dependencies with NPM
    npm install
    . This will copy development.json5, and production.json5 from respective sample files in the config/env folder and run the grunt copy task to copy frontend lib files to their destination.
  4. Plug in your private and public keys for working with FB and Twitter into
  5. Wire up the database connection found in
  6. Run in production mode with:
    pm2 start pm2-ecosystem.json --env production
    sudo npm install -g pm2
    if it's not installed.), or
  7. Run in development mode with grunt:
  8. Make something awesome!

Thats all! Now go and open up your browser at http://localhost:3000, and tweet @jpotts18 to say thanks!


  • Node.js - Download and Install Node.js. You can also follow this gist for a quick and easy way to install Node.js and npm
  • MySQL - Download and Install MySQL - Make sure it's running on the default port (3306).

Tool Prerequisites

  • NPM - Node.js package manager, should be installed when you install node.js. NPM (Node Package Manager) will look at the package.json file in the root of the project and download all of the necessary dependencies and put them in a folder called

  • Bower - Web package manager, installing Bower is simple when you have npm:

    npm install -g bower

NPM Modules Used

  • Passport - Passport is authentication middleware for Node.js. Extremely flexible and modular, Passport can be unobtrusively dropped in to any Express-based web application. A comprehensive set of strategies support authentication using a username and password, Facebook, Twitter, and more.
  • Express - Express is a minimal and flexible node.js web application framework, providing a robust set of features for building single and multi-page, and hybrid web applications.
  • Sequelize - 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.

Javascript Tools Used

  • Grunt - In one word: automation. The less work you have to do when performing repetitive tasks like minification, compilation, unit testing, linting, etc, the easier your job becomes. After you've configured it, a Grunt can do most of that mundane work for you—and your team—with basically zero effort.
  1. It watches your filesystem and when it detects a change it will livereload your changes.

  2. It runs jshint which looks through your javascript files and ensures coding standards.

  3. It runs nodemon which watches changes in specific folders and recompiles the app when necessary. No running

    node app.js
    every 2 minutes.
  4. It can also run tests like mocha and karma for you.

  • Bower - Bower is a package manager for the web. It offers a generic, unopinionated solution to the problem of front-end package management, while exposing the package dependency model via an API that can be consumed by a more opinionated build stack. There are no system wide dependencies, no dependencies are shared between different apps, and the dependency tree is flat.

Front-End Tools Used

  • Angular.js - AngularJS is an open-source JavaScript framework, maintained by Google, that assists with running single-page applications. Its goal is to augment browser-based applications with model–view–controller (MVC) capability, in an effort to make both development and testing easier.
  • Twitter Bootstrap - Sleek, intuitive, and powerful mobile first front-end framework for faster and easier web development.
  • UI Bootstrap - Bootstrap components written in pure AngularJS by the AngularUI Team

Project Roadmap

Following is a list of items detailing future direction for MEAN Stack Relational:


  • Demonstrate several login strategies using passport.js
  • Demonstrate environment configuration best practices
  • Demonstrate how to use Sequelize to query a single table and to accomplish a join.


  • Demonstrate testing for Express routes and javascript classes using Mocha, Sinon, Proxyquire and more
  • Demonstrating modularity by using javascript classes for complex backend functionality
  • Yeoman generator to compete with MEAN

Troubleshooting and Contact

During install some of you may encounter some issues feel free to contact me (jpotts18) or the co-contributor (chaudhryjunaid), via the repository issue tracker or the links provided below. I am also available on twitter at @jpotts18 and Junaid at @chjunaidanwar.

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.