Query

SQL Editor default mode is read-only, which only supports running SELECT queries. If you attempt to run DDL or DML change queries, SQL Editor will prompt you to create a new issue to start the SQL change workflow.

Workspace Admins and DBAs are allowed to execute any SQL statements in Admin Mode.

The read-only mode is not available for MongoDB, but you also can execute the statements in Admin Mode.

Run query#

Click the Run button or use the shortcut key (⌘ + Enter) to run your queries in the SQL Editor.

If you have multiple SQL queries separated by semicolons, SQL Editor will only run the first query for now.

SQL Editor can return at most 100,000 rows and 100 MB size in total.

Query Limit

Explain query#

Explain Query

SQL Editor provides an Explain Query action to run EXPLAIN on the selected query. You can access it from right click or use the shortcut key (⌘ + E) instead of prepending EXPLAIN manually.

Autocomplete#

autocomplete

Autocomplete depends on WebSocket. If you access Bytebase via a gateway, you need to enable WebSocket there. Here is a NGINX configuration:

http {
    server {
        ...

       location ~ ^/(v1:adminExecute|lsp) {
            proxy_pass http://bytebase.example.com;
            proxy_http_version 1.1;
            # Enables WebSocket which is required for SQL Editor autocomplete
            proxy_set_header Upgrade $http_upgrade;
            proxy_set_header Connection $connection_upgrade;
        }
        ...
    }
}