Home » AI Databases » Inline Editing

How to Edit Database Records Without Writing SQL

The AI database apps let you edit records directly in a web interface without writing any SQL. Browse your tables, click on a record, change the values you need, and save. The platform handles the UPDATE statement behind the scenes. You can also insert new rows and delete records, all through a visual interface.

Before You Start

Your database connection needs a user account with write permissions (INSERT, UPDATE, DELETE) in addition to SELECT. If you connected with a read-only user, you can still browse and query data but will not be able to edit. You can update the user permissions in your database and reconnect, or create a new database user with the appropriate access.

Tip: If you want some team members to only view data while others can edit, create two database users with different permissions. Connect the read-only user for exploration and the write user for editing. See How to Secure Your Database Connection.

Step-by-Step: Editing Records

Step 1: Open the table browser.
Go to the MySQL or PostgreSQL app in your admin panel and open the web table browser. You will see a list of all tables in your database. Click on the table you want to edit.

Step 2: Find the record you want to change.
Browse through the table rows or use the search and filter options to locate the specific record. You can sort by any column, filter by value, or use the AI query interface to find records matching specific criteria.

Step 3: Click on the record to edit.
Click on a row to open the record editor. Each column appears as an editable field with its current value. The field type matches the column data type: text inputs for VARCHAR, number inputs for INT and DECIMAL, date pickers for DATE columns, and text areas for TEXT or JSON columns.

Step 4: Change the values and save.
Modify the fields you need to update and click Save. The platform generates an UPDATE statement targeting only the changed columns and executes it against your database. The primary key is used in the WHERE clause to ensure only the correct record is modified.

Step 5: Verify the change.
After saving, the record refreshes with the updated values. You can also verify by running a query or browsing back to the table view to confirm the change appears in the list.

Inserting New Records

To add a new row to a table, open the table in the browser and click the Add Record button. A blank form appears with fields for every column. Required columns (those that do not allow NULL and have no default value) are marked. Fill in the values and click Save to insert the new row.

Columns with default values or auto-increment settings do not need to be filled in. The database applies the defaults automatically. For example, an auto-incrementing ID column and a created_at column with a default timestamp both populate themselves.

Deleting Records

To delete a record, open it in the editor and click Delete. The platform asks for confirmation before executing the DELETE statement. Deletion is permanent in your database, so use caution. If your tables have foreign key constraints with CASCADE rules, deleting a parent record may also delete related child records.

Bulk Editing With Natural Language

For updating many records at once, the natural language SQL interface is more efficient than editing records one by one. You can tell the AI "set the status to inactive for all customers who have not logged in since January" or "increase all product prices by 10 percent." The AI generates the appropriate UPDATE statement, shows it to you for review, and executes it when you confirm.

Safety: Bulk update commands generated by the AI are always shown to you before execution. The system never runs UPDATE or DELETE statements automatically. You review the SQL and explicitly confirm before any write operation runs.

What You Can Do Next

With inline editing working, you might also want to browse and manage your tables in the full web UI, set up automated reports, or use AI to clean and fix records in bulk.

Edit your database records in a visual interface. No SQL required, no desktop tools needed.

Get Started Free

MySQL App · PostgreSQL App