Package com.google.genkit.plugins.postgresql


package com.google.genkit.plugins.postgresql
PostgreSQL plugin for Genkit providing vector database integration using pgvector extension.

This plugin provides:

  • PostgreSQL with pgvector extension for vector similarity search
  • Document indexing with automatic embedding generation
  • Support for multiple distance strategies (cosine, L2, inner product)
  • Automatic table and index creation
  • Connection pooling with HikariCP

Example usage:


 Genkit genkit = Genkit.builder()
     .plugin(GoogleGenAIPlugin.create(apiKey))
     .plugin(
         PostgresPlugin.builder()
             .connectionString("jdbc:postgresql://localhost:5432/mydb")
             .username("user")
             .password("pass")
             .addTable(
                 PostgresTableConfig.builder()
                     .tableName("documents")
                     .embedderName("googleai/text-embedding-004")
                     .build())
             .build())
     .build();