jQuery DataTables API for Laravel 4|5

v7.9.5 2017-07-21 00:47 UTC


Join the chat at https://gitter.im/yajra/laravel-datatables Donate Donate

Laravel 4.2|5.x Latest Stable Version Build Status Scrutinizer Code Quality Total Downloads License

This package is created to handle server-side works of DataTables jQuery Plugin via AJAX option by using Eloquent ORM, Fluent Query Builder or Collection.

use Yajra\Datatables\Facades\Datatables;

// Using Eloquent
return Datatables::eloquent(User::query())->make(true);

// Using Query Builder
return Datatables::queryBuilder(DB::table('users'))->make(true);

// Using Collection or Array
return Datatables::collection(User::all())->make(true);
return Datatables::collection([
    ['id' => 1, 'name' => 'Foo'],
    ['id' => 2, 'name' => 'Bar'],

// Using the Engine Factory
return Datatables::of(User::query())->make(true);
return Datatables::of(DB::table('users'))->make(true);
return Datatables::of(User::all())->make(true);
return Datatables::of(DB::select('select * from users'))->make(true);



Laravel Version Compatibility

Laravel Package
4.2.x 3.x
5.0.x 6.x
5.1.x 6.x
5.2.x 6.x
5.3.x 6.x
5.4.x 7.x

Laravel 5.4 Upgrade Guide

There are breaking changes since Laravel 5.4 and Datatables v7.0. If you are upgrading from v6.x to v7.x, please see upgrade guide.

Quick Installation

$ composer require yajra/laravel-datatables-oracle:^7.5

Service Provider



Datatables facade is automatically registered as an alias for Yajra\Datatables\Facades\Datatables class.

Configuration and Assets

$ php artisan vendor:publish --provider="Yajra\Datatables\DatatablesServiceProvider"

And that's it! Start building out some awesome DataTables!

Debugging Mode

To enable debugging mode, just set APP_DEBUG=true and the package will include the queries and inputs used when processing the table.

IMPORTANT: Please make sure that APP_DEBUG is set to false when your app is on production.


Please avoid using php artisan serve when developing with the package. There are known bugs when using this where Laravel randomly returns a redirect and 401 (Unauthorized) if the route requires authentication and a 404 NotFoundHttpException on valid routes.

It is advise to use Homestead or Valet when working with the package.


Please see CONTRIBUTING for details.


If you discover any security related issues, please email aqangeles@gmail.com instead of using the issue tracker.



The MIT License (MIT). Please see License File for more information.

Buy me a coffee

Click here to lend your support to: Laravel Datatables and make a donation at pledgie.com !