This is a template to start your project with MySQL, Drizzle, tRPC and zod. Check Drizzle docs if you want to implement different database.

Steps:

• Create .env file and insert db connection info (check .env.example)
• Replace example schema with your schema inside of /src/db/schema.ts
• Generate migration files with npm run drizzle:generate (they will appear in /src/db/migrations)
• Push your schema with npm run drizzle:push
• Replace example procedures with your own inside of /src/server/index.ts
• Modify queries/mutations in example components to test connection (or just delete them)

To pull schema from existing db you can run npm run drizzle:introspect

Be aware of config files while changing file structure ❗