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:
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
Note: If none of the env variables is specified, SQLite will be the fallback database choice.
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
PGSSLMODE=require
MariaDB
DATABASE_TYPE="mariadb"
DATABASE_PORT="3306"
DATABASE_HOST="localhost"
DATABASE_NAME="flowise"
DATABASE_USER="flowise"
DATABASE_PASSWORD="mypassword"
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:
rename "DATABASE_PATH\database.sqlite" "DATABASE_PATH\BACKUP_FILE_NAME.sqlite"
Linux:
mv DATABASE_PATH/database.sqlite DATABASE_PATH/BACKUP_FILE_NAME.sqlite
Backup database.
Windows:
copy DATABASE_PATH\BACKUP_FILE_NAME.sqlite DATABASE_PATH\database.sqlite
Linux:
cp DATABASE_PATH/BACKUP_FILE_NAME.sqlite DATABASE_PATH/database.sqlite
Test backup database by running Flowise.
PostgreSQL
Backup database.
pg_dump -U USERNAME -h HOST -p PORT -d DATABASE_NAME -f /PATH/TO/BACKUP_FILE_NAME.sql
Enter database password.
Create test database.
psql -U USERNAME -h HOST -p PORT -d TEST_DATABASE_NAME -f /PATH/TO/BACKUP_FILE_NAME.sql
Test the backup database by running Flowise with the
.env
file modified to point to the backup database.
MySQL & MariaDB
Backup database.
mysqldump -u USERNAME -p DATABASE_NAME > BACKUP_FILE_NAME.sql
Enter database password.
Create test database.
mysql -u USERNAME -p TEST_DATABASE_NAME < BACKUP_FILE_NAME.sql
Test the backup database by running Flowise with the
.env
file modified to point to the backup database.
Last updated