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
/**
* GET /api/creators/skill-analytics
*
* Aggregated skill usage metrics for all agents owned by the authenticated creator.
* Query params:
* agent_id: filter to a specific agent (optional, must be a UUID)
* days: lookback window in days (default 30, clamped to 1..365)
*/
import { sql } from '../_lib/db.js';
import { getSessionUser } from '../_lib/auth.js';
import { cors, error, json, method, wrap, rateLimited } from '../_lib/http.js';
import { clientIp, limits } from '../_lib/rate-limit.js';
import { isUuid } from '../_lib/validate.js';
/** Repeated query keys arrive as an array; take the first value and trim it. */
function queryValue(raw) {
const v = Array.isArray(raw) ? raw[0] : raw;
return typeof v === 'string' ? v.trim() : '';
}
export default wrap(async (req, res) => {
if (cors(req, res, { methods: 'GET,OPTIONS', credentials: true })) return;
if (!method(req, res, ['GET'])) return;
const user = await getSessionUser(req);
if (!user) return error(res, 401, 'unauthorized', 'sign in required');
const rl = await limits.authedReadIp(clientIp(req));
if (!rl.success) return rateLimited(res, rl);
const q = req.query ?? {};
// Clamped low as well as high: a negative window put `since` in the future
// and answered every panel with a silent, permanently empty result set.
const requestedDays = parseInt(queryValue(q.days), 10);
const days = Number.isFinite(requestedDays) && requestedDays > 0 ? Math.min(requestedDays, 365) : 30;
// agent_id reaches Postgres as a uuid comparison, so anything else is a
// 22P02 cast failure (a 500) unless it is rejected at the boundary here.
const agentIdRaw = queryValue(q.agent_id);
if (agentIdRaw && !isUuid(agentIdRaw)) {
return error(res, 400, 'invalid_agent_id', 'agent_id must be a UUID');
}
const agentIdFilter = agentIdRaw || null;
const since = new Date(Date.now() - days * 86400_000);
// Confirm the user owns the requested agent (if filtering).
if (agentIdFilter) {
const [agent] = await sql`
SELECT id FROM agent_identities WHERE id = ${agentIdFilter} AND user_id = ${user.id} AND deleted_at IS NULL
`;
if (!agent) return error(res, 403, 'forbidden', 'not your agent');
}
const bySkill = await sql`
SELECT
sul.agent_id,
ai.name AS agent_name,
sul.skill_name,
COUNT(*)::int AS total_calls,
COUNT(DISTINCT sul.user_id)::int AS unique_users,
COUNT(*) FILTER (WHERE sul.status = 'success')::int AS successes,
COUNT(*) FILTER (WHERE sul.status = 'failure')::int AS failures,
ROUND(AVG(sul.execution_time_ms))::int AS avg_execution_ms,
ROUND(
100.0 * COUNT(*) FILTER (WHERE sul.status = 'success') / NULLIF(COUNT(*), 0),
1
)::float AS success_rate_pct
FROM skill_usage_logs sul
JOIN agent_identities ai ON ai.id = sul.agent_id
WHERE ai.user_id = ${user.id}
AND sul.created_at >= ${since}
${agentIdFilter ? sql`AND sul.agent_id = ${agentIdFilter}` : sql``}
GROUP BY sul.agent_id, ai.name, sul.skill_name
ORDER BY total_calls DESC
LIMIT 200
`;
// Summary totals.
const [totals] = await sql`
SELECT
COUNT(*)::int AS total_calls,
COUNT(DISTINCT sul.user_id)::int AS unique_users,
COUNT(*) FILTER (WHERE sul.status = 'success')::int AS successes
FROM skill_usage_logs sul
JOIN agent_identities ai ON ai.id = sul.agent_id
WHERE ai.user_id = ${user.id}
AND sul.created_at >= ${since}
${agentIdFilter ? sql`AND sul.agent_id = ${agentIdFilter}` : sql``}
`;
// Daily call volume for a sparkline.
const daily = await sql`
SELECT
date_trunc('day', sul.created_at)::date AS date,
COUNT(*)::int AS calls
FROM skill_usage_logs sul
JOIN agent_identities ai ON ai.id = sul.agent_id
WHERE ai.user_id = ${user.id}
AND sul.created_at >= ${since}
${agentIdFilter ? sql`AND sul.agent_id = ${agentIdFilter}` : sql``}
GROUP BY 1
ORDER BY 1 ASC
`;
return json(res, 200, {
data: {
period_days: days,
summary: totals,
by_skill: bySkill,
daily,
},
});
});