Getting Started

Your first schema in 5 minutes

Relmic is a collaborative visual database schema design tool that lets you design, visualize, and export schemas for 8 database management systems. This guide walks you through creating your first project.

What is Relmic?

Relmic is a web-based tool for designing database schemas visually. Instead of writing CREATE TABLE statements by hand, you drag and drop tables onto an infinite canvas, configure columns with a property panel, and draw relationships between tables. When you are done, Relmic generates production-ready code in over 12 formats.

Relmic supports PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, Oracle, BigQuery, and Redshift. Each DBMS has its own data types, constraints, and validation rules built in, so the code you export is always correct for your target system.

Create your account

Relmic runs entirely in the browser — there is nothing to install. Head to app.relmic.com and sign up with Google, GitHub, or Microsoft. Your Free plan includes one project with up to 4 tables, which is enough to follow this guide.

Create a project

After signing in, click New Project on your dashboard. You will be asked to:

  1. Name your project — pick something descriptive like “Blog API” or “E-commerce Database”.
  2. Choose a DBMS — this determines available data types, default expressions, and validation rules. You can change it later.
  3. Choose the DBMS version — Relmic tailors data types and features to the specific version you select, so the generated code matches your target environment.

After clicking Create, you will land on the visual editor canvas — an empty infinite canvas ready for your first table.

Add tables and columns

Adding a table

Double-click anywhere on the canvas (or use the toolbar button) to add a new table. Give it a name — for example, users. The table appears as a card on the canvas that you can drag to reposition.

Adding columns

Click on a table to select it, then use the column editor panel to add columns. For each column you can configure:

  • Name — the column identifier (e.g., email)
  • Type — data type with DBMS-aware autocomplete (e.g., VARCHAR(255))
  • Constraints — primary key, not null, unique, etc.
  • Default value — with smart suggestions based on column type

Smart Autocomplete

When you select a column type, Relmic automatically suggests relevant default expressions. For example, a uuid column suggests gen_random_uuid(), while a timestamp column suggests now().

Draw relationships

Relationships represent foreign key constraints between tables. To create a relationship, drag from one column to another — Relmic draws a connecting line and automatically creates the foreign key constraint.

Relmic supports standard relationship types:

  • One-to-many — a user has many posts
  • One-to-one — a user has one profile
  • Many-to-many — modeled through a junction table with two foreign keys

Export your schema

Once your schema is ready, open the export panel to generate code. Relmic supports over 12 formats:

  • SQL DDL for all 8 supported DBMS
  • Prisma Schema and Drizzle ORM
  • TypeScript interfaces and JSON Schema
  • SQLAlchemy models
  • PNG and PDF for documentation

Read the Forward Engineering guide for a detailed walkthrough of each format.

Next steps

NextVisual Editor