README

A Laravel package for automatic database introspection, model discovery, constraint analysis, and Eloquent model generation. Scans your connected database, analyzes schema metadata, and generates robust Eloquent models — complete with relationships, indexes, PHPDoc, and constraints.

Table of Contents

• Features
• Requirements
• Dependencies
• Laravel 12 Compatibility
• Installation
• Configuration
• Usage
  • Basic Usage
  • Available Flags
  • Example Commands
• Generated Output
• Development
• Contributing
• Credits

Features

Requirements

• PHP ^8.2
• Laravel 10.x or 11.x
• Composer 2.x

Dependencies

The following locked versions are used in this package. All runtime dependencies carry an MIT license unless noted.

Runtime

Development

Laravel 12 Compatibility

This package supports both Laravel 11 and Laravel 12 from the same codebase. No breaking changes are required in your application — only the dependency constraints need updating.

What changed in Laravel 12 that affects this package

Schema::getTableListing() now returns schema-qualified names

In Laravel 12, Schema::getTableListing() returns table names prefixed with the schema name by default (e.g. main.users instead of users). If the package calls this method internally to discover tables, you must strip the schema prefix or pass schemaQualified: false:

// Laravel 11 behaviour (unqualified)
Schema::getTableListing();
// ['migrations', 'users', 'orders']

// Laravel 12 default (qualified)
Schema::getTableListing();
// ['main.migrations', 'main.users', 'main.orders']

// Laravel 12 — opt out of qualification to restore old behaviour
Schema::getTableListing(schemaQualified: false);
// ['migrations', 'users', 'orders']

Grammar and Blueprint constructor signatures changed

Laravel 12 requires a Connection instance to be passed to Illuminate\Database\Grammar and Illuminate\Database\Schema\Blueprint constructors. The old setConnection() method has been removed. If the package instantiates either class directly, update the call:

// Laravel 11
$grammar = new MySqlGrammar;
$grammar->setConnection($connection);

// Laravel 12+
$grammar = new MySqlGrammar($connection);

Carbon 2.x support removed

Laravel 12 drops Carbon 2. This package's lock file already uses Carbon 3.10.3, so no action is needed.

HasUuids now generates UUIDv7

The HasUuids trait switched from UUIDv4 to UUIDv7. This only matters if you rely on UUID ordering in generated models. No change is required for the generator itself.

Upgrading the package to support Laravel 12

1. Update composer.json constraints

{
    "require": {
        "php": "^8.2",
        "laravel/framework": "^11.0|^12.0"
    },
    "require-dev": {
        "orchestra/testbench": "^9.0|^10.0",
        "phpunit/phpunit": "^11.0|^12.0",
        "pestphp/pest": "^2.0|^3.0"
    }
}

2. Expand the CI matrix

Add Laravel 12 alongside Laravel 11 in your GitHub Actions workflow:

# .github/workflows/tests.yml
strategy:
  matrix:
    php: [8.2, 8.3, 8.4]
    laravel: ['11.*', '12.*']
    include:
      - laravel: '11.*'
        testbench: '9.*'
      - laravel: '12.*'
        testbench: '10.*'
    exclude:
      - php: 8.1
        laravel: '11.*'
      - php: 8.1
        laravel: '12.*'

3. Guard schema-qualified table names

If the package uses Schema::getTableListing(), add a version guard to normalise output across both framework versions:

use Illuminate\Support\Facades\Schema;

$tables = version_compare(app()->version(), '12.0.0', '>=')
    ? Schema::getTableListing(schemaQualified: false)
    : Schema::getTableListing();

4. Run the full test suite against both versions

# Test against Laravel 11
composer require laravel/framework:^11.0 orchestra/testbench:^9.0 --no-update
composer update && composer test

# Test against Laravel 12
composer require laravel/framework:^12.0 orchestra/testbench:^10.0 --no-update
composer update && composer test

Version support matrix

Laravel 11 security support ended March 12, 2026. Laravel 12 receives bug fixes until August 2026 and security fixes until February 2027.

Installation

Install via Composer:

composer require zuqongtech/laravel-db-introspection

For local development:

git clone https://github.com/zuqongtech/laravel-db-introspection.git
cd laravel-db-introspection
composer install

Configuration

Publish the configuration file:

php artisan vendor:publish \
  --provider="Zuqongtech\LaravelDbIntrospection\LaravelDbIntrospectionServiceProvider" \
  --tag=config

This creates config/zt-introspection.php:

return [
    'output_path'   => app_path('Models'),
    'namespace'     => 'App\\Models',
    'ignore_tables' => [],
];

Usage

Basic Usage

php artisan zt:generate-models

Available Flags

Model Generation

Table Selection & Filtering

Documentation & Metadata

Relationships

Constraint & Integrity Analysis

Example Commands

Generate models with PHPDoc and inverse relationships:

php artisan zt:generate-models --with-phpdoc --with-inverse

Generate models for specific tables only:

php artisan zt:generate-models --tables=users --tables=orders

Validate foreign keys and analyze constraints:

php artisan zt:generate-models --validate-fk --analyze-constraints

Run a full analysis with optimization recommendations:

php artisan zt:generate-models --analyze-constraints --show-recommendations

Preview what would be generated without writing files:

php artisan zt:generate-models --dry-run

Generated Output

Models are written to app/Models/ by default:

app/
└── Models/
    ├── User.php
    ├── Order.php
    └── Product.php

Each generated model includes:

• $table — explicit table binding
• $fillable — all column names
• $primaryKey — including composite key support
• Soft delete detection (SoftDeletes trait)
• Timestamp detection ($timestamps)
• Relationships from foreign keys
• Optional inverse relationships
• Optional PHPDoc property blocks
• Optional constraint annotations

Example generated model:

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Orders extends Model
{
    protected $table = 'orders';

    protected $fillable = [
        'id',
        'user_id',
        'product_id',
        'status',
        'created_at',
        'updated_at',
    ];

    public function user(): \Illuminate\Database\Eloquent\Relations\BelongsTo
    {
        return $this->belongsTo(User::class);
    }
}

Development

Clone and install dependencies:

git clone https://github.com/zuqongtech/laravel-db-introspection.git
cd laravel-db-introspection
composer install

Run the test suite:

composer test

Pull requests with tests and a clean commit history are welcome.

Contributing

Bug reports and feature requests can be submitted via GitHub Issues.

When submitting a pull request:

• Include tests for any new behaviour
• Keep commits focused and well-described
• Follow PSR-12 coding standards

Credits

Developed and maintained by Gideon Zozingao / Zuqongtech.

© 2025 Gideon Zozingao. Licensed under the MIT License.