AgentPrismPostgreSqlOptions

Namespace AgentPrism · Assembly AgentPrism.PostgreSql.dll

Settings for AgentPrism’s PostgreSQL persistence layer.

public sealed class AgentPrismPostgreSqlOptions

Inheritance

object ← AgentPrismPostgreSqlOptions

Inherited Members

object.GetType(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()

Remarks

Validation is done by hand in AgentPrismPostgreSqlOptionsValidator; DataAnnotations is not used.

Constructors

AgentPrismPostgreSqlOptions()

public AgentPrismPostgreSqlOptions()

Fields

SectionName

The full path of the configuration section settings are read from.

public const string SectionName = "AgentPrism:PostgreSql"

Field Value

string

Properties

AutoApplyMigrations

Whether pending migrations are applied automatically at application startup.

public bool AutoApplyMigrations { get; set; }

Property Value

bool

Remarks

Can be set to false in production and MigrationRunner run as a separate deployment step, so a long-running migration does not block application startup.

CommandTimeoutSeconds

The upper time limit for a single SQL command (seconds). 0 means unlimited.

public int CommandTimeoutSeconds { get; set; }

Property Value

int

ConnectionString

The PostgreSQL connection string.

public string? ConnectionString { get; set; }

Property Value

string?

Remarks

This value is a secret and is never written to a file. Use dotnet user-secrets, an environment variable, or a secret manager.

EnableKnowledge

Whether the “knowledge” migration set is applied. Default false.

public bool EnableKnowledge { get; set; }

Property Value

bool

Remarks

The knowledge set needs the pgvector extension; a consumer on a managed PostgreSQL without permission to install extensions never sees it unless this is turned on. While it is false, no IVectorSearchStore is registered — an agent definition that requests vector search fails compilation with a clear error instead of a database error at run time.

SchemaName

The schema AgentPrism’s tables are created in. The consumer’s public schema is never touched, under any circumstances.

public string SchemaName { get; set; }

Property Value

string

Remarks

Must follow the rules for an unquoted PostgreSQL identifier: starts with a lowercase letter or underscore, contains lowercase letters, digits, and underscores, at most 63 characters.