SQL to Go Struct Converter
Paste your CREATE TABLE statements to instantly generate idiomatic Go struct definitions with customizable naming rules.
SQL to Go Struct Converter
Paste your CREATE TABLE statements to instantly generate idiomatic Go struct definitions with customizable naming rules.
About the SQL DDL to Go struct converter
Generate structs from CREATE TABLE statements
The converter scans CREATE TABLE statements, strips SQL comments, skips table-level constraints, and maps each column into an exported Go field. Multiple tables can produce multiple struct definitions in one output.
FAQ
Common questions and answers about this topic.
Which database dialects are supported?
The converter supports common CREATE TABLE syntax from MySQL, PostgreSQL, SQLite, and SQL Server. It maps frequently used column types such as VARCHAR, INT, BIGINT, TIMESTAMP, BOOLEAN, TEXT, JSON, UUID, and binary types to practical Go equivalents.
Can I customize the column naming style?
Yes. The column name style option can auto-detect names or parse them as snake_case, camelCase, PascalCase, or kebab-case before producing exported Go field names with common initialisms such as ID, JSON, URL, and SQL preserved.
Can I customize the JSON tag style?
Yes, for json tags. You can generate json tags in snake_case, camelCase, PascalCase, kebab-case, lowercase, UPPER_SNAKE_CASE, preserve the original column name, or disable json tags entirely. The current converter does not generate db or gorm tags.
Is my data sent to any server?
No, the SQL DDL to Go struct conversion takes place entirely within your browser. Your SQL schema definitions are parsed locally via JavaScript and never leave your device.