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 is a Project?

A project in PicaDeck represents a single database schema. It is the container that holds all your tables, columns, relationships, custom types, and (if git mode is enabled) branches and commits.

Each project is tied to a specific database type — PostgreSQL, MySQL, or MongoDB — which determines the available data types and the format of exported migrations.

Projects belong to an organization and can be shared with team members who have appropriate access levels.

Creating a Project

To create a new project, click the New Project button on your Projects dashboard. You will need to provide:

Field	Required	Description
Name	Yes	A descriptive name for your project (e.g., "E-commerce API")
Description	No	Optional summary of what the database is for
Database Type	Yes	PostgreSQL, MySQL, or MongoDB
Git Mode	No	Enable version control (Pro/Team plans only)

Note

The free plan allows up to 3 projects per organization. Upgrade to Pro or Team for unlimited projects.

Project Settings

Access project settings by clicking the settings icon on the project details page. Here you can:

Rename the project — update the display name at any time
Update the description — keep your team informed about the project's purpose
Change database type — switch between PostgreSQL, MySQL, and MongoDB. Note that some data type mappings may not translate perfectly between databases

Danger Zone

At the bottom of project settings, you will find the Danger Zone where you can permanently delete the project. This removes all schemas, branches, commits, and team access. This action cannot be undone.

Managing Team Members

You can invite team members to your project and assign them different access levels:

Role	Permissions
Admin	Full access: edit schema, manage branches, change settings, manage members
Edit	Edit the schema and create branches. Cannot change project settings or manage members
View	Read-only access to view the schema. Cannot make any changes

To add a member, go to the project's team settings and enter their email address. They will receive an invitation to join the project.

Favorite Projects

Star a project to add it to your Favorites section in the dashboard sidebar. This gives you one-click access to the projects you work on most frequently.

To favorite a project, click the star icon on the project card or in the project header. Favorited projects appear in the sidebar below the main navigation items.

Deleting a Project

To delete a project, go to Project Settings and scroll to the Danger Zone. You will be asked to confirm by typing the project name. Deletion permanently removes:

All tables, columns, relationships, and custom types
All branches and commits (if git mode was enabled)
All pull requests and reviews
All team member access

Warning

Project deletion is permanent and cannot be undone. Make sure to export any important migrations before deleting.