Databases

Flowise supports 3 database types:

  • SQLite

  • MySQL

  • PostgreSQL

SQLite will be the default database. These databases can be configured with following env variables:

SQLite

DATABASE_TYPE=sqlite
DATABASE_PATH=/root/.flowise #your preferred location

A database.sqlite file will be created and saved in the path specified by DATABASE_PATH. If not specified, the default store path will be in your home directory -> .flowise

MySQL

DATABASE_TYPE=mysql
DATABASE_PORT=3306
DATABASE_HOST=localhost
DATABASE_NAME=flowise
DATABASE_USER=user
DATABASE_PASSWORD=123

PostgreSQL

DATABASE_TYPE=postgres
DATABASE_PORT=5432
DATABASE_HOST=localhost
DATABASE_NAME=flowise
DATABASE_USER=user
DATABASE_PASSWORD=123

If none of the env variables is specified, SQLite will be the fallback database choice.

Synchronize in Production

Flowise uses Typeorm to configure database connection. By default, synchronize is set to true. This indicates if database schema should be auto created on every application launch.

However, we have to be careful with this option and don't use this in production - otherwise you can lose production data. This option is useful during debug and development.

To override the value, set the following env variable

OVERRIDE_DATABASE=false

Tutorial: How to use Flowise databases SQLite and MySQL/MariaDB

Last updated