Open-source platform for 3D AI agents. Turn text or a photo into a rigged, animated GLB avatar, give it an LLM brain, memory and a wallet, and embed it anywhere with one web component. Remote MCP server, x402 payments, Three.js, browser-native.
JavaScript 3d-generationai-agentsanimationavatardigital-humangenerative-aiglbgltfimage-to-3dllmmcpmcp-servermodel-context-protocolsolanatext-to-3dthreejsweb-componentswebglwebxrx402
-- Migration: user notifications table.
--
-- Stores in-app notifications for agent owners (payment received, withdrawal
-- completed/failed). Fire-and-forget inserts; failures are logged not thrown.
begin;
create table if not exists user_notifications (
id uuid primary key default gen_random_uuid(),
user_id uuid not null references users(id) on delete cascade,
type text not null,
payload jsonb not null default '{}',
read_at timestamptz,
created_at timestamptz not null default now()
);
create index if not exists user_notifications_user_unread
on user_notifications (user_id, read_at, created_at desc);
commit;