Open-source manufacturing ERP, MES and QMS. Quoting, MRP, inventory, shop floor, quality and lot/serial traceability on one Postgres schema, with a REST API and MCP server. Self-host or use Carbon Cloud.
TypeScript ai-agentsbill-of-materialserpinventory-managementleanmanufacturingmanufacturing-execution-systemmcp-servermesmrpopen-source-erppostgresqlproduction-planningqmsquality-management-systemreact-routerself-hostedsupabasetraceabilitytypescript
// SPDX-License-Identifier: LicenseRef-Carbon-Commercial
// Carbon Enterprise file, licensed only under the Carbon Commercial License
// (packages/ee/LICENSE). Not AGPL. Running, modifying, or copying it beyond those terms requires a commercial license.
import type { Database } from "@carbon/database";
import { sanitize } from "@carbon/utils";
import type { SupabaseClient } from "@supabase/supabase-js";
import { requireEntitlement } from "./entitlements.server";
/**
* Commercial (Business) API-key AUTHORING — creating, editing, and deleting a
* company's public-API keys, gated to the Business plan via the `API_KEYS`
* feature. The runtime VERIFICATION path (`@carbon/auth`
* `api-key.server.ts` / the `api+/v1+` authenticator) is a separate concern and
* is NOT gated here — an already-issued key keeps authenticating regardless of
* plan.
*
* The key is generated and hashed in the open route action (server-only:
* `hashApiKey` from `@carbon/auth/auth.server` + `nanoid`); this function only
* receives the already-computed `rawKey`/`keyHash`/`keyPreview` and stores the
* hash, so no crypto crosses the package boundary.
*
* The entitlement LOCK lives INSIDE this commercial function (see
* `entitlements.server`) so it cannot be stripped from open-licensed app code.
*/
// Minimal input shape — the validator's `Omit<…, "id" | "scopes" | "expiresAt">`
// leaves only `name` (redefined here so `@carbon/ee` never imports `~/`).
type ApiKeyInput = { name: string };
export async function upsertApiKey(
client: SupabaseClient<Database>,
apiKey:
| (ApiKeyInput & {
createdBy: string;
companyId: string;
scopes: Record<string, string[]>;
expiresAt?: string;
rawKey: string;
keyHash: string;
keyPreview: string;
})
| (ApiKeyInput & {
id: string;
scopes: Record<string, string[]>;
expiresAt?: string;
})
) {
if ("createdBy" in apiKey) {
await requireEntitlement(client, apiKey.companyId, "API_KEYS");
// Create: store the hash, return the raw key (caller generates both)
// Strip rateLimit/rateLimitWindow — these are platform-controlled, not user-configurable
const {
scopes,
expiresAt,
rawKey,
keyHash,
rateLimit: _rl,
rateLimitWindow: _rlw,
...rest
} = apiKey as any;
const result = await client
.from("apiKey")
.insert(
sanitize({
...rest,
keyHash,
scopes: scopes as any,
expiresAt: expiresAt || null
}) as any
)
.select("id")
.single();
if (result.error) {
return { data: null, error: result.error };
}
// Return the raw key (shown to user once, never stored)
return { data: { key: rawKey, id: result.data.id }, error: null };
}
// The update input carries no companyId — read it from the row so the
// entitlement check (the lock) can run before the write.
const existing = await client
.from("apiKey")
.select("companyId")
.eq("id", apiKey.id)
.single();
if (existing.error || !existing.data) {
return {
data: null,
error: existing.error || { message: "API key not found" }
};
}
await requireEntitlement(client, existing.data.companyId, "API_KEYS");
// Update: update name, scopes, expiration (never the key itself)
// Strip rateLimit/rateLimitWindow — these are platform-controlled, not user-configurable
const {
scopes,
expiresAt,
rateLimit: _rl,
rateLimitWindow: _rlw,
...rest
} = apiKey as any;
return client
.from("apiKey")
.update(
sanitize({
...rest,
scopes: scopes as any,
expiresAt: expiresAt || null
}) as any
)
.eq("id", apiKey.id);
}
export async function deleteApiKey(
client: SupabaseClient<Database>,
id: string
) {
// The input carries no companyId — read it from the row so the entitlement
// check (the lock) can run before the delete.
const existing = await client
.from("apiKey")
.select("companyId")
.eq("id", id)
.single();
if (existing.error || !existing.data) {
return {
data: null,
error: existing.error || { message: "API key not found" }
};
}
await requireEntitlement(client, existing.data.companyId, "API_KEYS");
return client.from("apiKey").delete().eq("id", id);
}