🚀 Node.js JWT Auth Backend with MSSQL

This is a professional, secure, and ready-to-use backend API for building powerful authentication systems. Built with Node.js, Express, and Sequelize ORM for MSSQL, this project offers a robust foundation for any web or mobile application requiring a reliable authentication layer.
The API is designed for ease of integration with any frontend framework, including React, Vue, Angular, and native mobile apps. It comes with a complete set of features to handle user accounts, secure authentication, and authorization.

✨ Key Features

• Secure User Authentication: Implements JSON Web Tokens (JWT) for stateless and secure authentication.
• Role-Based Authorization: Easily manage user access and permissions with a role-based system.
• Refresh Token Management: Ensures long-term user sessions without compromising security by handling access token expiration and renewal.
• Input Validation: All user inputs are thoroughly validated to prevent common attacks and ensure data integrity.
• Rate-Limiting: Protects against brute-force attacks on login endpoints.
• Sequelize ORM: Simplifies database interactions and provides a reliable way to manage your MSSQL database schema.
• API Endpoints: A full suite of well-documented endpoints for user registration, login, token refresh, and user data retrieval.
• Postman Collection: A ready-to-use Postman collection is included in the package, allowing you to test every endpoint immediately after setup.

🛠️ Technology Stack

• Backend: Node.js
• Framework: Express.js
• Database: MSSQL
• ORM: Sequelize
• Authentication: JWT (JSON Web Tokens)

This project is a perfect solution for developers looking to save time and launch their application with a professionally built and secure authentication backend. The clean code and comprehensive documentation make it simple to customize and expand.

Secure User Authentication: Implements JSON Web Tokens (JWT) for stateless and secure authentication.

Role-Based Authorization: Easily manage user access and permissions with a role-based system.

Refresh Token Management: Ensures long-term user sessions without compromising security by handling access token expiration and renewal.

Input Validation: All user inputs are thoroughly validated to prevent common attacks and ensure data integrity.

Rate-Limiting: Protects against brute-force attacks on login endpoints.

Sequelize ORM: Simplifies database interactions and provides a reliable way to manage your MSSQL database schema.

API Endpoints: A full suite of well-documented endpoints for user registration, login, token refresh, and user data retrieval.

Postman Collection: A ready-to-use Postman collection is included in the package, allowing you to test every endpoint immediately after setup.

A user needs to have the following software installed on their machine to use your item:

• Node.js & npm: The JavaScript runtime environment and its package manager.
• MSSQL Database Server: The database system where the application will store user data.

Installation Instructions

1. Download and Extract:
   • Download the provided ZIP file and extract its contents to a local folder.
2. Navigate to Project Directory:
   • Open your terminal or command prompt and navigate to the project folder.
3. Install Dependencies:
   • Install all required npm packages by running the command npm install.
4. Configure Environment:
   • Create a file named .env in the root directory of your project.
   • Copy the following configuration and fill in your database details:

     <code>
     # DATABASE SETTINGS
     DB_HOST=localhost
     DB_USER=sa
     DB_PASSWORD=your_strong_password
     DB_NAME=AuthPackDB
     
     # JWT SETTINGS
     JWT_SECRET=your_super_secret_jwt_key
     JWT_EXPIRES=15m
     JWT_REFRESH_SECRET=7d
     JWT_REFRESH_EXPIRES=7d
     </code>
     
     

5. Set Up the Database:
   • Crucial Step: You must first manually create a new, empty database in your MSSQL server with the name you specified in the .env file (e.g., AuthPackDB).
   • Then, run the command npx sequelize-cli db:migrate to create all the necessary tables using Sequelize migrations.
   • Optional: If you have seed files for default data (like roles or an admin user), run the command npx sequelize-cli db:seed:all.
6. Start the Server:
   • Run the command npm start to start the server.
   • The API will now be running at the specified URL (e.g., http://localhost:5000).
7. Test the API:
   • Import the included Postman collection to test all API endpoints and confirm they are working correctly.