• First things first, grab Composer from getcomposer.org.
• Then, let's create a new Laravel project:

  composer create-project --prefer-dist laravel/laravel your_project_name
  

• Now, hop into the project directory:

  cd your_project_name
  

• You'll need the pg PHP extension since Supabase uses PostgreSQL. Install it based on your OS guidelines.
• Also, grab the laravel/sanctum package for authentication, if you need it:

  composer require laravel/sanctum
  

• Run migrations for Sanctum:

  php artisan migrate
  

• Head over to supabase.io and sign up or log in.
• Create a new project and make sure to note down the database URL and the API key.

• Open up the .env file in your Laravel project.
• Set the necessary database configuration using your Supabase credentials:

  DB_CONNECTION=pgsql
  DB_HOST=[your_supabase_host]
  DB_PORT=5432
  DB_DATABASE=[your_database_name]
  DB_USERNAME=[your_database_user]
  DB_PASSWORD=[your_database_password]
  

• Open config/database.php and make sure the pgsql configuration is correct:

  'pgsql' => [
    'driver'   => 'pgsql',
    'host'     => env('DB_HOST', '127.0.0.1'),
    'port'     => env('DB_PORT', '5432'),
    'database' => env('DB_DATABASE', 'forge'),
    'username' => env('DB_USERNAME', 'forge'),
    'password' => env('DB_PASSWORD', ''),
    'charset'  => 'utf8',
    'prefix'   => '',
    'schema'   => 'public',
    'sslmode'  => 'prefer',
  ],
  

• Once your environment is all set up, you can run your migrations to create the necessary tables:

  php artisan migrate
  

• Install the Supabase PHP client or use Guzzle (HTTP client) to make API calls:

  composer require guzzlehttp/guzzle
  

• Create a new service class or use a controller to interact with Supabase:
  ```
  use GuzzleHttp\Client;

class SupabaseService
{
protected $client;
protected $supabaseUrl;
protected $supabaseKey;

public function __construct()
{
    $this->client = new Client();
    $this->supabaseUrl = config('services.supabase.url');
    $this->supabaseKey = config('services.supabase.key');
}

public function fetchFromSupabase($endpoint)
{
    $response = $this->client->request('GET', "{$this->supabaseUrl}/rest/v1/{$endpoint}", [
        'headers' => [
            'apikey' => $this->supabaseKey,
            'Authorization' => "Bearer {$this->supabaseKey}"
        ]
    ]);

    return json_decode($response->getBody()->getContents(), true);
}

}

- Update the `config/services.php` to add Supabase configurations:

'supabase' => [
'url' => env('SUPABASE_URL'),
'key' => env('SUPABASE_KEY'),
],

<div style="color:#0065ff"><h3>Step 9: Use SupabaseService in Controller</h3></div>

- Inject the `SupabaseService` into your controller:

class UserController extends Controller
{
protected $supabaseService;

public function __construct(SupabaseService $supabaseService)
{
    $this->supabaseService = $supabaseService;
}

public function index()
{
    $data = $this->supabaseService->fetchFromSupabase('users');
    return view('users.index', compact('data'));
}

}

- Now, access `UserController@index` to fetch data from Supabase and render it in your view.

By following these steps, Supabase can be effectively used with a Laravel project to leverage its PostgreSQL database and other features.