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
CREATE OR REPLACE FUNCTION public.get_api_key_scopes()
RETURNS jsonb
LANGUAGE plpgsql
SECURITY DEFINER
SET search_path TO 'public', 'extensions'
AS $function$
DECLARE
scopes JSONB;
raw_key TEXT;
BEGIN
raw_key := (current_setting('request.headers'::text, true))::json ->> 'carbon-key';
IF raw_key IS NULL THEN
RETURN NULL;
END IF;
SELECT "apiKey"."scopes" INTO scopes
FROM "apiKey"
WHERE "keyHash" = encode(digest(raw_key::bytea, 'sha256'::text), 'hex')
AND ("expiresAt" IS NULL OR "expiresAt" > NOW());
RETURN scopes;
END;
$function$;