check out the below.
http://www.techguys.ca/howto/index.html
Miata owners typically replace the transmission fluid with 2 quarts of MTL Redline Synthetic Gear Oil.
To change the transmission fluid on a 1991 Mazda Miata, first, ensure the vehicle is on a level surface and secure it with jack stands. Remove the transmission drain plug to drain the old fluid completely, then replace the plug and torque it to the specified setting. Next, remove the fill plug and use a funnel to add new transmission fluid, ensuring you use the correct type specified in the owner's manual. Finally, check the fluid level and replace the fill plug securely.
Fill the transmission filter with transmission fluid before you put the new transmission filter on. You probably will not need to add any transmission fluid.
In a 2006 Mazda Miata, the transmission fluid dipstick is located on the driver's side of the engine bay, near the back of the engine. It is typically found near the transmission itself, often with a yellow or colored handle for easy identification. If you're having trouble locating it, refer to the owner's manual for a visual guide.
automatic has a dipstick under the hood. manual should have a plug on the side of it.
The 2008 Mazda MX-5-Miata has a 5-speed manual.
The 2011 Mazda MX-5-Miata has a 5-speed manual.
The 2006 Mazda MX-5-Miata has a 5-speed manual.
The 2012 Mazda MX-5-Miata has a 5-speed manual.
The 2003 Mazda MX-5-Miata has a 5-speed manual.
The 2009 Mazda MX-5-Miata has a 5-speed manual.
The 2005 Mazda MX-5-Miata has a 5-speed manual.