Skip to content
| Marketplace
Sign in
Visual Studio Code>Programming Languages>MySQLNew to Visual Studio Code? Get it now.

MySQL

cweijan

|
120,641 installs
| (33) | Free
Database Client for vscode
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

Database Client

Marketplace Version Installs Rating

Database Client for Visual Studio Code. It supports databases MySQL/MariaDB, Microsoft SQL Server, PostgreSQL, Redis, and ElasticSearch.

Project site: vscode-database-client, 中文文档

Features

  • Database Client
    • Connect
    • Table
    • Execute SQL Query
    • Generate Mock Data
    • History
    • Backup/Import
    • Setting
    • Filter

Installation

Install from vscode marketplace vscode-database-client.

Connect

  1. Open Database Explorer panel, then click the + button.
  2. Select your database type, input your database connection information then click the connect button.

connection

Table

  1. Click table to open table view.
  2. Then you can do data modification on the view page.

query

Execute SQL Query

In the Database Explorer panel, click the Open Query button.

newquery

That will open a sql editor bind of database, it provider:

  1. IntelliSense sql edit.
  2. snippets: sel、del、ins、upd、joi...
  3. run sql (Shortcut : F9).

run

Generate Mock Data

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

mockData

History

Click the history button to open the list of recently executed query history records.

history

Backup/Import

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

bakcup

Setting

This extension contain some setting, find him in the following way.

Filter

filter

Credits

  • vscode-mysql: The original version of this extension.
  • mysqldump: Data dump lib.
  • sql-formatter Sql format lib.
  • umy-ui: Result view render.
  • Core Lib:
    • node-mysql2 : Mysql client.
    • node-postgres: PostgreSql client.
    • tedious: SqlServer client.
  • Contact us
  • Jobs
  • Privacy
  • Terms of use
  • Trademarks
© 2019 Microsoft