Note: The extension requires payment to unlock all features, online document: doc.database-client.com.
This project is a database client for VSCode, supports manager MySQL/MariaDB, PostgreSQL, SQLite, Redis, ClickHouse, Kafka, MongoDB, Snowflake, and ElasticSearch, and works as an SSH client, boost your maximum productivity!
The Database Client extension will collects and sends anonymous usage data to the Database Client server to help improve our products and services. Read our Privacy Statement to learn more.
If you don't want to be collected by Database Client, you can turn it off by setting
Install from vscode marketplace vscode-database-client.
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.
Execute SQL Query
In the Database Explorer panel, click the
That will open a SQL editor bind of database, it provider:
The database can be searched by clicking the search button to the right of "Tables".
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。
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.
The extension provides some settings, you can refer to the following operations to go to the console settings.
Generate Mock Data
You can easily generate test data.
Click the history button to open the list of recently executed query history records.