MySQL Client

MySQL Client For Visual Studio Code

Project site: vscode-mysql

Features

• MySQL Client
  • Connect
  • View Tables
  • Execute Sql
  • Generate Mock Data
  • History
  • Backup/Import
  • Setting
  • RoadMap
  • Filter
  • Sponsor

Regarding MySQL 8.0 support

While this plugin can connect to a MySQL 8.0 server, the newer authentication methods are not supported.

To change a user's authentication method to the older one supported by this plugin, run the following query:

alter user my_user@'%' identified with mysql_native_password by "myPassword";

Installation

Install from vscode marketplace vscode-mysql.

Coffee

If you like this this extension, consider buying me a coffee. Thank you!

Connect

1. Open MySQL Panel, then click the + button.
2. Input your connect info then click connect.

View Tables

1. Click Table To Open Query page and Load data.
2. You can do data modification on query page.

Execute Sql

• In the MySQL Panel, click the New Query button.
• This changes the active database.
• Now you can enjoy Intellisense for SQL code within the editor.
• Click Run Button or Press F9 to Execute.

Generate Mock Data

• Now you do not need spend time writing test data.

History

• Click history button to open run history record.

Backup/Import

• Move to ant DatabaseNode or TableNode, backup/import options are listed in the context menu (right click to open).

Setting

OpenSetting -> extensions -> Mysql

Other

• Find a suprise when you right click on a node.

RoadMap

• Sync table struct from diffrent connection.
• Fix Intetllisense sql.
• Better sql formatter.

Filter

Sponsor

• Jetbrains