Managed Databases #

Hoist provides managed PostgreSQL databases for your apps.

Create a Database #

hoist db create --app my-app --name main

This creates:

• A new PostgreSQL database
• A dedicated user with limited permissions
• Automatic password generation

Connection String #

Get the connection string for your database:

hoist db url --app my-app --name main
# postgres://myapp_main:generated-pass@localhost:5432/myapp_main

Using in Your App #

Set the connection string as an environment variable:

hoist env set --app my-app DATABASE_URL=$(hoist db url --app my-app --name main)

Then use it in your code:

import { connect } from "hull"

const repo = connect({ url: process.env.DATABASE_URL })

Multiple Databases #

Apps can have multiple databases:

hoist db create --app my-app --name main
hoist db create --app my-app --name analytics
hoist db create --app my-app --name cache

Reset Password #

If you need to regenerate credentials:

hoist db reset-password --app my-app --name main

Database Info #

# List databases
hoist db list --app my-app

# Show database details
hoist db info --app my-app --name main

Backups #

Databases are backed up automatically. Manual backup:

hoist db backup --app my-app --name main

Delete Database #

hoist db delete --app my-app --name main

Warning: This permanently deletes all data.