Paste a CREATE TABLE statement and get the equivalent Prisma or Drizzle schema.

}

function escapeHtml(s) { return s.replace(/&/g,’&‘).replace(/</g,’<‘).replace(/>/g,’>’); }

Supported types

PostgreSQL types mapped to both Prisma and Drizzle: serial, integer, bigint, text, varchar(n), boolean, timestamp, date, float, numeric, json, jsonb, uuid.

Limitations

• Handles standard CREATE TABLE syntax (PostgreSQL-flavored)
• Foreign keys and relations need manual adjustment
• Complex defaults or expressions may need tweaking
• MySQL-specific types may not map perfectly

Related resources

• SQL cheat sheet
• Prisma cheat sheet