💡 100 AI Prompts Every Java & Spring Developer in India Should Try to Boost Productivity -3

🗃️ SQL & Database Tricks 21. Improve this slow SQL query: [paste query]. 22. What’s the right indexing strategy for large data tables? 23. Sample Java class using JPA to fetch data from PostgreSQL. 24. Explain INNER JOIN vs LEFT JOIN with examples. 25. How to give performance hints to PostgreSQL queries? 26. Show how to use projections in Spring Data JPA. 27. How to do batch inserts with JPA efficiently? 28. What tool should I use for DB schema versioning in Spring Boot? 29. Can I reuse native SQL queries in Spring Data? How? 30. Steps to debug and fix slow DB queries in a Spring Boot app. ⸻ 🚀 DevOps & CI/CD for Java Projects 31. Create a GitHub Actions workflow for building and testing Spring Boot code. 32. Best practices for Dockerizing a Java app. 33. How to monitor Java app metrics in Kubernetes using Prometheus? 34. Write a Jenkins pipeline for a Maven-based Java project. 35. What’s the secure way to handle secrets in pipelines? 36. How to roll back a Spring Boot deployment in Kubernetes? 37. Write a basic Helm chart to deploy a Spring Boot service. 38. Explain blue-green deployments for Java microservices. 39. Use Ansible to set up a Java environment on Ubuntu. 40. How to speed up builds by caching Maven dependencies in CI? ⸻