EDB Database v1.4.0 (LTS)

The EDB Database component resolves an HM project, cluster, and connection type to a Postgres connection URL and exposes that URL as an output. Downstream components (SQL query, MCP-tool wrappers, custom code) use the URL to connect.

Choosing the right component

Use the EDB Database component when:

  • You need a Postgres connection URL for a database in an HM cluster, derived from your HM project and connection settings.
  • You want to wire that URL into another component that connects to the database directly (an EDB Airman MCP for SQL-as-tools, or a custom flow component).

Use a different component if:

  • You want similarity search against an existing knowledge base. Use EDB Knowledge Base.
  • You want to manage pgvector index structure. Use EDB Vector Index.
  • You want SQL as MCP tools for an agent. Use EDB Airman MCP (it accepts the URL output from this component).

Prerequisites

  • The Project Viewer role on the project that owns the cluster:

    • Project > Users > Assign Project Roles > Project Viewer.
  • An HM cluster the user has access to. See Create clusters.

  • An HM machine-user access key and the database user/password saved in Langflow as Global Variables.

Inputs

FieldTypeRequiredDefaultNotes
Hybrid Manager URLTextNoAdvanced. Override the default HM URL.
HM Machine User KeySecretYesHM_API_KEYDefaults to the global variable named HM_API_KEY.
Hybrid Manager ProjectDropdownYesPopulated from your HM projects.
Hybrid Manager DatabaseDropdownYesThe cluster containing the database.
Database GroupDropdownNoCluster group, for example primary or reader.
Database Connection TypeDropdownYesFor example, read or read/write.
User for the databaseTextYesHM_DB_USERDefaults to the HM_DB_USER global variable.
Password for the databaseSecretYesHM_DB_PASSWORDDefaults to the HM_DB_PASSWORD global variable.
Default database name overrideTextNoAdvanced. Override the cluster default when listing databases.
Database NameDropdownNoThe database to connect to. Leave blank to use the user's default.
Note

If you can't select a project because the portal domain defaults to the API, select Controls at the top of the EDB Database and Knowledge Base component to configure http://istio-internalgateway.istio-system.svc.cluster.local:7080 as the Hybrid Manager URL.

Outputs

OutputTypeCarries
Database URLMessageThe fully resolved Postgres connection string (postgresql://user:password@host:port/database), URL-encoded as needed. Pass this into components that take a database URL, such as EDB Airman MCP.