Skip to main content
The My Data tab is where you look at and change what’s in your database. In the Project Editor, select Tools, then Database under Replit Cloud. Select a database, then My Data. You can work visually or run SQL directly.
To edit production data, select the production database, open My Data, and turn on Enable Editing. Be careful: this is your live app’s real data.
This example shows the navigation in a development database with no application tables yet: Database selected under Replit Cloud, with Development Database, My Data, SQL console, Database studio, and an empty public schema

​
Browse and modify data visually

In My Data, select Database studio to browse and modify data visually with Drizzle Studio. These visual tools help you avoid syntax errors and offer the following functionality:
  • Filter and sort data to focus on specific information
  • Export data to a file for external use
  • Insert or modify row data
  • Create and manage schema, tables, views, and enums

​
Run SQL commands

The SQL console lets you run SQL commands on your database and view the results.
From the Database tool:
  1. Select the My Data tab
  2. Select SQL console
To run a query, enter the SQL statement in the text area and select Run. For a read-only example that doesn’t change your app’s data, use:
The result contains one row with example_value set to 1: SQL console with SELECT 1 AS example_value, the Run button, and a returned row containing 1
You don’t need to write SQL yourself. Ask Agent to query or change your data, and it writes and runs the SQL for you.

​
Next steps