Query
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.
Max returned row count
SQL Editor can return at most 100,000 rows.
Max returned result size
The default query result size is 100 MB. You can change it under the Workspace settings.
Export data
If you have been granted export access, you can directly export query results in various formats.
Otherwise, you can request the exported data
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 depends on WebSocket. If you access Bytebase via a gateway, you need to enable WebSocket there. Here is a NGINX configuration:
Batch mode
You can batch query many databases having the same schema:
For each database, the query result will show up in its own tab:
Search result
You can retrieve anything you want from query results quickly.