Sicura Logo

Configuring the Database Connection

Notice: All of the following config options can be set in /etc/sicura/sicura-console.yaml

There is no default database so you must define a PostgreSQL connection string in sicura-console.yaml using one of the following formats:

main.database: postgres://ip_address:port/database
user: user
password: password
main.database: "postgres://"
user: user
password: password
host: ip_address
port: port
database: database

You can specify additional general and PostgreSQL specific options using main.database.options.

Migrating from SQLite to PostgreSQL

To migrate a SQLite database to PostgreSQL, use the sicura-console migrate command.

Changing the Database Table Prefix

By default, the Sicura Console configures a table prefix for all database tables it manages. This allows admins the capability to run multiple Sicura Console instances using the same underlying database. For example, one could have tables with the names production, staging, and dev all within the same database.

The default prefix is production, but it can be changed. For example, this creates all database tables with dev_ in front of them.

main.database_table_prefix: dev


This article provides configuration options for the Sicura Console, including disabling remediation, changing cryptographic settings, and configuring SSL termination.

Read Article


This article explains how to configure the Sicura Console Collector, including pruning report data and enabling legacy versions.

Read Article


This article describes an experimental configuration option to improve simultaneous use of the console via request threading.

Read Article


This article provides information on the Sicura Console, including its plugins, configuration options, and instructions for setting up notification and authentication providers.

Read Article

Account Configuration

This article provides instructions on how to configure the administrator account for Sicura Console.

Read Article


This article provides instructions and information on configuring the database connection for the Sicura Console.

Read Article