SQL Data Type Suggester

INT: For integer numbers.
FLOAT: For non-integer numbers.
VARCHAR(n): For strings, where n is the length of the string plus a buffer of 10 characters.
DATETIME: For strings that can be parsed into a date.
BOOLEAN: For boolean values.
NULL: For null values. Note: Actual implementation might require a specific data type based on the use case.
TEXT: For objects, arrays, or other complex structures.

Working with webhooks, api's and json feeds? Bored of that same task of creating your sql tables to store the data?

Paste in an example JSON payload to see your suggested data types and an SQL query to make your tables in an instant.

No data is stored by this website. We do not track your entries, however I would always recommend replacing any sensitive details in your payloads prior to using this service.

SQL Data Type Suggester

Suggestions:

MySQL Create Table Query: