MySQL management tool for Visual Studio Code
Switch branches/tags
Nothing to show
Clone or download
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.vscode first commit Nov 21, 2017
images Bump version to 0.3.0 Mar 12, 2018
resources ColumnNode.ts (#5) Dec 3, 2017
src Show query result as HTML table (#30) Mar 12, 2018
.gitignore first commit Nov 21, 2017
.travis.yml Add CI Nov 24, 2017
.vscodeignore Prepare for publish Nov 22, 2017
CHANGELOG.md Bump version to 0.3.0 Mar 12, 2018
LICENSE Create LICENSE Nov 22, 2017
README.md Bump version to 0.2.3 Feb 23, 2018
logo.png Prepare for publish Nov 22, 2017
package-lock.json Better output format: display output as table Nov 24, 2017
package.json Bump version to 0.3.0 Mar 12, 2018
tsconfig.json first commit Nov 21, 2017
tslint.json first commit Nov 21, 2017

README.md

MySQL

Marketplace Version Installs Rating Build Status

MySQL management tool

Features

  • Manage MySQL Connections (support SSL connection)
  • List MySQL Servers
  • List MySQL Databases
  • List MySQL Tables
  • List MySQL Columns
  • Run MySQL Query

Usage

  • To add MySQL connection: in Explorer of VS Code, click "MYSQL" in the bottom left corner, then click the + button, then type host, user, password, port and certificate file path (optional) in the input box.

connection

  • To run MySQL query, open a SQL file first then:
    • right click on the SQL file, then click Run MySQL Query in editor context menu (Note: you could also run the selected SQL query)
    • or use shortcut Ctrl+Alt+E
    • or press F1 and then select/type Run MySQL Query

run

  • To create a new MySQL query or change active MySQL connection (You could see active MySQL connection in status bar):
    • right click on a MySQL server, then click New Query
    • or right click on a MySQL database, then click New Query

newquery

Settings

  • vscode-mysql.maxTableCount: The maximum table count shown in the tree view. (Default is 500)

Telemetry data

By default, anonymous telemetry data collection is turned on to understand user behavior to improve this extension. To disable it, update the settings.json as below:

{
    "vscode-mysql.enableTelemetry": false
}

Change Log

See Change Log here

Issues

Currently, the extension is in the very initial phase. If you find any bug or have any suggestion/feature request, please submit the issues to the GitHub Repo.