MySQL Client

MySQL Client For Visual Studio Code

This plugin was inspired by MySQL.

Give project a star to keep me motivated to keep updating.

Note: This plugin does not support MySql 8.0!

Features

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

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

{
  // enable delimiter when import data
  "vscode-mysql.enableDelimiter": false,
  
  // Load database meta info when connected, If your machine's performance is low, turn it off.
  "vscode-mysql.loadMetaOnConnect":true,

  // set max tables show of each database.
  "vscode-mysql.maxTableCount": 500
}

Other

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