Flowise + PostgreSQL (PG Vector)

This repository contains a Docker Compose file ready to run Flowise (the latest version) and a Postgres databse with vector plugin images. This repository was created for testing and studies purposes, but could be a good starting point for our Flowise projects.

How to start

Just run:

    docker compose up --build

and wait until everything is started. Flowise will be available at http://localhost:3000 and the Postgres database at port 5432.

Tips to connect Flowise to Postgres

• When you create a new document store in Flowise, use the following parameters:

  • Host: host.docker.internal
  • Port: 5432
  • Database: vector_db
  • User: postgres
  • Password: password

• You can connect to the Postgres database using any Postgres client with the same parameters above.

• To upsert data into the database use postgres for vector store AND as record manager. Sometimes using different record manager like SQLite can causes issues.

• You don't need to create the database and tables manually, Flowise will do that for you when you upsert data for the first time. But if you would like to check the database structure, you need to see a table like this:

CREATE TABLE public.documents (
	id uuid DEFAULT gen_random_uuid() NOT NULL,
	"pageContent" text NULL,
	metadata jsonb NULL,
	embedding public.vector NULL,
	CONSTRAINT documents_pkey PRIMARY KEY (id)
);