The Database Client make your life easy. It supports databases MySQL/MariaDB, Microsoft SQL Server, PostgreSQL, SQLite, MongoDB, Redis, and ElasticSearch.
Project site: vscode-database-client, 中文文档
If this extension is helpful to you, please consider buy author a cup of coffee:
Install from vscode marketplace vscode-database-client.
- Open Database Explorer panel, then click the
+
button. - Select your database type, input connection config then click the connect button.
- Click table to open table view.
- Then you can do data modification on the view page.
In the Database Explorer panel, click the Open Query
button.
That will open a SQL editor bind of database, it provider:
- IntelliSense SQL edit.
- snippets:
sel、del、ins、upd、joi
... - Run selected or current cursor SQL (Shortcut : Ctrl+Enter).
- Run all SQL (Shortcut : Ctrl+Shift+Enter).
This extension supports codelen, but does not support stored procedures and functions. If you use them frequently, it is recommended to disable codelen
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。
You can easily generate test data.
Click the history button to open the list of recently executed query history records.
Move to ant DatabaseNode or TableNode. The export/import options are listed in the context menu (right click to open).
This extension contain some setting, can be modified as follows.
Used to quickly filter the table, if there is an input box to simplify the search operation, but unfortunately VSCode does not support this function.
- 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.