Tzylo Docs

Database Setup

Configure and connect a database for Tzylo Auth CE.

Tzylo Auth CE requires a SQL database to store users, tokens, and authentication state.

Supported Databases

The following databases are officially supported:

  • PostgreSQL
  • MySQL
  • SQL Server
SQLite is not supported in this version. A valid DATABASE_URLis required at startup.

DATABASE_URL Format

Tzylo Auth CE uses a standard database connection string.

PostgreSQL
postgresql://username:password@host:5432/database
MySQL
mysql://username:password@host:3306/database
SQL Server
sqlserver://username:password@host:1433/database

Database Requirements

  • The database must already exist
  • The user must have read and write permissions
  • Network access must be allowed from the auth server

Migrations

Database schema migrations are handled internally by Tzylo Auth CE.

On startup, the server ensures that required tables exist before accepting requests.

You do not need to manually run migration commands.

Common Connection Issues

  • Incorrect username or password
  • Database server not running
  • Using localhost inside Docker
  • Firewall or network restrictions

Check server logs on startup for detailed error messages if the connection fails.