Question 1

How do I convert SQL to a Go struct?

Accepted Answer

Paste your CREATE TABLE statement and the tool parses every column, maps the SQL type to a Go type (int, int64, float64, bool, string, time.Time, sql.NullString) and emits a Go struct definition. Optionally it appends GORM or sqlx struct tags.

Question 2

Which SQL types are mapped to which Go types?

Accepted Answer

TINYINT/SMALLINT map to int16 or int; INT/INTEGER map to int32 or int; BIGINT/SERIAL map to int64; DECIMAL/NUMERIC/FLOAT/DOUBLE/REAL map to float64; BOOL/BIT map to bool; DATE/DATETIME/TIMESTAMP/TIME map to time.Time; CHAR/VARCHAR/TEXT/JSON/UUID/ENUM map to string; BLOB/BINARY/BYTEA map to []byte.

Question 3

Does it generate GORM or sqlx struct tags?

Accepted Answer

Yes. Pick the GORM style to get gorm:"column:email;type:varchar(255);not null" tags, the sqlx style to get db:"email" tags, or choose None for a plain struct with no tags.

Question 4

Is my SQL uploaded to a server?

Accepted Answer

No. All parsing and code generation run entirely in your browser. Your SQL never leaves your device.