Databases
Learn how to connect your Flowise instance to a database
Flowise supports 4 database types:
SQLite
MySQL
PostgreSQL
MariaDB
SQLite (Default)
SQLite will be the default database. These databases can be configured with following env variables:
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
Note: If none of the env variables is specified, SQLite will be the fallback database choice.
MySQL
PostgreSQL
MariaDB
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
How to use Flowise databases SQLite and MySQL/MariaDB
Last updated