> ## Documentation Index
> Fetch the complete documentation index at: https://herd.laravel.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Per-Site Services

# Per-Site Services

Herd Pro lets you choose which services a Laravel application uses right from the Applications window. Instead of looking up hosts, ports and credentials and editing your `.env` file by hand, you select a service from a dropdown and Herd updates the configuration for you.

## Switching services

Select a site in the [Applications window](/docs/windows/sites/managing-sites). The "Services" section of the inspector shows one dropdown for each of these categories:

| Category | Built-in options | Herd services |
| - | - | - |
| Database | SQLite | MySQL, MariaDB, PostgreSQL, MongoDB |
| Queue | Sync, Database | Redis |
| Cache | Array, Database, File | Redis |
| Broadcasting | Log, None | Laravel Reverb |

Each dropdown lists the built-in Laravel options, the matching [services](/docs/windows/herd-pro-services/services) that you already installed and services that you can install. When you select a service that isn't installed yet, Herd installs and starts it, and applies it to your application afterwards.

<Frame>
  <img alt="Selecting the database of a site" src="https://mintcdn.com/herd/QzPcZ9FhOMtk-vxD/images/docs/windows/per_site_services.png?fit=max&auto=format&n=QzPcZ9FhOMtk-vxD&q=85&s=898f6720225a1ef74ea1764fb07ae41b" width="2322" height="1481" data-path="images/docs/windows/per_site_services.png" />
</Frame>

When you switch to MySQL, MariaDB or PostgreSQL, Herd asks which database the application should use. You can pick an existing database or create a new one. To use a different database on the same server later, click "Change…" next to the database name.

<Note>
  Per-site services are available for Laravel applications with a `.env` file. For other applications, use the [services settings](/docs/windows/herd-pro-services/services) and configure the connection yourself.
</Note>

## What Herd changes in your `.env` file

Herd detects the current configuration from your `.env` file and only changes the keys of the category that you switch:

| Category | Keys |
| - | - |
| Database | `DB_CONNECTION`, `DB_HOST`, `DB_PORT`, `DB_USERNAME`, `DB_PASSWORD`, `DB_URI` |
| Queue | `QUEUE_CONNECTION` and `REDIS_*` |
| Cache | `CACHE_STORE`, `CACHE_DRIVER` and `REDIS_*` |
| Broadcasting | `BROADCAST_CONNECTION`, `BROADCAST_DRIVER` and `REVERB_*` |

Herd keeps your `DB_DATABASE` value when you switch database servers, unless you select or create a different database. When you switch to SQLite, Herd sets `DB_DATABASE` to `database/database.sqlite` and creates the file if it doesn't exist.

Before Herd changes a category for the first time, it saves the original values to a `.env.herd-services.bak` file next to your `.env` file. If the configuration of a category doesn't match any of the options, the dropdown shows "Not managed by Herd". To restore the values that Herd replaced, run `herd site:services` with the `unmanaged` option as shown below.

## Via the CLI

You can view and change the services of a site with the `herd site:services` command. Without arguments, it lists all categories with their current value and all options.

```powershell theme={null}
# Show all categories and options
herd site:services

# Use the installed Redis service for the queue
herd site:services queue redis

# Use SQLite as database
herd site:services database sqlite

# Restore the values that Herd replaced
herd site:services cache unmanaged
```

You can pass a built-in option like `sqlite`, `sync`, `database`, `array`, `file`, `log` or `null`, or the name, type or ID of an installed service.