Database Setup

TinyCloud stores metadata and related state in a relational database. The node accepts SQLite, PostgreSQL, and MySQL connection strings.

Supported backends

Backend	Example
SQLite	`sqlite:./data/caps.db`
PostgreSQL	`postgres://user:pass@host:5432/dbname`
MySQL	`mysql://user:pass@host:3306/dbname`

SQLite is the default. It is the simplest option for development and single-node deployments.

[storage]
database = "sqlite:./data/caps.db"

TINYCLOUD_STORAGE__DATABASE="sqlite:./data/caps.db"

Use PostgreSQL for production deployments that need concurrency and operational tooling.

[storage]
database = "postgres://tinycloud:password@localhost:5432/tinycloud"

TINYCLOUD_STORAGE__DATABASE="postgres://tinycloud:password@localhost:5432/tinycloud"

MySQL is also supported if your infrastructure already uses it.

The node applies database migrations automatically on startup. There is no separate migration command.

If startup fails after a database change, check the node logs and confirm the connection string in tinycloud.toml or TINYCLOUD_STORAGE__DATABASE.