PHPackages                             daltonmccleery/remote-models - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. daltonmccleery/remote-models

ActiveLibrary[Database & ORM](/categories/database)

daltonmccleery/remote-models
============================

Sometimes you want to use Eloquent, but that data is in another database on a different application.

1.3.0(1y ago)34105[1 issues](https://github.com/DaltonMcCleery/remote-models/issues)[1 PRs](https://github.com/DaltonMcCleery/remote-models/pulls)MITPHPPHP ^8.1CI passing

Since Jul 9Pushed 1y ago1 watchersCompare

[ Source](https://github.com/DaltonMcCleery/remote-models)[ Packagist](https://packagist.org/packages/daltonmccleery/remote-models)[ GitHub Sponsors](https://github.com/daltonmccleery)[ RSS](/packages/daltonmccleery-remote-models/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (10)Dependencies (8)Versions (20)Used By (0)

Remote Models
=============

[](#remote-models)

Sometimes you want to use Eloquent, but that data is in another database on a different application.

This package is used for both the "host" application and the "remote" application. Both use cases are detailed below, or you can look at [these examples](EXAMPLES.md).

Requirements
------------

[](#requirements)

The [`pdo-sqlite` PHP extension](https://www.php.net/manual/en/ref.pdo-sqlite.php) must be installed on your system to use this package.

You will need to set up any endpoints on the host application where the data is stored.

Install
-------

[](#install)

```
composer require daltonmccleery/remote-models

```

### Publishing the Config

[](#publishing-the-config)

It is recommended to publish the config file; this will allow you to add a host domain, API pathing, and any Models.

```
php artisan vendor:publish --provider="RemoteModels\RemoteModelsServiceProvider" --force
```

Remote Use
----------

[](#remote-use)

Using this package consists of two steps:

1. Add the `RemoteModel` trait to a model.

That's it.

```
class Celebrity extends Model
{
    use \RemoteModels\RemoteModel;
}
```

Now, you can use this model anywhere you like, and it will behave as if the table exists in your application.

```
$celebrity = Celebrity::where('name', 'Dwayne Johnson')->first();
```

This will allow you to add a host domain, API pathing, and any Models.

### Custom Endpoint

[](#custom-endpoint)

You may provide a custom endpoint to your Remote Model that will be called when the model is loaded. If you do this and have this package installed on your host application, you will need to create your own API endpoint.

```
class Celebrity extends Model
{
    use \RemoteModels\RemoteModel;

    protected $remoteEndpoint = '/v1/celebrities';
}
```

### Custom Schema

[](#custom-schema)

Remote Models will auto-discover the schema from the first API call, however, if you want more control over the schema or what fields are saved locally, you may add them to a `$schema` property with a type cast for the column.

```
class Celebrity extends Model
{
    use \RemoteModels\RemoteModel;

    protected $remoteSchema = [
        'name' => 'string',
        'birthday' => 'datetime'
    ];
}
```

Host Use
--------

[](#host-use)

This package is dependent on a separate Laravel application that "hosts" the Models and their data. You will need to either install this package on the host application as well and enter the "remote" models you wish to expose to the "remote" application.

```
// config/remote-models.php
'host-models' => [
    \App\Models\Celebrity::class
]
```

### Custom Endpoint

[](#custom-endpoint-1)

If you use a custom endpoint on the remote application, you will need to set up that custom route. You can use the following as an example:

```
Route::post(
    config('remote-models.api-path') . '/v1/celebrities',
    fn (\RemoteModels\Http\Requests\CustomRemoteModelRequest $request) => $request->returnRemoteModels(Celebrity::class)
);
```

If you do **not** install this package on the "host" application, a custom endpoint will need to be set up for each Remote Model you plan on using. You will also need to manually validate the given API Key. You can use the following as an example:

```
Route::post('/api/_remote/_models/v1/celebrities', fn () => response()->json(Celebrity::paginate())));
```

You are not required to install this package on the "host" application. If you don't, you will need to set up your own API endpoints for the models you wish to use. It is recommended to use Laravel's default [pagination](https://laravel.com/docs/11.x/pagination#paginating-eloquent-results).

Cache Interval
--------------

[](#cache-interval)

You can set how long to cache the remote data for using the `cache-ttl` config option. These values follow the standard \[DateTime Interval\]( properties. Below are a few examples:

```
// config/remote-models.php
'cache-ttl' => '1m | 1w | 1d | 1h' // 1 month | 1 week | 1 day | 1 hour
```

External Host Data
------------------

[](#external-host-data)

There may be instances where you do not control the "host" application, i.e. it could be a Google Spreadsheet or a 3rd party API, but would still like a way to query that data using Eloquent.

You'll need to have your Model implement the `RemoteModelInterface` and include the base `RemoteModelManagement` trait. This will have you implement 2 methods for setting up a custom schema (optional) and recursively fetching the data. In this instance, the `$remoteEndpoint` is optional.

You can create your own Remote Model by following this example:

```
class Celebrity extends Model implements \RemoteModels\Interfaces\RemoteModelInterface
{
    use \RemoteModels\RemoteModelManagement;

    public function migrate(): void
    {
        $this->createRemoteModelTable(schemaCallback: function (array $schema) {

            // Make any modifications to the column schema before the sqlite table is created.

            return $schema;
        });

        $this->loadRemoteModelData();
    }

    public function loadRemoteModelData(int $page = 1): void
    {
        // Normal operation is a POST request with the config API key,
        // but you are free to modify the API call as you like.
        $response = \Illuminate\Support\Facades\Http::get($this->getRemoteModelEndpoint());

        $data = $response->json();

        // `insertRemoteModelData` is available and takes an array of data to be inserted.
        $this->insertRemoteModelData($data['data'], $data['per_page'] ?? 15);

        // Call the next page, if available.
        if ((int) $data['current_page'] < (int) $data['last_page']) {
            $this->loadRemoteModelData((int) $data['current_page'] + 1);
        }
    }
}
```

How It Works
------------

[](#how-it-works)

When a Model is called, it will make an API call to the either a custom endpoint or to a predefined endpoint using the Model's name. This predefined API endpoint can be configured in the config file.

Under the hood, this package creates and caches a SQLite database just for this model and all its data. It creates a table and populates it with the returned, paginated API data. If, for whatever reason, it can't cache a .sqlite file, it will default to using an in-memory sqlite database.

This package was *heavily* inspired by Caleb Porzio's [Sushi](https://github.com/calebporzio/sushi) package.

Upcoming Features
-----------------

[](#upcoming-features)

- Add command for pre-caching all Remote Models for deployment.
- Add local database fallback

###  Health Score

36

—

LowBetter than 81% of packages

Maintenance46

Moderate activity, may be stable

Popularity20

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity57

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~13 days

Recently: every ~54 days

Total

18

Last Release

438d ago

Major Versions

0.8.0 → 1.0.02024-07-11

### Community

Maintainers

![](https://www.gravatar.com/avatar/b682d4be7d11fda2bd8127feec1647e20147d20e87c960a6a1850af83d394b86?d=identicon)[dmccleery](/maintainers/dmccleery)

---

Top Contributors

[![DaltonMcCleery](https://avatars.githubusercontent.com/u/37309201?v=4)](https://github.com/DaltonMcCleery "DaltonMcCleery (57 commits)")

---

Tags

laravelpackagephpremoteremote-modelslaraveleloquentremote modelsremote api

###  Code Quality

TestsPest

Code StylePHP CS Fixer

### Embed Badge

![Health badge](/badges/daltonmccleery-remote-models/health.svg)

```
[![Health](https://phpackages.com/badges/daltonmccleery-remote-models/health.svg)](https://phpackages.com/packages/daltonmccleery-remote-models)
```

###  Alternatives

[cviebrock/eloquent-sluggable

Easy creation of slugs for your Eloquent models in Laravel

4.0k13.6M251](/packages/cviebrock-eloquent-sluggable)[tucker-eric/eloquentfilter

An Eloquent way to filter Eloquent Models

1.8k4.8M26](/packages/tucker-eric-eloquentfilter)[watson/validating

Eloquent model validating trait.

9723.3M46](/packages/watson-validating)[cybercog/laravel-ban

Laravel Ban simplify blocking and banning Eloquent models.

1.1k651.8k11](/packages/cybercog-laravel-ban)[cybercog/laravel-love

Make Laravel Eloquent models reactable with any type of emotions in a minutes!

1.2k302.7k1](/packages/cybercog-laravel-love)[cviebrock/eloquent-taggable

Easy ability to tag your Eloquent models in Laravel.

567694.8k3](/packages/cviebrock-eloquent-taggable)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)