Skip to content

Databases

How to install and connect databases in Sproobo

Sproobo can install PostgreSQL and Redis directly on your servers. These run as services on the server you choose — no separate managed database infrastructure required.

Supported Databases

Available Services

  • PostgreSQL: Full PostgreSQL installation with a dedicated database, user, and generated password
  • Redis: Redis installation with password authentication enabled

Installing a Database

Database services are installed from the server detail page:

  1. 1

    Navigate to Your Server

    Go to "Servers", click on the server where you want to install the database.
  2. 2

    Open Services

    Find the "Services" section on the server page and click "Install service".
  3. 3

    Choose PostgreSQL or Redis

    Select the service type. Sproobo will connect to the server over SSH and run the installation automatically.
  4. 4

    Get the Connection Details

    Once installed, open the service to view the connection string and credentials. Copy the connection string to use in your application.

Connecting Your App

After installing a database, add its connection string as an environment variable in your site:

  1. 1

    Copy the Connection String

    From the service detail page, copy the connection string (e.g. postgresql://user:pass@host:5432/dbname).
  2. 2

    Add to Site Environment Variables

    Go to your site settings, open Environment Variables, and add:
    • Key: DATABASE_URL
    • Value: the connection string
  3. 3

    Redeploy

    Trigger a redeploy so your app picks up the new environment variable.
ℹ️

PostgreSQL and Redis run on the same server as your site. For production workloads that need isolation, consider installing the database on a dedicated server and connecting over the private network.

Next Steps