Database Configuration

Main Database

Configure the main database in the [icp_server.storage] section of <ICP_HOME>/conf/deployment.toml.

Key	Description
dbType	Database engine — mysql, postgresql, mssql, or h2
host	Database server hostname (not used for H2)
port	Database server port (not used for H2)
name	Database/schema name
username	Database user
password	Database password

MySQL

[icp_server.storage]
dbType = "mysql"
host = "localhost"
port = 3306
name = "icp_db"
username = "<DB_USER>"
password = "<DB_PASSWORD>"

PostgreSQL

[icp_server.storage]
dbType = "postgresql"
host = "localhost"
port = 5432
name = "icp_db"
username = "<DB_USER>"
password = "<DB_PASSWORD>"

Microsoft SQL Server

[icp_server.storage]
dbType = "mssql"
host = "localhost"
port = 1433
name = "icp_db"
username = "<DB_USER>"
password = "<DB_PASSWORD>"

H2 (In-Memory)

[icp_server.storage]
dbType = "h2"

H2 is suitable for development and testing only.

---

Credentials Database

The default authentication backend stores user credentials in a separate database or schema. These are flat top-level keys in deployment.toml (not under any table header).

credentialsDbType = "postgresql"   # h2, postgresql, mysql, or mssql
credentialsDbHost = "localhost"
credentialsDbPort = 5432
credentialsDbName = "credentialsdb"
credentialsDbUser = "icp_user"
credentialsDbPassword = "icp_password"

Key	Type	Default	Description
credentialsDbType	string	"h2"	h2, postgresql, mysql, or mssql
credentialsDbHost	string	"localhost"	Not used for H2
credentialsDbPort	int	5432	Not used for H2
credentialsDbName	string	"credentialsdb"	Database/schema name
credentialsDbUser	string	"icp_user"	Database user
credentialsDbPassword	string	—	Database password

For PostgreSQL, credentials are stored in a credentials schema within the same database. For H2, they are stored in <ICP_HOME>/bin/database/credentials.