Vilmantas8/react-nextjs-laravel-mysql-crud-agent

React-Next.js-Laravel-MySQL CRUD Agent

Full-Stack eCommerce Automation via Model Context Protocol (MCP)

An intelligent MCP server that orchestrates end-to-end development, testing, and deployment of React/Next.js + Laravel + MySQL applications to Hostinger.

🚀 Quick Start

# 1. Scaffold a new project
claude> scaffold_project { projectName: "my-store", packageManager: "pnpm" }

# 2. Generate CRUD for products
claude> generate_crud { 
  name: "product", 
  fields: [
    {name: "name", type: "string", required: true},
    {name: "price", type: "decimal", required: true},
    {name: "stock", type: "integer"}
  ]
}

# 3. Run migrations
claude> db_migrate { env: "local" }

# 4. Deploy to Hostinger
claude> deploy_hostinger_frontend { method: "ftp", host: "ftp.example.com", user: "...", path: "/public_html" }

Result: Production-ready eCommerce store in < 4 hours! 🎉

📋 Table of Contents

• Features
• Architecture
• Installation
• Usage Examples
• Documentation Hub
• MCP Tools
• Learning Path
• Contributing
• Project Status
• Support
• License

✨ Features

🎯 Core Capabilities

• Project Scaffolding: Generate complete monorepo with Next.js + Laravel + MySQL
• CRUD Generation: Full-stack CRUD (models, controllers, pages, forms, tests) from schema
• Intelligent Relations: One-to-many, many-to-many, polymorphic relationships
• Authentication: Laravel Sanctum with frontend flows (login, register, protected routes)
• Database Management: Migrations, seeders, backups via MySQL_MCP_Agent integration
• Testing Suite: PHPUnit (backend) + Jest/Vitest (frontend) + Playwright (E2E)
• One-Click Deploy: Automated deployment to Hostinger (FTP/SSH)
• Quality Gates: Linting, type checking, test coverage, security scans

🧠 Intelligent Features

• Schema Inference: Generate database schema from CSV/JSON samples
• Natural Language Spec: Convert plain English to CRUD code (spec_to_crud)
• Code Review: Static analysis with suggestions (critique_diff)
• Auto-Refactoring: Safe refactors with test preservation (refactor_module)
• Release Planning: Generate deployment plans with gates (plan_release)
• Performance Insights: Query optimization, index suggestions via MySQL_MCP_Agent

🏗️ Technology Stack

🏛️ Architecture

┌──────────────────────────────────────────────────────────┐
│                  Claude / LLM (MCP Client)               │
└────────────────────────┬─────────────────────────────────┘
                         │
            ┌────────────▼───────────────┐
            │   MCP Server (TypeScript)  │
            │   26 Tools:                │
            │   - scaffold_project       │
            │   - generate_crud          │
            │   - spec_to_crud           │
            │   - generate_relations     │
            │   - db_migrate             │
            │   - deploy_*               │
            │   - (20 more...)           │
            └────────────┬───────────────┘
                         │
        ┌────────────────┼────────────────┐
        │                │                │
        ▼                ▼                ▼
┌──────────────┐  ┌──────────────┐  ┌─────────────────┐
│   Next.js    │  │   Laravel    │  │MySQL_MCP_Agent  │
│  (Frontend)  │◄─┤   (API)      │◄─┤ (DB Operations)│
│              │  │              │  │                 │
│ - React 18   │  │ - PHP 8.3    │  │ - Schema valid. │
│ - App Router │  │ - Eloquent   │  │ - Migrations    │
│ - SWR        │  │ - Sanctum    │  │ - Performance   │
│ - Tailwind   │  │ - PHPUnit    │  │                 │
└──────────────┘  └──────┬───────┘  └─────────────────┘
                         │
                         ▼
                  ┌─────────────┐
                  │   MySQL 8   │
                  │  Database   │
                  └─────────────┘

Key Principles:

