Database service mapping

FlowX.AI Database-Service Mapping

Source: extracted from /Users/caravasiledragos/core/flowx-core-services codebase analysis. Designer (/Users/caravasiledragos/designer-context) is pure frontend — no database connections.

---

PostgreSQL

PostgreSQL details

Service	Database	Operations	Schema management	Config file
Admin	flowxadmin	Creates, reads, writes	Liquibase migrations	application-datasource-sql.yml
Advancing Controller	advancing	Creates, reads, writes	Liquibase migrations	application-datasource-sql.yml
Application Manager	app_manager	Creates, reads, writes	Liquibase migrations	application-datasource-sql.yml
Authorization System	auth_system	Creates, reads, writes	Liquibase migrations	application-datasource-sql.yml
Document Plugin	document	Creates, reads, writes	Liquibase migrations	application-datasource-sql.yml
Email Gateway	email_gateway	Creates, reads, writes	Liquibase migrations	application-datasource-sql.yml
License	license	Creates, reads, writes	Liquibase migrations	application-datasource-sql.yml
Mock Server	flowx-mocks	Creates, reads, writes	Liquibase migrations	application-datasource-sql.yml
Organization Manager	org_manager	Creates, reads, writes	Liquibase migrations	application-datasource-sql.yml
Process Engine	process_engine	Creates, reads, writes	Liquibase migrations	application-datasource-sql.yml
Task Management	process_engine	Reads, writes	None (shared DB)	application-datasource-sql.yml
Data Sync	app_manager, auth_system, process_engine	Manages migrations	Liquibase coordinator	application-datasource-sql.yml

Shared database: process_engine is used by both Process Engine and Task Management Plugin.

---

MongoDB

MongoDB details

Service	Database	Operations	Key collections
Admin	data-model	Creates, reads, writes	properties_paths, entities_usages, local_data_entity, data_model_slices, data_mappers, system_data_models
Application Manager	app-runtime	Creates, reads, writes	runtime_application, build, build_export, build_import, runtime_config_param, runtime_data_model_slice, active_build_policy
CMS Core	cms-core	Creates, reads, writes	contents, generic_images, themes, fonts, taxonomies, content_schemas
Document Plugin	document	Creates, reads, writes	docs_templates
Document Plugin	app-runtime	Reads	Runtime data for document generation
Integration Designer	integration-designer	Creates, reads, writes	workflows, workflow_nodes, workflow_instances, integration_systems, endpoints, mcp_tools
Integration Designer	app-runtime	Reads	Runtime data for integration execution
Notification Plugin	notification	Creates, reads, writes	templates, otps, in_app_notifications, notifications
Notification Plugin	app-runtime	Reads	Runtime data for notification delivery
Scheduler	notification	Creates, reads, writes	scheduled_messages, scheduled_timer_event
Task Management	task-management-plugin	Creates, reads, writes	users_assigned_tasks, hooks, tasks, views, task_histories
Task Management	app-runtime	Reads	Runtime data for task resolution
Process Engine	app-runtime	Reads	Runtime data for process execution
Email Gateway	app-runtime	Reads	Runtime data for email delivery
NoSQL DB Runner	nosql-db-runner	Creates, reads, writes	Custom collections (FlowX Database feature)

Shared databases:

• app-runtime — Created by Application Manager, read by 6 other services
• notification — Shared by Notification Plugin and Scheduler

---

Elasticsearch

---

Redis (caching)

All services below use Redis for caching via Spring Cache Manager. Redis is not a system-of-record.

---

S3-compatible object storage

---

Services with NO database (pure gateway/utility)

Service	Storage	Purpose
Events Gateway	Redis only (pub/sub + cache)	Event streaming and distribution
Data Sync	Liquibase migrations only	Schema migration coordinator
Runtime Manager	Docker-only service	Runtime orchestration
Designer (frontend)	None	Web UI, communicates via HTTP to backend services

---

Summary: services per database type

Service	PostgreSQL	MongoDB	Elasticsearch	Redis	S3
Admin	flowxadmin	data-model	—	cache	—
Advancing Controller	advancing	—	—	—	—
Application Manager	app_manager	app-runtime	—	cache	applications-bucket
Audit Core	—	—	audit index	—	—
Authorization System	auth_system	—	—	cache, sessions	—
CMS Core	—	cms-core	—	cache	media-library-bucket, cms-private-storage-bucket
Data Search	—	—	process index (read)	—	—
Data Sync	migrations only	—	—	—	—
Document Plugin	document	document, app-runtime (read)	—	cache	flowx-dev-bucket, temp-bucket
Email Gateway	email_gateway	app-runtime (read)	—	cache	—
Events Gateway	—	—	—	cache, pub/sub	—
Integration Designer	—	integration-designer, app-runtime (read)	—	cache	workflows-bucket
License	license	—	—	cache	—
Mock Server	flowx-mocks	—	—	—	—
NoSQL DB Runner	—	nosql-db-runner	—	—	—
Notification Plugin	—	notification, app-runtime (read)	—	cache, sessions	notifications-bucket
Organization Manager	org_manager	—	—	cache, sessions	—
Process Engine	process_engine	app-runtime (read)	process index	cache	—
Scheduler	—	notification	—	—	—
Task Management	process_engine (shared)	task-management-plugin, app-runtime (read)	—	cache, sessions	—