nextauthjs/next-auth ? reverse-engineered prompt

I need you to build a comprehensive authentication system for my web app. It should be flexible enough to work with any modern JavaScript framework—I'm looking at Next.js, SvelteKit, or maybe even Remix.

I want users to have a few ways to sign in. Give them the option for a traditional email and password, but also support passwordless logins, and social sign-in through popular providers like Google, GitHub, and Twitter. Security is a top priority, so it needs to be secure by default, handling things like session management and CSRF protection automatically.

Finally, I want to own my data. Build it so I can connect it to my own database, like Postgres or MongoDB, but also include an option to run without a database for simpler setups. Essentially, a full-featured, secure authentication solution for the modern web.