MySQL as the database for your SaaS

Already running MySQL? ShipAny ships a dedicated MySQL schema template, so you can use your existing MySQL 5.7+ server or a managed service without converting anything to Postgres.

What ShipAny handles

• A MySQL schema for every built-in table, with typed models via Drizzle.
• Development and production workflows: db:push locally, db:generate + db:migrate for reviewable migrations.
• Hyperdrive support on Cloudflare Workers: the MySQL driver also reads its connection from the HYPERDRIVE binding.

Setup

1. Create a database and user with full privileges on it.
2. Set the environment:

DATABASE_PROVIDER=mysql
DATABASE_URL=<your-mysql-connection-string>   # mysql://… on port 3306

3. Copy the MySQL schema template and create the tables with pnpm db:setup and pnpm db:push (or generate and run migrations for production).
4. Seed roles and permissions with pnpm rbac:init.

Tips

• Use MySQL 5.7 or later with a UTF-8 (utf8mb4) default character set so emoji and CJK text store correctly.
• Review generated migrations before production — column changes in MySQL can lock large tables.