If you're already familiar with the connection string you can use 3rd party software like DB Schema, Data Grip or MySQL Workbench and from there you can run queries to create/edit views.
you can also create a query to run manually when you need to create or update a view