Agent First ORM, schema planning and migrations for PilotPHP.

Maintainers

Package info

github.com/simonproud/pilotphp-orm

pkg:composer/pilotphp/orm

Transparency log

Statistics

Installs: 2

Dependents: 0

Suggesters: 0

Stars: 0

Open Issues: 0

0.0.1 2026-07-07 13:05 UTC

This package is auto-updated.

Last update: 2026-07-07 14:27:55 UTC


README

PilotPHP ORM is an Agent First ORM, schema planning, PostgreSQL SQL generation and impact analysis package for PilotPHP.

Core rules:

  • Plans before code.
  • Diffs before migrations.
  • Impact before apply.
  • Readable manifests before magic.
  • Deterministic output before clever automation.

This package is standalone and optional. It has no runtime dependency on Laravel, Illuminate, Symfony ORM, Doctrine ORM or Cycle ORM.

Manifest Example

<?php

declare(strict_types=1);

use PilotPHP\Orm\Schema\EntitySchema;

return EntitySchema::make('User')
    ->module('User')
    ->table('users')
    ->field('uuid')->uuid()->primary()
    ->field('email')->string(255)->unique()
    ->field('name')->string(255)
    ->timestamps();

Planning Example

use PilotPHP\Orm\Plan\OrmPlanner;

$plan = (new OrmPlanner())->plan($schema, timestamp: '20260707120000');

echo $plan->toJson();

Plans are deterministic and do not write files or apply database changes. A plan includes:

  • normalized entity metadata;
  • planned model, repository and migration paths;
  • visible PostgreSQL SQL;
  • validation warnings;
  • impact risks.

Current MVP Limits

  • Plans only; no files are written.
  • PostgreSQL CREATE TABLE SQL only for schema manifests.
  • No real database execution in the planning pipeline.
  • No ActiveRecord.
  • No relations or lazy loading.
  • No PilotPHP framework integration yet.

Development

composer install
composer test
composer analyse
composer check