Laravel Query

Laravel + DataGrip = ♥️

This plugin provides database integration for Laravel query builder.

Features

• Schemas, tables, views and columns completion for query builder methods
• Inspection of unknown database elements
• Table alias support
• Table name resolving from model for eloquent builder methods
• Model relation table name resolving for eloquent builder relation closure methods
• Text linking with database elements for navigation and refactoring

Prerequisites

Connect your database

See https://www.jetbrains.com/help/phpstorm/connecting-to-a-database.html#connect-to-mysql-database for instructions.

Laravel tools

You also need either Laravel Idea plugin (paid) or Laravel IDE helper added to your project and run

php artisan ide-helper:generate
php artisan ide-helper:meta
php artisan ide-helper:models
php artisan ide-helper:eloquent

which will generate some helper files so your IDE could see Eloquent methods.

Laravel Query plugin needs either of those to work otherwise, it cannot understand for which methods to trigger autocompletion.

Future plans

• Improve schema builder support to read current migration file as well instead of just table from database
• Add morph columns support for schema builder integration
• Improve sorting

Installation

• Using IDE built-in plugin system:

  Preferences > Plugins > Marketplace > Search for "Laravel Query" > Install Plugin

• Manually:

  Download the latest release and install it manually using Preferences > Plugins > ⚙️ > Install plugin from disk...

Plugin based on the IntelliJ Platform Plugin Template.