The basic issue is that once the car is warmed up it just will not idle at all. I can put the car in neutral and watch the tachometer go down until the car dies every time, I can start the car right back up. All lights stay on the entire time.

Issues that led up to this:
Flooded the car and then had Mazda deflood it, they replaced the spark plugs when they deflooded it. While there I had to have the engine mounts replaced, MSP16 done against it, and had a compression test since it was nearing 90k miles, this came back as Rotor 1: 1 7.4 KGF.CM2 2 8.4 KGF.CM2 3 7.5 KGF.CM2 Rotor 2: 1 8.1 KGF.CM2 2 8.1 KGF.CM2 3 8.2 KGF.CM2.

While actually driving the car there seems to be no issues that I notice and no check engine lights come on until after the car dies, which it goes away if you start the car back up. I currently plan on taking it over to autozone to get the error code off the car once it dies to see it gives me anything.

:edit

also can red line the car and have no problems doing it, at least in first gear.

 

Yes get the codes. How many miles on coils and wires? Have you cleaned the MAF sensor? What mods do you have? What service has the car had? Have you done a de-carbon cleaning?

 

maybe 10k miles on the coils and wires. Haven't cleaned the MAF sensor. everything is stock. Service has just been the regular maintenance per owners manual and replacement of water pump. I have not done a de-carbon cleaning (but planned on doing that once everything was running right again).

 

7.4 is kinda low on the compression side.

 

The dealer should have done the de-carbon cleaning before the compression test....