Never stop coding. Free MIT AI gateway: one endpoint, 375 providers (150+ free), 1,400+ models Kimi, Claude, GPT, Gemini, GLM, DeepSeek, MiniMax. Works with Claude Code, Codex, Cursor, OpenCode, Cline & Copilot. Quota-aware auto-fallback, RTK+Caveman compression saves 15-95% tokens, MCP/A2A, Desktop/PWA. Built by 900+ contributors
TypeScript a2aai-agentsai-gatewayanthropicclaudeclaude-codeclinecodexcopilotcursordeepseekfree-aigeminikimillm-gatewaymcpopenaiopenai-proxyqwentoken-saver
import { getDbInstance } from "./core";
/**
* Provider/model call statistics aggregated from `call_logs`.
*
* Hard Rule #5: routes must not embed raw SQL — these queries live here so the
* /api/provider-stats route can delegate. Read-only aggregation; no writes.
*/
export interface ProviderCallStat {
provider: string;
nodeName: string | null;
totalRequests: number;
successfulRequests: number;
avgLatencyMs: number | null;
totalTokensIn: number | null;
totalTokensOut: number | null;
}
export interface ModelCallStat {
provider: string;
nodeName: string | null;
model: string;
requests: number;
avgLatencyMs: number | null;
successfulRequests: number;
}
export function getProviderCallStats(): ProviderCallStat[] {
const db = getDbInstance();
return db
.prepare(
`SELECT
c.provider,
pn.name AS nodeName,
COUNT(*) AS totalRequests,
SUM(CASE WHEN c.status >= 200 AND c.status < 400 THEN 1 ELSE 0 END) AS successfulRequests,
ROUND(AVG(c.duration)) AS avgLatencyMs,
SUM(c.tokens_in) AS totalTokensIn,
SUM(c.tokens_out) AS totalTokensOut
FROM call_logs c
LEFT JOIN provider_nodes pn ON pn.id = c.provider
WHERE c.provider IS NOT NULL AND c.provider != '-'
GROUP BY c.provider
ORDER BY totalRequests DESC`
)
.all() as ProviderCallStat[];
}
export function getModelCallStats(): ModelCallStat[] {
const db = getDbInstance();
return db
.prepare(
`SELECT
c.provider,
pn.name AS nodeName,
c.model,
COUNT(*) AS requests,
ROUND(AVG(c.duration)) AS avgLatencyMs,
SUM(CASE WHEN c.status >= 200 AND c.status < 400 THEN 1 ELSE 0 END) AS successfulRequests
FROM call_logs c
LEFT JOIN provider_nodes pn ON pn.id = c.provider
WHERE c.provider IS NOT NULL AND c.model IS NOT NULL
GROUP BY c.provider, c.model
ORDER BY c.provider, requests DESC`
)
.all() as ModelCallStat[];
}