MySQL management tool
- 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
: Enable support for DELIMITER operator. (Default is true)
By default, anonymous telemetry data collection is turned on to understand user behavior to improve this extension. To disable it, update the settings.json as below:
{
"vscode-mysql.enableTelemetry": 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.