A few weeks ago, we shipped a cool new feature in our console. In the past, the only way for Neon users to work with their data was via SQL queries; now, you can modify your data in an intuitive and visual way directly from the Tables page, powered by Drizzle Studio.
You can now use the console to add, update, and delete records, filter data, add or remove columns, drop or truncate tables, and export data in .json and .csv formats. I show you how in this quick video:
Editing data from the Neon console: no SQL required
With our new feature, you can now browse your tables and make edits visually and easily. This update is designed to streamline your workflow and make data management more accessible, even for those who may not be as comfortable writing SQL queries.
If you want to give it a spin:
- Log in to your Neon account
- Optionally, create a development branch from your primary branch (named ‘main’ by default). This branch will be an exact copy-on-write clone of all your data and schemas from main, but it’s isolated – it allows you to play around with your data safely.
- Once you’re in the development branch, navigate to the Tables view and try to make edits directly on the tables (similarly as you would do on a spreadsheet)
After making your changes, you can simply save them, and they’re immediately reflected in the console – and in your dataset for that particular branch. Changes won’t be reflected on the main branch, unless you modify your data there as well.
Adding filters and browsing data
If you have a large table and are looking for a particular record, you can also use Filters vs writing a SQL query. For example, here I’m looking for somebody whose first name is Grace:
After you’ve added a filter, your search will be saved as a view so you can easily come back to it later (see View 1 up there).
You can add as many filters as needed, download data, and browse records using the pagination widget. Unnecessary columns can also be hidden for a more focused view.
Remember: changes only affect your current branch
Like always in Neon, database branches have data isolation. If you modify records from the console in your development branch, they won’t be automatically reflected in the primary branch or its parent.
This ensures that your production environment remains stable and unaffected by any accidental data changes. Once you know the changes are safe, if you wish so, you can apply them to the main branch.
Give it a go
This renewed Tables view aims to provide you with flexibility in managing your data, all from within the Neon console. We hope this enhances your experience and look forward to your feedback! If you haven’t tried Neon, you can create an account for Free here.