• ✅ API-First: Clear separation between frontend and backend
• ✅ Idempotent: All tools safe to re-run
• ✅ Type-Safe: TypeScript + PHP strict types
• ✅ Test-Driven: 80%+ backend, 70%+ frontend coverage
• ✅ Security by Default: RBAC, input validation, CORS, HTTPS

📖

📦 Installation

Prerequisites

• Node.js: 20.x or later
• PHP: 8.3 or later
• Composer: 2.x or later
• MySQL: 8.0 or later
• Claude Desktop: Latest version

Step 1: Clone Repository

git clone https://github.com/yourusername/react-nextjs-laravel-mysql-crud-agent.git
cd react-nextjs-laravel-mysql-crud-agent

Step 2: Install MCP Server

cd tools/mcp-server
npm install
npm run build

Step 3: Register with Claude Desktop

Edit your Claude Desktop config:

Windows: C:\Users\YourUser\AppData\Roaming\Claude\claude_desktop_config.json
macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Linux: ~/.config/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "react-nextjs-laravel-mysql-crud-agent": {
      "command": "node",
      "args": [
        "C:/path/to/react-nextjs-laravel-mysql-crud-agent/tools/mcp-server/dist/index.js"
      ],
      "env": {}
    },
    "MySQL_MCP_Agent": {
      "command": "node",
      "args": [
        "C:/path/to/MySQL_MCP_Agent/dist/index-fixed.js"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database"
      }
    }
  }
}

Step 4: Restart Claude Desktop

Close and reopen Claude Desktop. The MCP servers should now be available!

📖

🎮 Usage Examples

Example 1: Create eCommerce Store

User: Create a new eCommerce store called "TechShop" with products, categories, cart, and checkout.

Claude: I'll help you create TechShop! Let me start by scaffolding the project...

Claude will automatically:

1. ✅ Scaffold monorepo (Next.js + Laravel + MySQL)
2. ✅ Generate Product entity (model, controller, pages, tests)
3. ✅ Generate Category entity with many-to-many relation
4. ✅ Generate Cart and Order entities
5. ✅ Set up authentication (Sanctum)
6. ✅ Run migrations and seed demo data
7. ✅ Run tests (all passing)
8. ✅ Build frontend and backend
9. ✅ Deploy to Hostinger

Example 2: Add New Feature

User: Add a "Wishlist" feature where users can save products for later.

Claude: I'll add the Wishlist feature...

Claude will:

1. ✅ Generate Wishlist model with user relationship
2. ✅ Create migration (wishlists table, wishlist_items pivot)
3. ✅ Generate API endpoints (add, remove, list)
4. ✅ Generate frontend components (WishlistButton, WishlistPage)
5. ✅ Add tests (feature + unit + E2E)
6. ✅ Update documentation

Example 3: Infer Schema from Data

User: I have a CSV of products. Generate the database schema and import the data.

[User uploads products.csv]

Claude: Let me analyze the CSV and create the schema...

Claude will:

1. ✅ Parse CSV and infer field types
2. ✅ Generate migration with proper indexes
3. ✅ Create seeder to import CSV data
4. ✅ Run migration and seeder
5. ✅ Generate CRUD for the entity

📖

📚 Documentation Hub

🎯 Quick Navigation

I want to...

📖 Core Documentation

📂

🛠️ MCP Tools

Scaffolding & Generation (8 tools)

Database & Testing (6 tools)

Build & Deploy (8 tools)

Intelligence (4 tools)

Total: 26 Tools |

🎓 Learning Path

For First-Time Users

1. Start with to understand what the system does
2. Review to understand how it works
3. Follow to set up your development environment
4. Check when ready to deploy

For Junior Developers

Week 1: Understanding the System

1. Read - Focus on sections 1-5
2. Read - High-Level Architecture
3. Read - Development Setup

