How to build an admin panel / GUI for your SQL database in 10 minutes

This video is about how to quickly build an admin panel or UI for a SQL / MySQL database that will allow you to create, read, update, and delete items in the database. We use Retool, a developer tool for building internal tools.

Retool MySQL configuration docs :

Try Retool here:

Check out the Retool community here:

[dman]

That was helpful any chance you can do a follow up where the true / false column is a checkbox as well as showing an example of a SQL one to one (perhaps add a country column) and a one to many relationship (perhaps add a favorite foods column)?

[MohammadaAprilianto]

thanks, btw, how to make id of insert row is autoincrement, instead of typing it manually

[MaxMalm]

Why not only filter by id? Great video

[maalexandrat]

Hi, I followed the steps but when I edit a row it shows: "editRow: {"status":422, "message":"No rows were updated.", "statusCode":422, "error":"Unprocessable Entity", "data":null, "queryExecutionMetadata":{"estimatedResponseSizeBytes":95, "resourceTimeTakenMs":713, "isPreview":false, "resourceType":"snowflake", "lastRecei...
"

The interface changed and no longer appear the Table queries

[squiixo]

Hi
Actually I have a sql file but how to create a admin panel for that ..
Could you please suggest me any platform.

[breacker]

Good Video! I tried to switch the tables in the table component with a simple select component... but it doesnt seem to work. Do you have some docs or vids on this ? I think more people would love to switch tables in one table component

[vipcoua]

How do I make a modal window to ask wether a user really wants to delete a record?