Note: This tool forked from MySQL (Jun Han).
major changes:
- add support for
DELIMITER
operator (can be switched by parameterenableDelimiterOperator
)- update to support future vscode versions
minor changes you can see in the changelog
- Manage MySQL Connections (support SSL connection)
- List MySQL Servers
- List MySQL Databases
- List MySQL Tables
- List MySQL Columns
- Run MySQL Query
- To add MySQL connection: in Explorer of VS Code, click "MYSQL" in the bottom left corner, then click the
+
button, then type host, user, password, port and certificate file path (optional) in the input box.
- To run MySQL query, open a SQL file first then:
- right click on the SQL file, then click
Run MySQL Query
in editor context menu (Note: you could also run the selected SQL query) - or use shortcut
Ctrl+Alt+E
- or press
F1
and then select/typeRun MySQL Query
- right click on the SQL file, then click
- To create a new MySQL query or change active MySQL connection (You could see active MySQL connection in status bar):
- right click on a MySQL server, then click
New Query
- or right click on a MySQL database, then click
New Query
- right click on a MySQL server, then click
vscode-mysql.maxTableCount
: The maximum table count shown in the tree view. (Default is 500)vscode-mysql.enableDelimiterOperator
: Enabling or disabling support forDELIMITER
operator. If you execute large MySQL scripts without delimiter operator you may want to disable this function to improve performance. (Default: True)vscode-mysql.keepResultWindow
: Keeps the result when switching tabs. Enabling this option increases memory usage. (Default: False)
See Change Log here
Currently, the extension is in the very initial phase. If you find any bug or have any suggestion/feature request, please submit the issues to the GitHub Repo.