MysqlSkillRepository

MySQL database-based implementation of AgentSkillRepository.

This implementation stores skills in MySQL 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_skills (
id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL UNIQUE,
description TEXT NOT NULL,
skill_content LONGTEXT NOT NULL,
source VARCHAR(255) NOT NULL,
metadata_json LONGTEXT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS agentscope_skill_resources (
id BIGINT NOT NULL,
resource_path VARCHAR(500) NOT NULL,
resource_content LONGTEXT NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id, resource_path),
FOREIGN KEY (id) REFERENCES agentscope_skills(id) ON DELETE CASCADE
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

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 database/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

• UTF-8 (utf8mb4) character set support for internationalization

Example usage:

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

// Using Builder for custom configuration
MysqlSkillRepository repo = MysqlSkillRepository.builder(dataSource)
.databaseName("my_database")
.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");
`