Next.js UI Revamp & Database Hookup

I have a Next.js site that is already partially functional on the front end, but it still needs a solid MySQL connection and a visual polish before launch.

Here is what I need over the next few days:

• Set up and test the full CRUD flow between the existing components and a MySQL database, using either Prisma, Sequelize, or bare SQL—whatever you are most comfortable with, provided it is production-ready and easy for me to maintain.
• Refine the color scheme, adjust typography for readability and brand consistency, and tidy up the layout structure so every page looks cohesive on desktop and mobile.
• Optimise for performance (code-splitting, image handling, Lighthouse basics) and ensure the build deploys cleanly on Vercel.
• Leave clear comments or a short README so I can extend the project after hand-off.

Acceptance criteria: pages render without style glitches, all database reads/writes succeed, no console errors in production build, and the site scores 90+ on Lighthouse for performance and accessibility.

If this sounds straightforward for you, let’s get started—I’m ready to merge your pull request as soon as it checks every box above.