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.assert_company_access(p_company_id text, p_permission text DEFAULT NULL::text)
RETURNS void
LANGUAGE plpgsql
STABLE SECURITY DEFINER
SET search_path TO 'public'
AS $function$
BEGIN
-- service_role, and direct connections (jobs, Kysely, edge functions) are already trusted.
IF current_setting('role', true) NOT IN ('anon', 'authenticated') THEN
RETURN;
END IF;
IF p_company_id = ANY (
CASE WHEN p_permission IS NULL
THEN get_companies_with_employee_role()
ELSE get_companies_with_employee_permission(p_permission)
END
) THEN
RETURN;
END IF;
RAISE EXCEPTION 'Not authorized for this company'
USING ERRCODE = 'insufficient_privilege';
END;
$function$;