PHPackages                             jiaoyang3/laravel-clickhouse - 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. jiaoyang3/laravel-clickhouse

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

jiaoyang3/laravel-clickhouse
============================

Eloquent model for ClickHouse

2.1.1(5y ago)28MITPHPPHP >=7.2

Since Jul 9Pushed 5y agoCompare

[ Source](https://github.com/jiaoyang3/laravel-clickhouse)[ Packagist](https://packagist.org/packages/jiaoyang3/laravel-clickhouse)[ RSS](/packages/jiaoyang3-laravel-clickhouse/feed)WikiDiscussions master Synced yesterday

READMEChangelog (1)Dependencies (6)Versions (7)Used By (0)

Laravel Clickhouse
==================

[](#laravel-clickhouse)

[![Build Status](https://camo.githubusercontent.com/8e0e5725a7eb433724371740dee6a95a85284c3283158fc69eeb853158c9d936/68747470733a2f2f7472617669732d63692e6f72672f62617669782f6c61726176656c2d636c69636b686f7573652e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/bavix/laravel-clickhouse)[![StyleCI](https://camo.githubusercontent.com/be3da433e04798e55c0355a068104275079646cc980392e643cac897227e9f47/68747470733a2f2f7374796c6563692e696f2f7265706f732f3236393338343630342f736869656c643f6272616e63683d6d6173746572)](https://styleci.io/repos/269384604)[![Coverage Status](https://camo.githubusercontent.com/c96a68ff5c51deba1d2dcd36dd143e320100963f97ef2e3241164c0451303e8f/68747470733a2f2f636f766572616c6c732e696f2f7265706f732f6769746875622f62617669782f6c61726176656c2d636c69636b686f7573652f62616467652e737667)](https://coveralls.io/github/bavix/laravel-clickhouse)

[![Package Rank](https://camo.githubusercontent.com/d25d7b8fe8075f6a5d1dbfcd8a1b2eecbccef86d66d4cc5f2f21256145a6e881/68747470733a2f2f7068707061636b616765732e6f72672f702f62617669782f6c61726176656c2d636c69636b686f7573652f62616467652f72616e6b2e737667)](https://packagist.org/packages/bavix/laravel-clickhouse)[![Latest Stable Version](https://camo.githubusercontent.com/13c01a1bd825e0ae9af64318228f80716b9c8a1cbd55570d96e8fce1b181b598/68747470733a2f2f706f7365722e707567782e6f72672f62617669782f6c61726176656c2d636c69636b686f7573652f762f737461626c65)](https://packagist.org/packages/bavix/laravel-clickhouse)[![Latest Unstable Version](https://camo.githubusercontent.com/c1806d32eda58c5b80cf93d1d31a9270978aade405d8063a96fabfd73b6003df/68747470733a2f2f706f7365722e707567782e6f72672f62617669782f6c61726176656c2d636c69636b686f7573652f762f756e737461626c65)](https://packagist.org/packages/bavix/laravel-clickhouse)[![License](https://camo.githubusercontent.com/12ff77b2ad8825f6923ea55c64c690032649bc24882665a59a49529f23a203ae/68747470733a2f2f706f7365722e707567782e6f72672f62617669782f6c61726176656c2d636c69636b686f7573652f6c6963656e7365)](https://packagist.org/packages/bavix/laravel-clickhouse)[![composer.lock](https://camo.githubusercontent.com/71f9f26dc80941ed4743e1827dfc6f014d38585e720ed7d91316a909cffc43f5/68747470733a2f2f706f7365722e707567782e6f72672f62617669782f6c61726176656c2d636c69636b686f7573652f636f6d706f7365726c6f636b)](https://packagist.org/packages/bavix/laravel-clickhouse)

Laravel Clickhouse - Eloquent model for ClickHouse.

- **Vendor**: bavix
- **Package**: Laravel Clickhouse
- **Version**: [![Latest Stable Version](https://camo.githubusercontent.com/13c01a1bd825e0ae9af64318228f80716b9c8a1cbd55570d96e8fce1b181b598/68747470733a2f2f706f7365722e707567782e6f72672f62617669782f6c61726176656c2d636c69636b686f7573652f762f737461626c65)](https://packagist.org/packages/bavix/laravel-clickhouse)
- **Laravel Version**: `5.x`, `7.x`, `8.x`
- **PHP Version**: 7.2+
- **[Composer](https://getcomposer.org/):** `composer require bavix/laravel-clickhouse`

Get started
-----------

[](#get-started)

```
$ composer require jiaoyang3/laravel-clickhouse
```

Then add the code above into your config/app.php file providers section

```
Bavix\LaravelClickHouse\ClickHouseServiceProvider::class,
```

And add new connection into your config/database.php file. Something like this:

```
'connections' => [
    'bavix::clickhouse' => [
        'driver' => 'bavix::clickhouse',
        'host' => '',
        'port' => '',
        'database' => '',
        'username' => '',
        'password' => '',
        'options' => [
            'timeout' => 10,
            'protocol' => 'https'
        ]
    ]
]
```

Or like this, if clickhouse runs in cluster

```
'connections' => [
    'bavix::clickhouse' => [
        'driver' => 'bavix::clickhouse',
        'servers' => [
            [
                'host' => 'ch-00.domain.com',
                'port' => '',
                'database' => '',
                'username' => '',
                'password' => '',
                'options' => [
                    'timeout' => 10,
                    'protocol' => 'https'
                ]
            ],
            [
                'host' => 'ch-01.domain.com',
                'port' => '',
                'database' => '',
                'username' => '',
                'password' => '',
                'options' => [
                    'timeout' => 10,
                    'protocol' => 'https'
                ]
            ]
        ]
    ]
],
```

Then create model

```