格式化与代码
JSON 转 Drizzle ORM Schema
Drizzle pgTable definition with $inferSelect / $inferInsert.
Runs in your browser
编辑注
Understanding · A schema that's also a value.
本深度章节目前仅有英文版本。上方的转换工具支持您的语言;长篇说明文章尚未翻译。
常见问题
Quick answers.
›How are column types determined?
The generator maps JSON primitives to PostgreSQL types. Strings are mapped to `text`, numbers to `integer` or `numeric`, and booleans to `boolean`.
›Does it support nested objects?
JSON columns are defined using the `jsonb` type. For relational structures, you should define separate tables and establish foreign keys manually.
›Is the output compatible with TypeScript?
Yes. The generated code includes `InferSelectModel` and `InferInsertModel` types to provide full type-safety for your database queries.
›Are my data structures shared with a server?
No. The transformation happens entirely within your browser's memory, so your private schema designs are never transmitted or stored.
大家也在搜索
相关工具
More in this room.
- JSON 转 React Hook Form + Zod根据 JSON 结构生成类型化的表单 schema 和 useForm hook。
- JSON 转 Next.js Server Action带有 Zod 解析和 revalidatePath 的 Server Action。
- JSON 转 Prisma Schema Model从 JSON 示例生成 Prisma 模型块。
- JSON 转 TypeORM Entity带有装饰器和生成的 id 的 TypeORM @Entity 类。
- JSON 转 Mongoose Schema + Model带有时间戳和类型的 Mongoose Schema + 模型。
- JSON 转 tRPC Router带有 Zod 输入的 tRPC 路由支架 — 列表、byId、创建。