DDL Translation

DDL Translation

AI-powered DDL conversion with automatic type mapping, naming convention normalization, and foreign key resolution.

Request an Assessment
Expert-led delivery·Self-service available
Oracle (Source)
CREATE TABLE TBL_USR_ACC_99 (
  USR_ID        NUMBER(10) PRIMARY KEY,
  NM_FULL       VARCHAR2(255) NOT NULL,
  DT_CREAT      DATE DEFAULT SYSDATE,
  EMAIL_ADDR    VARCHAR2(100),
  ST_ATIVO      CHAR(1) DEFAULT 'S'
);
Prisma (Target)
model UserAccount {
  id        Int      @id @default(autoincrement())
  fullName  String   @db.VarChar(255)
  createdAt DateTime @default(now()) @db.DateTime
  email     String?  @db.VarChar(100)
  isActive  Boolean  @default(true)

  @@map("user_account")
}
Agent handles: naming, types, defaults, constraints, indexes

What the Agent translates automatically

Every dialect nuance handled. You review, you approve.

Data Types

NUMBER(p,s) → Decimal/Int, VARCHAR2 → String/Text, DATE → DateTime, CLOB/BLOB → Text/Bytes

Naming Conventions

SCREAMING_SNAKE_CASE → camelCase/PascalCase, prefix stripping (TBL_, COL_), pluralization

Constraints & Indexes

PK, FK, UK, CHECK, NOT NULL preserved. Composite indexes, partial indexes, included columns

Dialect-Specific Features

Oracle sequences → Identity/Serial, SQL Server IDENTITY → autoincrement, MySQL ENUM → String + CHECK

ORM-Specific Output

Prisma: @id, @default, @relation, @db.Text; TypeORM: @PrimaryColumn, @CreateDateColumn, @ManyToOne

Custom Transform Rules

Regex-based renaming rules applied during translation. Team-shared, versioned, reusable across projects

Supported source → target combinations

Oracle
Prisma
Oracle
TypeORM
Oracle
PostgreSQL
SQL Server
Prisma
SQL Server
TypeORM
SQL Server
PostgreSQL
MySQL
Prisma
MySQL
TypeORM
MySQL
PostgreSQL
PostgreSQL
Prisma
PostgreSQL
TypeORM
PostgreSQL
MySQL

See the translation in action

Start a 14-day pilot. Paste your DDL, get production-ready schemas in minutes.

Request an Assessment