Skip to content

Web console

Query your database directly from the PlanetScale UI

Overview

The PlanetScale web console is an interactive interface for running MySQL queries and DDL (Create, Alter, and Delete) against your PlanetScale database branches.

Get started

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 any web console enabled database branch and click on the Console tab in the database navigation.

Console tabConsole tab

You can also access the web console directly by adding /console to the URL from any databases branch page, app.planetscale.com/<org>/<database>/<branch>/console.

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.

Use SHOW TABLES; to see a list of the tables in your database branch.

SHOW TABLES; in the consoleSHOW TABLES; in the console

Use DESCRIBE table_name; to obtain information about a given table's structure.

DESCRIBE table_name; in the consoleDESCRIBE table_name; in the console

Use EXPLAIN in front of SELECT, DELETE, INSERT, REPLACE and UPDATES statements to learn how the database is executing a query. This can be useful for optimizing slow queries.

Supported console commands

CommandDescription
?, \?Synonym for help
clear, \clearClear the current input statement
help, \hDisplay list of commands
ego, \GSend command to server
go, \gSend 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 in the settings page for the given database, app.planetscale.com/<org>/<database>/settings.

Select the checkbox for "Production branch web console access". Then click the "Save database settings" button to save your changes.

Enable product branch web console accessEnable product branch web console access

This will enable the ability to use the web console to run queries against production branches for the given database.

Was this page useful?
Last updated on October 15, 2021
Help us improve this page
PrivacyTerms© 2021 PlanetScale Inc.