Connecting to Databases

How it works

Clouderized databases run as separate containers on a private internal network — your app container can reach the database by hostname, but nothing outside your account can. Credentials are never stored in your repo. Instead, they are set as Gitea repo secrets and injected into your container as environment variables at deploy time.

Environment variables

These five variables are available in your app at runtime. The operator will give you the values for DB_HOST, DB_PORT, DB_NAME, and DB_USER. You choose DB_PASS.

Adding credentials in the portal

Go to your app in the portal → Env tab. Add each credential as a separate row — one variable per line, values masked by default. Click Save Changes to write them to app.env and sync the Gitea secret in one step. Then redeploy for the changes to take effect.

Code examples

import os
from sqlalchemy import create_engine

host = os.environ["DB_HOST"]
port = os.environ["DB_PORT"]
name = os.environ["DB_NAME"]
user = os.environ["DB_USER"]
password = os.environ["DB_PASS"]

engine = create_engine(
    f"mysql+pymysql://{user}:{password}@{host}:{port}/{name}"
)

import os
import psycopg2

conn = psycopg2.connect(
    host=os.environ["DB_HOST"],
    port=os.environ["DB_PORT"],
    dbname=os.environ["DB_NAME"],
    user=os.environ["DB_USER"],
    password=os.environ["DB_PASS"],
)

const mysql = require('mysql2/promise');

const pool = mysql.createPool({
  host:     process.env.DB_HOST,
  port:     process.env.DB_PORT,
  database: process.env.DB_NAME,
  user:     process.env.DB_USER,
  password: process.env.DB_PASS,
});

const { Pool } = require('pg');

const pool = new Pool({
  host:     process.env.DB_HOST,
  port:     process.env.DB_PORT,
  database: process.env.DB_NAME,
  user:     process.env.DB_USER,
  password: process.env.DB_PASS,
});

val host     = sys.env("DB_HOST")
val port     = sys.env("DB_PORT")
val name     = sys.env("DB_NAME")
val user     = sys.env("DB_USER")
val password = sys.env("DB_PASS")

val dbConfig = DatabaseConfig.forConfig[JdbcProfile]("mydb")
// or build the JDBC URL directly:
val jdbcUrl = s"jdbc:mysql://$host:$port/$name?useSSL=false"

mydb {
  driver = "slick.jdbc.MySQLProfile$"
  db {
    url      = "jdbc:mysql://"${DB_HOST}":"${DB_PORT}"/"${DB_NAME}"?useSSL=false"
    user     = ${DB_USER}
    password = ${DB_PASS}
    driver   = "com.mysql.cj.jdbc.Driver"
  }
}

require 'active_record'

ActiveRecord::Base.establish_connection(
  adapter:  'mysql2',
  host:     ENV['DB_HOST'],
  port:     ENV['DB_PORT'],
  database: ENV['DB_NAME'],
  username: ENV['DB_USER'],
  password: ENV['DB_PASS'],
)

import (
    "database/sql"
    "fmt"
    "os"

    _ "github.com/go-sql-driver/mysql"
)

dsn := fmt.Sprintf("%s:%s@tcp(%s:%s)/%s",
    os.Getenv("DB_USER"),
    os.Getenv("DB_PASS"),
    os.Getenv("DB_HOST"),
    os.Getenv("DB_PORT"),
    os.Getenv("DB_NAME"),
)
db, err := sql.Open("mysql", dsn)

import (
    "context"
    "fmt"
    "os"

    "github.com/jackc/pgx/v5"
)

connStr := fmt.Sprintf(
    "postgres://%s:%s@%s:%s/%s",
    os.Getenv("DB_USER"),
    os.Getenv("DB_PASS"),
    os.Getenv("DB_HOST"),
    os.Getenv("DB_PORT"),
    os.Getenv("DB_NAME"),
)
conn, err := pgx.Connect(context.Background(), connStr)

Local development

Your app reads the same env vars locally. Create a .env file (git-ignored) for local dev:

DB_HOST=localhost
DB_PORT=3306
DB_NAME=myapp_dev
DB_USER=root
DB_PASS=devpassword

On Clouderized, DB_HOST will be the container hostname on your private network — not localhost. Your app doesn't need to change; only the env var values differ between environments.

Resource planning

Databases run inside your resource pool — they consume the same CPU and RAM as your app containers. Plan your slot capacity to cover both workloads.