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/developer/usage — API usage metrics for the developer dashboard.
//
// Returns request counts, error rates, top endpoints, and usage over time
// aggregated from audit_log + webhook_deliveries + settled x402 checkout calls
// against the caller's own SKUs.
//
// Query parameters:
// days — lookback window: 7 | 30 | 90 (default: 30)
import { cors, error, json, method, wrap } from '../_lib/http.js';
import { getSessionUser } from '../_lib/auth.js';
import { sql } from '../_lib/db.js';
import { atomicsToUsdc } from '../_lib/agent-economy.js';
const ALLOWED_DAYS = [7, 30, 90];
// One panel failing must not blank the whole dashboard, but a panel that fails
// every time must not read as a real zero either: the x402 block did exactly
// that, querying payee_user_id/amount_usdc/created_at columns x402_receipts has
// never had, so a silent catch reported 0 payments to every developer. Degraded
// sections are logged and named in the response so the UI (and the next reader)
// can tell "no activity" from "this number is unavailable".
function section(name, query, fallback, degraded) {
return query.catch((err) => {
console.warn(`[developer/usage] ${name} query failed: ${err?.message || err}`);
degraded.push(name);
return fallback;
});
}
export default wrap(async function handler(req, res) {
if (cors(req, res, { methods: 'GET,OPTIONS', credentials: true })) return;
if (!method(req, res, ['GET'])) return;
const user = await getSessionUser(req, res);
if (!user) return error(res, 401, 'unauthorized', 'Sign in required');
const url = new URL(req.url, 'http://x');
const days = ALLOWED_DAYS.includes(Number(url.searchParams.get('days')))
? Number(url.searchParams.get('days'))
: 30;
const since = new Date(Date.now() - days * 86400_000).toISOString();
const degraded = [];
const [apiKeyStats, auditStats, auditTimeseries, topActions, webhookStats, x402Stats] =
await Promise.all([
section('api_keys', sql`
select count(*)::int as total_keys,
count(*) filter (where revoked_at is null)::int as active_keys
from api_keys
where user_id = ${user.id}
`, [{ total_keys: 0, active_keys: 0 }], degraded),
section('requests', sql`
select count(*)::int as total_requests,
count(distinct action)::int as unique_actions,
count(*) filter (where action like '%.error%' or action like '%fail%')::int as error_count,
min(created_at) as first_request_at,
max(created_at) as last_request_at
from audit_log
where user_id = ${user.id} and created_at >= ${since}::timestamptz
`, [{ total_requests: 0, unique_actions: 0, error_count: 0, first_request_at: null, last_request_at: null }], degraded),
section('timeseries', sql`
select date_trunc('day', created_at)::date as day,
count(*)::int as requests
from audit_log
where user_id = ${user.id} and created_at >= ${since}::timestamptz
group by 1
order by 1
`, [], degraded),
section('top_actions', sql`
select action, count(*)::int as count
from audit_log
where user_id = ${user.id} and created_at >= ${since}::timestamptz
group by action
order by count desc
limit 10
`, [], degraded),
section('webhooks', sql`
select count(*)::int as total_deliveries,
count(*) filter (where status_code between 200 and 299)::int as succeeded,
count(*) filter (where status_code is null or status_code >= 400)::int as failed
from webhook_deliveries wd
join developer_webhooks dw on dw.id = wd.webhook_id
where dw.user_id = ${user.id} and wd.created_at >= ${since}::timestamptz
`, [{ total_deliveries: 0, succeeded: 0, failed: 0 }], degraded),
// Paid calls against the SKUs this developer owns, the only place the
// schema links x402 revenue to a user account (x402_receipts is keyed by
// payer wallet and carries no owner column). Mirrors api/x402-skus.js:
// response_status < 400 is a settled call, amounts are USDC atomics held
// as text.
section('x402', sql`
select count(*)::int as total_payments,
coalesce(sum(case when c.amount_atomics ~ '^[0-9]+$' then c.amount_atomics::numeric else 0 end), 0)::text as total_atomics
from x402_checkout_calls c
join x402_skus s on s.id = c.sku_id
where s.owner_user_id = ${user.id}
and c.paid_at >= ${since}::timestamptz
and c.response_status < 400
`, [{ total_payments: 0, total_atomics: '0' }], degraded),
]);
const audit = auditStats[0] || { total_requests: 0, unique_actions: 0, error_count: 0 };
const keys = apiKeyStats[0] || { total_keys: 0, active_keys: 0 };
const wh = webhookStats[0] || { total_deliveries: 0, succeeded: 0, failed: 0 };
const x402 = x402Stats[0] || { total_payments: 0, total_atomics: '0' };
const errorRate = audit.total_requests > 0
? Number(((audit.error_count / audit.total_requests) * 100).toFixed(2))
: 0;
return json(res, 200, {
period: { days, since },
api_keys: keys,
requests: {
total: audit.total_requests,
unique_actions: audit.unique_actions,
errors: audit.error_count,
error_rate: errorRate,
first_at: audit.first_request_at,
last_at: audit.last_request_at,
},
timeseries: auditTimeseries,
top_actions: topActions,
webhooks: wh,
x402: {
payments: x402.total_payments,
volume_usdc: atomicsToUsdc(x402.total_atomics),
volume_atomics: String(x402.total_atomics ?? '0'),
},
degraded,
});
});