RCE Designer
ReKnew Context Engine
Paste or upload a SQL schema to generate an interactive, editable entity-relationship diagram.
Your name
Your email
Required so comments you post can be attributed to you, and so you show up in the project's collaborators list. Remembered on this device.
Resume
Dismiss
Project title
SQL schema (CREATE TABLE / ALTER TABLE DDL)
Generate diagram
Upload .sql file
Load example schema
or
Open saved project (.rce.json)
New project…
Open project…
Save project
Export SVG
Export PNG
Export SQL
$refs.titleEditInput.focus())" title="Click to rename">
Home
Diagrams
Entities
Relationships
Activity
Sources
Tags
✕
Export SVG
Export PNG
Export SQL
Entities
Relationships
Tags
Sources
Workflow progress
Model Health
No entities in this model.
Orphan tables
Hub entities (top 5)
Missing PK
Unnamed columns
Tag Breakdown
No tags yet — add one from an entity's detail view.
No entities in this model.
Workflow progress
Entity status per stage. Set statuses in the Entities tab; click a row to open it.
Status
Any
Scope (tag)
All
Entity
Rollup
No matching entities.
Entities (
)
−
Fit
+
Primary key
Foreign key
Many
One
Drag background to pan · scroll to zoom · drag an entity's header to reposition it
+ Add entity
No entities yet.
Select an entity from the list to see its columns and relationships.
Schema comment
✕
Add
Data owner
Source systems
✕
Add
Workflow stages
Track this entity on the Home progress grid
Not tracked: workflow stages are hidden for this entity (tick the box to bring them back).
Set a stage per property
None
Column
Type
Source system
Source field
Description
Transformation Rules
PK
NN
✕
+ Add column
Relationships (
)
Comments (
)
✕
No comments yet.
Post
Delete entity
+ Add Relationship
No foreign-key relationships were found.
New relationship
From entity
From column
To entity
To column
Constraint name (optional)
Cancel
Create relationship
Select a relationship from the list for details.
From
.
To
.
Cardinality
N : 1
1 : 1
· manually set
View both tables in the Diagrams tab →
Delete relationship
No comments yet — add one from an entity’s detail view (Diagrams or Entities tab).
Name
Owner / contact
Description
Documentation URL
Status
Used by (
)
Name
Color
Tagged entities (
)
Not applied to any entity yet.
Highlight in the Diagrams tab →