Database reference
The exact table and columns the assistants API reads and writes.
Identity mapping
The public identifier is assistant_id (a UUID) — a response alias of the assistant’s public-id storage column (which carries a legacy internal name). Route parameters written as {assistantId} take this UUID. The numeric id column is internal.
assistants
All configuration lives on the single assistants table — scalar columns for the core fields and one JSON column per behaviour plan, exactly as listed in the machine-readable block of this page. Related tables: prompt_templates (template picker), personalities (personality picker), assistant_base_configs (v2 builder bases).