AI MariaDB
CertifiedStore embeddings in MariaDB
AI MariaDB
Store embeddings in MariaDB
Persists embeddings to a MariaDB table; create/drop behavior is controlled by createTable and drop. Metadata storage mode defaults to COLUMN_PER_KEY (which requires column/index definitions); set COMBINED_JSON to store metadata as a JSON object in a single column. Requires valid JDBC URL and credentials.
type: io.kestra.plugin.ai.embeddings.MariaDBExamples
Ingest documents into a MariaDB embedding store
id: document_ingestion
namespace: company.ai
tasks:
- id: ingest
type: io.kestra.plugin.ai.rag.IngestDocument
provider:
type: io.kestra.plugin.ai.provider.GoogleGemini
modelName: gemini-embedding-001
apiKey: "{{ secret('GEMINI_API_KEY') }}"
embeddings:
type: io.kestra.plugin.ai.embeddings.MariaDB
username: "{{ secret('MARIADB_USERNAME') }}"
password: "{{ secret('MARIADB_PASSWORD') }}"
databaseUrl: "{{ secret('MARIADB_DATABASE_URL') }}"
tableName: embeddings
fieldName: id
createTable: true
fromExternalURLs:
- https://raw.githubusercontent.com/kestra-io/docs/refs/heads/main/content/blogs/release-0-24.md
Properties
createTable *booleanstring
Create table if missing
If true, the embeddings table is created when it does not already exist. Defaults to false.
databaseUrl *string
Database URL
JDBC URL of the MariaDB database holding the embeddings. No default: this property is required.
fieldName *string
ID column name
Name of the column used as the unique identifier of each embedding. Defaults to an empty value, which lets the MariaDB store use its own column name.
password *string
Password
Password of the database user. Store it as a Kestra secret rather than inline. No default: this property is required.
tableName *string
Table name
Name of the table where embeddings are stored. No default: this property is required.
username *string
Username
User connecting to the MariaDB database. No default: this property is required.
columnDefinitions array
Metadata column definitions
SQL column definitions for metadata fields, one per metadata key. Required only when metadataStorageMode is COLUMN_PER_KEY. Not set by default.
indexes array
Metadata index definitions
SQL index definitions for the metadata columns. Used only when metadataStorageMode is COLUMN_PER_KEY. Not set by default (no extra index).
metadataStorageMode string
COLUMN_PER_KEYMetadata storage mode
How document metadata is persisted. COLUMN_PER_KEY stores each metadata key in its own column and requires columnDefinitions and indexes; COMBINED_JSON stores all metadata as a single JSON column. Defaults to COLUMN_PER_KEY.
