MultiConnectMultiConnectDocs Website home
MultiConnectCloud › Database Deployments

8. The query console

The query console runs SQL against your database from the dashboard. Open your project on the dashboard, then the deployment, and select Query console.

It connects as your own database user, so it can do exactly what your application can do. It connects through MultiConnectCloud's own systems, so it works even when your allowed list is empty. If the console can run a query and your application cannot connect, the allowed list is the problem.

Part What it does
Schemas Lists your schemas. Expand one to see its tables, and select a table to see its Columns
Editor Type a statement. Ctrl+Enter runs it
Run on reader (read-only) On by default. Turn it off to run on the writer, which shows Statements run on the writer and can modify data.
Row limit 100 rows, 500 rows or 1000 rows
Explain Shows the query plan without running the statement
Run Runs the statement. Below the result you see the row count, time taken, reader or writer, and rows affected
History Every statement run on this database, with who ran it, when and whether it worked. Select one to put it back in the editor

The console is for inspection and small fixes, not bulk work:

Limit Value
Rows returned At most 1000
Statements per database 30 a minute
Statements per account 90 a minute
Statement length 20,000 characters
Run time A time limit set by your plan