Need help with vscode-database-client?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

cweijan
1.0K Stars 69 Forks MIT License 1.5K Commits 22 Opened issues

Description

Database Client For Visual Studio Code

Services available

!
?

Need anything else?

Contributors list

Database Client

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

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

Features

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

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

run

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

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

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.