An artisan command for opening the project's database in TablePlus

artisan_db_open.php

<?php

Artisan::command('db:open {connection?}', function ($connection = null) {
    if (! file_exists('/Applications/TablePlus.app')) {
        $this->warn('This command uses TablePlus, are you sure it\'s installed?');
        $this->line("Install here: https://tableplus.com/\n");
    }

    $driver = $connection ?: config('database.default');
    $host = config("database.connections.{$driver}.host");
    $user = config("database.connections.{$driver}.username");
    $password = config("database.connections.{$driver}.password");
    $database = config("database.connections.{$driver}.database");

    if ($driver === 'sqlite') {
        exec("open {$database}");
    } else {
        exec("open {$driver}://{$user}:{$password}@{$host}/{$database}");
    }
});

Does anyone know if any other options are supported? I.E. can I tell TP to use the "local" color scheme when it opens? I don't want to save a permanent connection, but it'd be cool to mimic some of the same features.

Apparently there are other features. I blogged about it here: Advanced TablePlus Command Line Usage

@jimbojsb how did you discover the query parameters you mentioned in your blog? I am wondering if there are similar ones to setup a connection over SSH?