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
-- 048_summary_indexes.sql
-- Add composite indexes for efficient querying of summary tables
-- Composite indexes for daily_usage_summary
CREATE INDEX IF NOT EXISTS idx_daily_usage_provider_date
ON daily_usage_summary(provider, date);
CREATE INDEX IF NOT EXISTS idx_daily_usage_model_date
ON daily_usage_summary(model, date);
CREATE INDEX IF NOT EXISTS idx_daily_usage_provider_model_date_composite
ON daily_usage_summary(provider, model, date);
-- Composite indexes for hourly_usage_summary
CREATE INDEX IF NOT EXISTS idx_hourly_usage_provider_date
ON hourly_usage_summary(provider, date_hour);
CREATE INDEX IF NOT EXISTS idx_hourly_usage_model_date
ON hourly_usage_summary(model, date_hour);
CREATE INDEX IF NOT EXISTS idx_hourly_usage_provider_model_date_composite
ON hourly_usage_summary(provider, model, date_hour);
-- Add unique constraint to prevent duplicate aggregations
CREATE UNIQUE INDEX IF NOT EXISTS idx_daily_usage_unique
ON daily_usage_summary(provider, model, date);
CREATE UNIQUE INDEX IF NOT EXISTS idx_hourly_usage_unique
ON hourly_usage_summary(provider, model, date_hour);