RDS Schema Changes Guide

[tanishapatil1234]

Once RDS instance is created using this guide , proceed to next steps.

Installations

1. Navigate to extensions in VSCODE.
2. Install the following :
   
   

Using SQL Tools

1. Navigate to the SQL tools icon on the side bar
   

2. On the top banner, click 'Add New Connection' button
   

3. When prompted, select 'MySQL'
   

4. When prompted, fill out connection settings :
   

5. Test and then Save working Connection
   

   Now, under connections you should see the new connection just made:
   

6. Now, a .sql file named after the connection should appear in editor:
   

7. With a simple ChatGPT query, you can create SQL commands for the changes to the database schema you would like to make.
   

   

8. Paste SQL query and click 'Run on active connection' :

9. Observe changes in table