What databases does PicaDeck support?

PicaDeck supports PostgreSQL, MySQL, and MongoDB out of the box. You can design your schema once and export migrations for any of these databases.

How does real-time collaboration work?

Multiple team members can work on the same schema simultaneously. You'll see live cursors showing where teammates are working, and changes sync instantly across all connected clients.

Can I import my existing database schema?

Yes! You can import schemas by uploading SQL files, Prisma schemas, or JSON schema files. PicaDeck will automatically visualize your tables, relationships, and indexes.

What migration formats can PicaDeck generate?

PicaDeck generates raw SQL migrations for PostgreSQL and MySQL, Prisma schemas for all databases, and MongoDB native scripts.

All data is encrypted in transit and at rest. We never store your actual database credentials or production data — only the schema definitions.

How does version control for schemas work?

Just like Git for code, you can create branches for experimental changes, commit schema versions with messages, and merge branches after review. Every change is tracked.

Documentation — Guides, Tutorials & API Reference

What Are Migrations?

Migrations are the bridge between your visual schema design and your actual database. While PicaDeck lets you design your schema visually, migrations are the executable scripts that create or modify your database tables, columns, indexes, and relationships.

PicaDeck generates migrations automatically based on your current schema state. You do not need to write any SQL or configuration by hand — just design visually and export.

Generating a Migration

To generate a migration from your schema:

Open your project and navigate to the Migrations tab
Click the Generate Migration button
Select the source and target branches to compare
Review the generated output
Copy to clipboard or download as a file

Note

Migrations are generated from the current committed state of the branch (or the current auto-saved state in free mode). Make sure to commit your changes before generating a migration in git mode.

SQL Migrations

SQL migrations generate standard DDL (Data Definition Language) statements compatible with your project's database type.

PostgreSQL

PostgreSQL exports include:

CREATE TABLE statements with all columns, types, and constraints
ALTER TABLE for foreign key relationships
CREATE TYPE for custom enum and composite types
CREATE INDEX for indexed columns
Column defaults, NOT NULL constraints, UNIQUE constraints

MySQL

MySQL exports use MySQL-specific syntax including:

CREATE TABLE with MySQL-compatible data types (INT, VARCHAR, etc.)
Inline ENUM definitions (MySQL supports ENUM as a column type)
ENGINE=InnoDB for tables with foreign key support
Foreign key constraints with ON DELETE and ON UPDATE clauses

Prisma Schema Export

The Prisma export generates a complete schema.prisma file compatible with the Prisma ORM. This includes:

Model definitions — each table becomes a Prisma model with field names, types, and attributes
Relation annotations — foreign key relationships are expressed using Prisma's @relation syntax
Enum definitions — custom enums are exported as Prisma enums
Field attributes — @id, @unique, @default, @map, ? for optional fields
Datasource and generator blocks — configured for your project's database type

Using the Prisma output

Copy the generated schema into your project's prisma/schema.prisma file, then run npx prisma migrate dev to apply it to your database.

MongoDB Scripts

For MongoDB projects, PicaDeck generates JavaScript scripts compatible with the MongoDB shell. These include:

db.createCollection() commands for each table
JSON Schema validation rules based on your column types and constraints
createIndex() commands for indexed fields
Unique index definitions for columns marked as unique

Note

MongoDB is schema-less by nature, but PicaDeck generates validation schemas that enforce your designed structure at the database level, giving you the best of both worlds.

Downloading & Copying

After generating a migration, you have two options:

Copy to clipboard — click the copy button to copy the entire migration script. Paste it directly into your terminal, migration file, or version control
Download as file — download the migration as a .sql, .prisma, or .js file that you can add directly to your project

What Are Migrations?

PicaDeck generates migrations automatically based on your current schema state. You do not need to write any SQL or configuration by hand — just design visually and export.

Generating a Migration

To generate a migration from your schema:

Open your project and navigate to the Migrations tab
Click the Generate Migration button
Select the source and target branches to compare
Review the generated output
Copy to clipboard or download as a file

Note

Migrations are generated from the current committed state of the branch (or the current auto-saved state in free mode). Make sure to commit your changes before generating a migration in git mode.

SQL Migrations

SQL migrations generate standard DDL (Data Definition Language) statements compatible with your project's database type.

PostgreSQL

PostgreSQL exports include:

CREATE TABLE statements with all columns, types, and constraints
ALTER TABLE for foreign key relationships
CREATE TYPE for custom enum and composite types
CREATE INDEX for indexed columns
Column defaults, NOT NULL constraints, UNIQUE constraints

MySQL

MySQL exports use MySQL-specific syntax including:

CREATE TABLE with MySQL-compatible data types (INT, VARCHAR, etc.)
Inline ENUM definitions (MySQL supports ENUM as a column type)
ENGINE=InnoDB for tables with foreign key support
Foreign key constraints with ON DELETE and ON UPDATE clauses

Prisma Schema Export

The Prisma export generates a complete schema.prisma file compatible with the Prisma ORM. This includes:

Model definitions — each table becomes a Prisma model with field names, types, and attributes
Relation annotations — foreign key relationships are expressed using Prisma's @relation syntax
Enum definitions — custom enums are exported as Prisma enums
Field attributes — @id, @unique, @default, @map, ? for optional fields
Datasource and generator blocks — configured for your project's database type

Using the Prisma output

Copy the generated schema into your project's prisma/schema.prisma file, then run npx prisma migrate dev to apply it to your database.

MongoDB Scripts

For MongoDB projects, PicaDeck generates JavaScript scripts compatible with the MongoDB shell. These include:

db.createCollection() commands for each table
JSON Schema validation rules based on your column types and constraints
createIndex() commands for indexed fields
Unique index definitions for columns marked as unique

Note

MongoDB is schema-less by nature, but PicaDeck generates validation schemas that enforce your designed structure at the database level, giving you the best of both worlds.

Downloading & Copying

After generating a migration, you have two options:

Copy to clipboard — click the copy button to copy the entire migration script. Paste it directly into your terminal, migration file, or version control
Download as file — download the migration as a .sql, .prisma, or .js file that you can add directly to your project