The PlanetScale web console is an interactive interface for running MySQL queries and DDL (Create, Alter, and Delete) against your PlanetScale database branches.
The PlanetScale web console can be used to query to any database branch; however, it is disabled for production branches by default to prevent accidental data loss.
To access the web console, navigate to a database, and click on the "Console" tab in the page navigation. From here, you can select which branch you'd like to connect to by selecting it in the dropdown and clicking "Connect".
You can also access the web console directly by adding
/console to the URL from any database branch page,
Once you have accessed the web console, you can run queries against your database branch, or apply DDL to non-production branches.
The following are examples of MySQL statements you may find useful within the web console:
SHOW TABLES; to see a list of the tables in your database branch.
DESCRIBE table_name; to obtain information about a given table's structure.
EXPLAIN in front of
UPDATES statements to learn how the database is executing a query. This can be useful for optimizing slow queries.
Supported console commands
|?, \?||Synonym for |
|clear, \c||Clear the current input statement|
|help, \h||Display list of commands|
|ego, \G||Send command to server|
|go, \g||Send command to server|
Enable for production branches
By default, the web console is disabled for production branches to prevent accidental data loss.
You can enable the web console for production branches on the "Settings" page for the given database,
Select the checkbox for "Allow web console access to production branches", then scroll down and click the "Save database settings" button to save your changes.
This will enable the ability to use the web console to run queries against production branches for the given database.