Week 2: Hands-On Development 4. Set up local environment 5. Pick a "good first issue" from GitHub 6. Read relevant section of ARCHITECTURE.md for the component 7. Write code following CONTRIBUTING.md standards

Week 3: Testing & Deployment 8. Read testing requirements 9. Write tests for your feature 10. Deploy to staging environment

For Senior Developers

Day 1: Quick Onboarding

1. Skim for product context
2. Deep dive
3. Review for team standards
4. Check for current state

Day 2+: Start Contributing 5. Pick a medium/large issue 6. Review related architecture sections 7. Implement following team standards 8. Write comprehensive tests

For DevOps Engineers

1. - Complete deployment procedures
2. - Infrastructure and deployment architecture

📖

🤝 Contributing

We welcome contributions! Please see our .

Quick Contribution Checklist

• Fork the repository
• Create a feature branch (git checkout -b feature/amazing-feature)
• Follow coding standards in
• Write tests (80%+ backend, 70%+ frontend coverage)
• Update documentation as needed
• Commit your changes (git commit -m 'feat: add amazing feature')
• Push to the branch (git push origin feature/amazing-feature)
• Open a Pull Request

Development Workflow

# 1. Set up environment
git clone <your-fork>
cd react-nextjs-laravel-mysql-crud-agent
npm install

# 2. Create feature branch
git checkout -b feature/my-feature

# 3. Make changes and test
npm run test
npm run lint

# 4. Commit and push
git add .
git commit -m "feat: add my feature"
git push origin feature/my-feature

# 5. Open PR on GitHub

Code of Conduct

This project follows the Contributor Covenant Code of Conduct.

📖

📊 Project Status

Current Sprint: Sprint 1 (Oct 9-15, 2025)
Current Phase: Phase 0 - Bootstrap & Foundation
Next Milestone: v0.1.0 - Foundation (Oct 23, 2025)

Development Roadmap

• Phase 0 (Weeks 1-2): Bootstrap & Foundation ⏳ In Progress
• Phase 1 (Weeks 3-6): Core CRUD Engine 📅 Planned
• Phase 2 (Weeks 7-9): Relations & Advanced DB 📅 Planned
• Phase 3 (Weeks 10-12): Authentication & Security 📅 Planned
• Phase 4 (Weeks 13-14): Testing & CI/CD 📅 Planned
• Phase 5 (Weeks 15-16): Deployment & Hosting 📅 Planned
• Phase 6 (Weeks 17-20): Marketplace Features 📅 Planned
• Phase 7 (Weeks 21-22): Polish & v1.0 Release 📅 Planned

📊
📈
📝

🔍 Common Questions

Q: How do I get started with development?
A: Read → Prerequisites → Development Setup → Development Workflow

Q: What features are planned?
A: See - All 7 phases with deliverables and timelines

Q: How do I deploy to Hostinger?
A: Follow → Shared Hosting Deployment

Q: What's the database schema?
A: Check → Database Schema section

Q: What are the coding standards?
A: → Coding Standards

Q: What's the current sprint status?
A: → Current Sprint section

📖

📞 Support

Documentation

• 📚 - Complete documentation index
• 📖 - API reference
• 🔒 - Security guidelines

Get Help

• GitHub Issues: Report a bug
• GitHub Discussions: Ask a question
• Discord: Join our community
• Email: support@example.com

Quick Actions

📜 License

This project is licensed under the MIT License - see the file for details.

🙏 Acknowledgments

• Model Context Protocol (MCP): Anthropic's protocol for LLM-tool integration
• Laravel: The PHP framework for web artisans
• Next.js: The React framework for production
• shadcn/ui: Beautifully designed accessible components
• Hostinger: Affordable and reliable hosting

🌟 Show Your Support

If this project helps you, please give it a ⭐️ on GitHub!

🚀 Ready to Build?

Choose your path:

• New to the project? → Start with
• Ready to code? → Jump to
• Ready to deploy? → Follow
• Need documentation? → Browse

Let's build something amazing! 🎨