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

MySQL

Weijan Chen

|
788,169 installs
| (191) | Free
Database manager for MySQL/MariaDB, PostgreSQL, SQLite, Redis and ElasticSearch.
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

Database Client

This project is no longer maintain for free and requires payment to unlock all features. At the same time I will put more effort into developing this project.

The online document is migrate to doc.database-client.com.


GitHub


This project is a database client for VSCode, supports manager MySQL/MariaDB, PostgreSQL, SQLite, Redis, ClickHouse, 达梦, and ElasticSearch, and works as an SSH client, boost your maximum productivity!

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

Logo

Note: The extension is now paid for, and some functions are available to paid users.

Features

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

Installation

Install from vscode marketplace vscode-database-client.

Connect

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

connection

Two panels are created because in some cases you need to view both SQL and NoSQL data at the same time, you can drag the panel to the other by long-pressing.

Table

  1. Click table to open table view.
  2. Click button beside table to open new table view.
  3. Then you can do data modification on the table view.

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 selected or current cursor SQL (Shortcut : Ctrl+Enter).
  4. Run all SQL (Shortcut : Ctrl+Shift+Enter).

Note: The extension is developed using Nodejs. Nodejs does not allow duplicate name attributes, so you need to avoid columns with the same name in your query, otherwise the results will not be displayed in full.

run

This extension supports codelen, but does not support stored procedures and functions. If you use them frequently, it is recommended to disable codelen image

Cache

In order to improve performance, the database information is cached. If your database structure changes externally, you need to click the refresh button to refresh the cache。

Backup/Import

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

The extension implements the backup function, but it is not stable enough. You can add mysql_dump or pg_dump to the environment variable, and the extension will use these tools for backup.

bakcup

Setting

This extension contain some setting, can be modified as follows, some settings only take effect for paid users.

The default settings can get the best experience, don't worry

image

Generate Mock Data

You can easily generate test data.

mockData

History

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

history

Credits

  • sql-formatter Sql format lib.
  • umy-ui: Result view render.
  • ssh2: SSH client.
  • Client Lib:
    • node-mysql2 : MySQL client.
    • node-postgres: PostgreSQL client.
    • tedious: SqlServer client.
    • ioredis: Redis client.
    • vscode-sqlite: SQLite client code reference.
  • Contact us
  • Jobs
  • Privacy
  • Terms of use
  • Trademarks
© 2023 Microsoft