<p>The hydrostatic turntable is a crucial support equipment for CNC machine tools. Given the complexity of hydrostatic turntables, which involves multiple disciplines such as hydromechanics, elastic mechanics, thermodynamics. Significant challenges are posed in their design and optimization. It is widely known that hydrostatic turntables can be intelligently designed and optimized by utilizing cloud and Internet of Things (IoTs) technology. This study proposes an intelligent design and optimization system for hydrostatic turntables based on the cloud and IoTs technology. It provides a platform for data processing, transmission, and analysis for manufacturers, designers, and factories. According to the actual requirements of the factory, the designer uses the finite difference method (FDM) and the improved particle swarm optimization (IPSO) algorithm to analyze and optimize the bearing parameters, and sends the results to the manufacturer for processing. Product test data from the factory can be further fed back to designers for performance evaluation through cloud and IoTs technology. Finally, the design and optimization of a hydrostatic turntable are taken as an example to confirm the effectiveness of the system. </p>