PostgresSkillRepository

PostgreSQL database-based implementation of AgentSkillRepository.

This implementation stores skills in PostgreSQL database tables with the following structure:

• Skills table: stores core lookup fields (name, description), skill content, source, and optionally the full metadata tree in metadata_json

• Resources table: stores skill resources (id, resource_path, resource_content)

Table schema for newly created tables (createIfNotExist=true):

CREATE TABLE IF NOT EXISTS "agentscope"."agentscope_skills" (
id BIGSERIAL PRIMARY KEY,
name VARCHAR(255) NOT NULL UNIQUE,
description TEXT NOT NULL,
skill_content TEXT NOT NULL,
source VARCHAR(255) NOT NULL,
metadata_json TEXT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS "agentscope"."agentscope_skill_resources" (
id BIGINT NOT NULL,
resource_path VARCHAR(500) NOT NULL,
resource_content TEXT NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id, resource_path),
FOREIGN KEY (id) REFERENCES "agentscope"."agentscope_skills"(id) ON DELETE CASCADE
);

Compatibility behavior:

• New tables created by this repository include metadata_json

• Existing tables are not auto-migrated with ALTER TABLE

• When metadata_json exists, full skill metadata is persisted and restored

• When metadata_json does not exist, the repository falls back to the legacy schema and only round-trips name and description

Features:

• Automatic schema/table creation when createIfNotExist=true

• Runtime compatibility detection for legacy and new schemas

• Full CRUD operations for skills and their resources

• SQL injection prevention through parameterized queries

• Transaction support for atomic operations

• PostgreSQL schema-based storage selected by JDBC URL plus schema configuration

Example usage:

`// Using simple constructor with default schema/table names
DataSource dataSource = createDataSource();
PostgresSkillRepository repo = new PostgresSkillRepository(dataSource, true, true);

// Using Builder for custom configuration
PostgresSkillRepository repo = PostgresSkillRepository.builder(dataSource)
.schemaName("my_schema")
.skillsTableName("my_skills")
.resourcesTableName("my_resources")
.createIfNotExist(true)
.writeable(true)
.build();

// Save a skill
AgentSkill skill = new AgentSkill("my-skill", "Description", "Content", resources);
repo.save(List.of(skill), false);

// Get a skill
AgentSkill loaded = repo.getSkill("my-skill");
`