Create a Database

Provision a PostgreSQL database on your VPS in minutes using the ScallerFox agent.

Prerequisites

A subscribed database package
An Ubuntu/Debian VPS with outbound HTTPS access
Root or sudo access on the VPS

Subscribe to a Database Package

If you don't have a database subscription yet, go to Databases → Create Database. Select a package (Starter, Basic, or Pro).

Your subscription determines the maximum storage and number of databases you can create on a single agent.

Install the Agent on Your VPS

SSH into your VPS and run the installer command. The installer is provided in the database creation flow.

# SSH into your VPS
ssh root@your-vps-ip

# Run the ScallerFox agent installer (copy from dashboard)
curl -fsSL https://agents.scallerfox.com/agents/postgres/install | sh

The installer requires root privileges. It will install PostgreSQL, configure PgBouncer (connection pooling), and register the agent with the ScallerFox API.

Create Your First Database

Once the agent is installed and registered, go to Databases → Create Database. Enter a name for your database.

What happens next:

ScallerFox generates a username and password
Credentials are encrypted (AES-256-GCM) and stored
Agent creates the database on your VPS
Database appears as "Active" in the dashboard

Connect to Your Database

View the connection string from the database detail page. Use it in your application's environment variables.

postgresql://username:password@host:5432/databasename

Tip: Add the connection string as an environment variable in your ScallerFox application. Link the database to a Project for automatic connection injection.

Managing the Agent

Heartbeat

The agent sends a heartbeat to ScallerFox every 60 seconds. If the agent goes offline, your databases are marked accordingly in the dashboard.

Usage Reporting

The agent reports disk usage every 5 minutes. Usage history is visible in the dashboard.

Uninstalling

To remove the agent, SSH into your VPS and run the uninstall script provided in the agent detail page. This stops PostgreSQL and removes the agent — existing databases and data are preserved until manually deleted.