Databases
Learn how to connect your Flowise instance to a database
Setup
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
How to use Flowise databases SQLite and MySQL/MariaDB
Backup
Shut down FlowiseAI application.
Ensure that the database connection to other applications is turned off.
Backup your database.
Test backup database.
SQLite
Rename file name.
Windows:
Linux:
Backup database.
Windows:
Linux:
Test backup database by running Flowise.
PostgreSQL
Backup database.
Enter database password.
Create test database.
Test the backup database by running Flowise with the
.env
file modified to point to the backup database.
MySQL & MariaDB
Backup database.
Enter database password.
Create test database.
Test the backup database by running Flowise with the
.env
file modified to point to the backup database.
Last updated