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 { NextResponse } from "next/server";
import { getDbInstance } from "@/lib/db/core";
import { backupDbFile } from "@/lib/db/backup";
import { clearApiKeyCaches } from "@/lib/db/apiKeys";
import { invalidateDbCache } from "@/lib/db/readCache";
import {
CREDENTIAL_IMPORT_FORBIDDEN_MESSAGE,
requireOperatorCredential,
} from "@/lib/api/operatorCredential";
import { runJsonMigration, type LegacyJsonData } from "@/lib/db/jsonMigration";
import { getSettings } from "@/lib/db/settings";
import { setSystemPromptConfig } from "@omniroute/open-sse/services/systemPrompt.ts";
import { sanitizeErrorMessage } from "@omniroute/open-sse/utils/error";
import { IMPORT_STRIPPED_SETTINGS_KEYS } from "@/shared/constants/securityImpactingSettings";
/**
* Drops the password (and any `currentPassword`), every key PATCH only accepts after password
* re-auth, and the dashboard session state (`sessionsValidAfter`, `revokedDashboardSessions`).
*/
function stripSecurityImpactingSettings(settings: object): Record<string, unknown> {
const safeSettings: Record<string, unknown> = { ...settings };
for (const key of IMPORT_STRIPPED_SETTINGS_KEYS) {
delete safeSettings[key];
}
return safeSettings;
}
/**
* POST /api/settings/import-json
*
* Imports a legacy OmniRoute JSON backup into the current SQLite
* database. Accepts either multipart/form-data (file field) or a raw JSON body.
*
* 🔒 Operator-only: dashboard session, local CLI, or login disabled. The import replaces
* settings, connections and API keys, so API keys of any scope and `oma_` access tokens
* get 403 (same boundary as `GET /api/settings/export-json`).
* 🔒 Zero-Trust: IMPORT_STRIPPED_SETTINGS_KEYS are stripped before insertion — the password
* and `currentPassword`, every key `PATCH /api/settings` only accepts after password
* re-auth (SECURITY_IMPACTING_SETTINGS_KEYS: requireLogin, the LOCAL_ONLY manage-scope
* bypass list/kill-switch, every OIDC key) and the dashboard session state — an import
* must not be a way around that re-auth, nor revive sessions a password change or a
* sign-out ended.
* 🔒 A pre-import backup is created automatically before any data is written.
*/
export async function POST(request: Request) {
const operatorVerdict = await requireOperatorCredential(request, {
forbiddenMessage: CREDENTIAL_IMPORT_FORBIDDEN_MESSAGE,
});
if (operatorVerdict.ok === false) return operatorVerdict.response;
try {
let rawText: string | null = null;
const contentType = request.headers.get("content-type") ?? "";
if (contentType.includes("multipart/form-data")) {
const formData = await request.formData();
const file = formData.get("file") as File | null;
if (!file) return NextResponse.json({ error: "No json file provided" }, { status: 400 });
rawText = await file.text();
} else {
rawText = await request.text();
}
if (!rawText?.trim()) {
return NextResponse.json({ error: "Empty request payload" }, { status: 400 });
}
// Parse with explicit 400 on malformed JSON (Gemini suggestion)
let data: LegacyJsonData;
try {
data = JSON.parse(rawText) as LegacyJsonData;
} catch {
return NextResponse.json(
{
error: "Invalid JSON: the file could not be parsed. Please upload a valid .json backup.",
},
{ status: 400 }
);
}
// 🔒 Zero-Trust: strip authentication + security-impacting config before migration
if (data.settings && typeof data.settings === "object") {
data = { ...data, settings: stripSecurityImpactingSettings(data.settings) };
}
const db = getDbInstance();
// Create a safety backup before writing anything
backupDbFile("pre-json-import");
// Delegate the actual migration to the shared helper (avoids duplication with core.ts)
const counts = runJsonMigration(db, data);
clearApiKeyCaches();
invalidateDbCache();
// Re-hydrate the in-memory Global System Prompt config — the migration writes it to
// the DB but the in-memory state would stay stale until a restart otherwise (#2470).
const importedSettings = await getSettings();
if (importedSettings.systemPrompt) {
setSystemPromptConfig(importedSettings.systemPrompt);
}
console.log(
`[JSON Import] Imported ${counts.connections} connections, ${counts.nodes} nodes, ` +
`${counts.combos} combos, ${counts.apiKeys} API keys, ` +
`${counts.usageHistory} usage rows, ${counts.domainCostHistory} cost rows, ` +
`${counts.domainBudgets} budgets`
);
return NextResponse.json({
success: true,
message: "Legacy JSON database imported successfully",
...counts,
});
} catch (err) {
console.error("[API] Error importing JSON backup:", err);
return NextResponse.json(
{ error: sanitizeErrorMessage(err instanceof Error ? err.message : String(err)) },
{ status: 500 }
);
}
}