Database provider

Add @id field Add createdAt/updatedAt Add field comments Make all fields optional Generate relations

Model name:

Drop JSON file here

Features

◮ Type-Safe Database Models

Automatic Prisma type inference
Support for all Prisma scalar types
Compatible with Prisma Client
Full TypeScript integration

🗄️ Multi-Database Support

PostgreSQL, MySQL, SQLite
MongoDB, SQL Server
Database-specific types
Native type attributes

🔗 Smart Relations

Auto-detect nested objects as relations
One-to-one, one-to-many relations
Foreign key generation
Relation attributes

Complete Guide to Prisma Schemas

What is Prisma?

Prisma is a next-generation Node.js and TypeScript ORM that provides type-safe database access with auto-generated queries. It consists of Prisma Client (query builder), Prisma Migrate (migrations), and Prisma Studio (GUI). Prisma schema files (.prisma) define your database models, relations, and generate the Prisma Client for type-safe database operations.

Why Use Prisma?

Type Safety: Auto-generated TypeScript types from your schema
Productivity: Intuitive data modeling with declarative schema
Database Agnostic: Works with PostgreSQL, MySQL, SQLite, MongoDB, SQL Server
Migrations: Automatic migration generation and version control
Relations: Easy-to-define relations with automatic foreign keys

Using Generated Prisma Schemas

// 1. Add generated schema to prisma/schema.prisma
// 2. Run migrations
npx prisma migrate dev --name init

// 3. Generate Prisma Client
npx prisma generate

// 4. Use in your code
import { PrismaClient } from '@prisma/client'
const prisma = new PrismaClient()

// Create a user
const user = await prisma.user.create({
  data: {
    email: 'john@example.com',
    name: 'John Doe',
    profile: {
      create: { bio: 'Developer' }
    }
  },
  include: { profile: true }
})

// Query with relations
const users = await prisma.user.findMany({
  include: { posts: true, profile: true }
})

Common Use Cases

API Development: Type-safe database queries in REST or GraphQL APIs
Next.js Apps: Server-side database access with full TypeScript support
Rapid Prototyping: Quickly scaffold database models from JSON data
Database Migrations: Version-controlled schema changes
Full-Stack Apps: Shared types between backend and frontend
Microservices: Consistent data models across services

FAQ

Q: How does this detect field types?

A: The generator analyzes JSON values to infer Prisma types. Strings become String, numbers become Int or Float, booleans become Boolean, and ISO dates become DateTime.

Q: How are nested objects handled?

A: Nested objects are converted to separate models with relations. Arrays of objects create one-to-many relations, single objects create one-to-one relations.

Q: Can I customize the generated schema?

A: Yes! The generated schema is a starting point. Add @unique, @default, indexes, and modify types as needed for your use case.

From generated schema to a working database

A Prisma schema generated from JSON gets the fields and types in place quickly. The next steps are the decisions only you can make: identifiers, indexes, relations and how the schema will change over time.

Tips and common pitfalls

Pick a primary key strategy up front, such as @id @default(cuid()) or an autoincrementing integer.
Add @unique to fields like email or slug and @@index for columns you filter on often.
Run npx prisma migrate dev --name init to create the first migration, then commit the migrations folder.
For flexible nested data you do not query by, a Json column can be simpler than extra tables.

JSON to Prisma Schema