Overview

DB Change Guard is a professional, enterprise-grade database change tracking and rollback system built with Laravel 12 and React 19. It provides real-time monitoring, automatic change detection, and intelligent rollback capabilities for mission-critical databases.

Key Benefits

Key Features

Core Functionality

Server Requirements

PHP Extensions Required

• PDO (MySQL/PostgreSQL)
• OpenSSL
• JSON
• Tokenizer
• XML
• Ctype
• Fileinfo
• Mbstring

Installation Guide

Step 1: Download & Extract

Step 2: Install Dependencies

Step 3: Environment Setup

Step 4: Database Configuration

Edit your .env file with your database credentials:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=db_change_guard
DB_USERNAME=your_username
DB_PASSWORD=your_password

Step 5: Database Setup

Default Users & Roles (Seeded)

When you run php artisan db:seed, DB Change Guard will automatically create a set of default users with predefined roles. This is handled by a database seeder similar to the following:

// Create Super Admin User
$superAdmin = User::updateOrCreate(
    ['email' => '[email protected]'],
    [
        'name' => 'System Administrator',
        'username' => 'admin',
        'first_name' => 'System',
        'last_name' => 'Administrator',
        'password' => Hash::make('password123'),
        'email_verified_at' => now(),
        'is_active' => true,
        'timezone' => 'UTC',
        'language' => 'en',
        'password_changed_at' => now(),
    ]
);
// Assign Super Admin role
$superAdminRole = Role::where('name', 'super_admin')->first();
if ($superAdminRole && !$superAdmin->hasRole('super_admin')) {
    $superAdmin->assignRole('super_admin');
}
// Create Demo Admin User
$admin = User::updateOrCreate(
    ['email' => '[email protected]'],
    [
        'name' => 'Demo Administrator',
        'username' => 'demo',
        'first_name' => 'Demo',
        'last_name' => 'Administrator',
        'password' => Hash::make('demo123'),
        'email_verified_at' => now(),
        'is_active' => true,
        'timezone' => 'UTC',
        'language' => 'en',
        'password_changed_at' => now(),
    ]
);
// Assign Admin role
$adminRole = Role::where('name', 'admin')->first();
if ($adminRole && !$admin->hasRole('admin')) {
    $admin->assignRole('admin');
}
// Create Demo Viewer User
$viewer = User::updateOrCreate(
    ['email' => '[email protected]'],
    [
        'name' => 'Demo Viewer',
        'username' => 'viewer',
        'first_name' => 'Demo',
        'last_name' => 'Viewer',
        'password' => Hash::make('viewer123'),
        'email_verified_at' => now(),
        'is_active' => true,
        'timezone' => 'UTC',
        'language' => 'en',
        'password_changed_at' => now(),
    ]
);
// Assign Viewer role
$viewerRole = Role::where('name', 'viewer')->first();
if ($viewerRole && !$viewer->hasRole('viewer')) {
    $viewer->assignRole('viewer');
}

Step 6: Build Assets

Step 7: Start Application