Skip to content

Latest commit

 

History

History
61 lines (45 loc) · 1.69 KB

query.md

File metadata and controls

61 lines (45 loc) · 1.69 KB
Raw

query

Given a datasource specified in the application configuration, this agent enables submitting queries to that source and outputting the results.

This is very similar to the query-vector-db agent, but it is not limited to vector databases.

Example

Install PostgreSQL in a local minikube cluster:

minikube start
helm repo add bitnami https://charts.bitnami.com/bitnami
helm install my-postgresql bitnami/postgresql --version 12.8.2

Specify a datasource in configuration.yaml:

configuration:
  resources:
    - type: "datasource"
      name: "PGDataSource"
      configuration:
        service: "jdbc"
        driverClass: "org.postgresql.Driver"
        url: "jdbc:postgresql://postgresql.default.svc.cluster.local:5432/"
        user: "postgres"
        password: "xxxxxxxx"

Reference that datasource and submit a query using input message values:

- name: "Execute Query"
  type: "query"
  input: "input-topic" # optional
  output: "output-topic" # optional
  configuration:
    datasource: "PGDataSource"
    query: "SELECT * FROM products WHERE id = ?"
    fields:
      - "value.id"
    output-field: "value.query-result"

Topics

Input

  • Structured and unstructured text ?
  • Implicit topic ?

Output

  • Structured text ?
  • Implicit topic ?

Configuration

Checkout the full configuration properties in the API Reference page.