Database Client for Visual Studio Code. It supports databases MySQL/MariaDB, Microsoft SQL Server, PostgreSQL, Redis, and ElasticSearch.
Install from vscode marketplace vscode-database-client.
Execute SQL Query
In the Database Explorer panel, click the
That will open a sql editor bind of database, it provider:
Generate Mock Data
Now you do not need to spend time writing 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, find him in the following way.