🔍 Laravel DB Visualizer

A powerful Laravel package to analyze your application models, relationships, database usage, and detect performance issues like N+1 queries, unused columns, and missing eager loading.

---

🚀 Features

• 📊 Scan all Eloquent Models (App + Modules support)
• 🔗 Auto-detect relationships
• 🧠 Detect N+1 query risks probability
• ❌ Find unused columns
• ⚡ Detect missing eager loading
• 📈 Performance scoring system (0–100)
• 🧹 Code usage analysis
• 🧩 Supports Laravel Modules (nwidart style)

---

📦 Installation

Install via Composer:

composer require naimul/db-visualizer

---

⚙️ Auto Service Provider

If you are using Laravel 10+, the package will auto-register.

If not, add manually:

Naimul\DbVisualizer\DbVisualizerServiceProvider::class,

---

🌐 Routes

After installation, visit:

/dbv
/dbv/data
/dbv/detail/{model}

Example:

http://your-app.test/dbv/data

---

📊 API Endpoints

Get all models analysis

GET /dbv/data

Search models

GET /dbv/data?search=User

Model details

GET /dbv/detail/User

---

🧠 What It Analyzes

✔ Models

• Table name
• Columns
• Relations
• Soft deletes

✔ Relations

• Used / unused detection
• N+1 query detection probability
• Missing eager loading

✔ Columns

• Used / unused detection

✔ Performance Score

• Calculates score (0–100)

• Quality labels:

  • Excellent
  • Good
  • Average
  • Poor

---

📈 Example Response

{
  "model": "User",
  "table": "users",
  "performance_score": 85,
  "quality_label": "Good Quality",
  "unused_columns_count": 2,
  "n_plus_one_issues": 1,
  "relations": [
    {
      "method": "posts",
      "type": "HasMany",
      "used": true,
      "n_plus_one": false
    }
  ]
}

---

⚡ Performance Scoring Rules

Issue	Penalty
Unused relation	-10
Unused column	-2
N+1 issue	-15
Missing eager load	-10

Bonus:

• Soft deletes: +5
• Cache usage: +5
• API Resource usage: +5

---

🛠 Requirements

• PHP >= 8.1
• Laravel 10, 11, 12, 13 supported

---

📁 Supported Structure

• app/Models
• Modules/*/Entities
• Modules/*/Models
• Blade Views scanning

---

🔥 Use Case

This package is useful for:

• Optimizing large Laravel applications
• Detecting hidden performance issues
• Code quality auditing
• Refactoring legacy systems
• Interview/demo projects

---

🧩 Future Plans

• N+1 Query file locate
• eagerloading File locate
• Performance booster

---

🤝 Contributing

Pull requests are welcome. For major changes, please open an issue first.

---

📜 License

MIT License © Open Source

---

⭐ Support

If you like this package, give it a ⭐ on GitHub.