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 |

