SQL to GORM

Convert SQL CREATE TABLE statements to Go GORM model structs.

Options

Package Name:

GORM TagJSON Tag

Input SQL (CREATE TABLE statement)

CREATE TABLE users (
  id INT PRIMARY KEY AUTO_INCREMENT,
  username VARCHAR(255) NOT NULL,
  email VARCHAR(255) UNIQUE NOT NULL,
  is_active BOOLEAN DEFAULT TRUE,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE users (
  id INT PRIMARY KEY AUTO_INCREMENT,
  username VARCHAR(255) NOT NULL,
  email VARCHAR(255) UNIQUE NOT NULL,
  is_active BOOLEAN DEFAULT TRUE,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

GORM Struct

// Generated struct will appear here...

About

Automatically convert SQL CREATE TABLE statements into Go GORM model structs. Supports custom tags and field mapping, significantly improving Go backend development efficiency.

Key Features

Automatic type mapping
CamelCase conversion
Custom GORM/JSON Tags
Supports common SQL types

How to use

1Enter or select the supported input.
2Choose the available settings and run the tool.
3Review the result, then copy or download it.

Example

Input

CREATE TABLE users (id BIGINT PRIMARY KEY, name VARCHAR(255));

Output

type Users struct {
    Id int64
    Name string
}

Limitations

The parser supports common CREATE TABLE columns and constraints. Review generated Go types, defaults, and tags before use.
Processing happens locally in your browser. Tool input is not uploaded to ToolHub.

Last reviewed: 2026-07-27

Related Tools