Skip to content

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

986 B
Raw Blame
-- Migration 174: Durable server tool execution fence table.
-- Tracks claim/result state for server-owned tool calls to prevent duplicate execution
-- across retries and concurrent requests. Independent of skill_executions.

CREATE TABLE IF NOT EXISTS server_tool_executions (
  id TEXT PRIMARY KEY,
  api_key_id TEXT NOT NULL,
  request_identity TEXT NOT NULL,
  tool_call_id TEXT NOT NULL,
  tool_name TEXT NOT NULL,
  input_digest TEXT NOT NULL,
  output TEXT,
  status TEXT NOT NULL CHECK(status IN ('running', 'success', 'error', 'timeout')),
  error_message TEXT,
  duration_ms INTEGER,
  claim_expires_at TEXT NOT NULL,
  completed_at TEXT,
  created_at TEXT NOT NULL DEFAULT (datetime('now')),
  UNIQUE(api_key_id, request_identity, tool_call_id)
);

CREATE INDEX IF NOT EXISTS idx_server_tool_executions_status_expiry
  ON server_tool_executions(status, claim_expires_at);
CREATE INDEX IF NOT EXISTS idx_server_tool_executions_created
  ON server_tool_executions(created_at);