Database Schema

Core tables for skills, agents, protocols, battles, logs, and activity events.

Solenvus uses PostgreSQL with Drizzle ORM.

The schema stores product entities and execution records.

skills

Stores skill metadata and scoring.

Key columns:

• id

• name

• slug

• description

• protocol

• category

• status

• tags

• isVerified

• supportsLiveTest

• supportsBattle

• trustScore

• speedScore

• battleScore

• docsScore

• createdAt

agents

Stores AI agent records.

Key columns:

• id

• name

• slug

• description

• framework

• protocols

• skills

protocols

Stores integrated protocol metadata.

Key columns:

• id

• name

• slug

• description

• category

• website

• docs

battle_results

Stores battle outcomes and score breakdowns.

Key columns:

• id

• contestant1Id

• contestant2Id

• winnerId

• winnerName

• contestant1Score

• contestant2Score

• protocol

• createdAt

execution_logs

Stores individual skill execution records.

Key columns:

• id

• skillName

• protocol

• eventType

• status

• isMock

• input

• output

• latencyMs

• createdAt

activity_events

Stores platform activity stream events.

Key columns:

• id

• eventType

• category

• title

• description

• protocol

• skillName

• agentName

• severity

• isMock

• metadata

• latencyMs

• createdAt

saved_skills

Stores user-saved skills for quick access.

This data is session-scoped.

Supporting tables

Supporting tables include:

• builders

• categories

• tags

These support directory views and taxonomy management.