Is there a way in Laravel to bulk-insert multiple records and get Eloquent models returned?

[LemanAmrahova]

Hi everyone,
I have a scenario where I need to insert multiple records at once.

I want to achieve all three:

1. Bulk insert multiple records at once (performance).
2. Return Eloquent model instances for the inserted records.

One approach I thought of:

• Add created_at manually to each record
• Use insert() for speed
• Immediately filter the table by that created_at value to return the inserted records

This works, but feels hardcoded, and I wonder if there’s a better or built-in Laravel way in Eloquent to do this. Or can be added in the future...

[macropay-solutions]

The mass insert will not return the pks so that you can retrieve them by pk afterwards.
If you want events for each why do you want mass insert?

[LemanAmrahova]

Yes, I understand that insert doesn't return primary keys and doesn't trigger model events. Thanks for pointing that out. I thought about it and I’ll update my question that I don’t need events, because data is just a historical log. If I needed events or PKs, I would use create() in a loop, but for my scenario, mass insert is the most efficient approach.
Additionally, the Java gateway calls my API as a client, and they need the created models returned, which is why I’m looking for a way to retrieve them after the bulk insert.

[handyman911us-ctrl]

A couple of solutions from ChatGPT. While I don't have a need for this solution yet, I will in one of my next major App Enhancements.

https://chatgpt.com/share/69010a68-9b4c-8007-9f12-e329b195dd45

[shaedrich]

People can use ChatGPT themselves if they want to. No need to spam untested "solutions".

[Sandalanka]

Hi I understood your question. if you want to insert multiple records with one request(one time).
I have Laravel using several solution for multiple insert:

1. Laravel queue using task running background.
2. if you upload data using excel file like that you can chunk upload
3. if you want to speed insert multiple data you can parallel works run Laravel horizon using
   https://github.com/Sandalanka/Payment-Notification-Payout-System
   this is my repo multiple data insert with upload excel using. i think it's helpful to you

Thank you