General
What is ApexSQL Database Power Tools for VS Code?
ApexSQL Database Power Tools for VS Code is an extension for Visual Studio Code which provides the connection to the MySQL and MariaDB instances, explore database objects, generates DDL (Create, Alter, Drop) and DML (Select, Insert, Update, Delete) scripts for a variety of objects (tables, view, stored procedures, functions), export query results in one of the available formats (Excel, HTML, CSV, JSON) and much more
Is ApexSQL Database Power Tools for VS Code stand-alone tool?
No, ApexSQL Database Power Tools for VS Code is an extension which can be installed only in Visual Studio Code
Where can I download ApexSQL Database Power Tools for VS Code extension?
You can download the extension from the ApexSQL Download page or the Visual Studio Code Marketplace page.
Where can I see the requirements for installing ApexSQL Database Power Tools for VS Code extension?
Where can I see what the ApexSQL Database Power Tools for VS Code extension supports?
Visual Studio Code support
Which versions of Visual Studio Code does ApexSQL Database Power Tools for VS Code support?
Visual Studio Code 1.52 version and higher
Which versions of MySQL and MariaDB does ApexSQL Database Power Tools for VS Code support?
- MySQL 5.6 and higher
- MariaDB 10.1 and higher
Does ApexSQL Database Power Tools for VS Code support connection to the Azure/Amazon cloud-based MySQL and MariaDB databases?
Does ApexSQL Database Power Tools for VS Code support connection to Amazon Aurora MySQL?
Can I use ApexSQL Database Power Tools for VS Code extension in Visual Studio Code installed on macOS?
Which OS platforms does ApexSQL Database Power Tools for VS Code support?
Windows, Linux, and macOS
Features
Can I save query results in some file format?
Yes. With ApexSQL Database Power Tools for VS Code, you can export query results in CSV, HTML, Excel, and JSON file formats
How can I connect to MySQL and MariaDB servers using ApexSQL Database Power Tools for VS Code?
You can use standard TCP/IP protocol, for local connections the Socket/Pipe can be used and TCP/IP over SSH
Can I export the search results?
Yes, this can be done using the corresponding buttons in the top-right corner above the Results grid. Export can be done in four different output file formats: Excel, CSV, JSON, and HTML
Is text search case sensitive?
No, for example, whether the country or COUNTRY is typed for search, the result will be the same
Where can I turn on/off the ApexSQL hint-list?
Under the Extensions setting check/uncheck the Enable auto-complete hint-list in query editor option:
Can I turn on the system databases to be shown in the ApexSQL server explorer?
Yes. Under the Extensions setting turn on the Show system databases in server explorer option:
Once the option is enabled, the system databases will be listed under the System databases branch of the connected server tree

Can I script my SQL objects?
Yes. Depending on which object (table, view, procedure,…) is selected in the ApexSQL server explorer, on the right-click context menu, different commands for scripting will appear:
Other
Is ApexSQL Database Power Tools for VS Code open source?
No, ApexSQL Database Power Tools for VS Code is not open-source software
How can I open a script in the ApexSQL query editor?
Once a script is opened in VS Code, use the Ctrl+Shift+P keyboard shortcut and, in the box that appears, type Reopen. From the generated drop-down list, choose the Reopen Editor With… command:
Once is clicked, the new drop-down list will appear, and from there the ApexSQL editor can be chosen:
Can I set the ApexSQL editor to be the default editor for .sql files?
Yes. Open a .sql file, use the Ctrl+Shift+P keyboard shortcut, once the box appears, type Reopen, and from the generated drop-down list, choose the Reopen Editor With… command, after the command is chosen a new drop-down list will appear with available editors. In the list, find the ApexSQL editor and click the setting button to set ApexSQL editor to be the default editor for .sql files:
How can I report the issue of ApexSQL Database Power Tools for VS Code extension?
To report an issue, first, use the Ctl+Shift+P keyboard shortcut, and in the box that appears type the ApexSQL and from the drop-down list, choose the ApexSQL: Report issue command:
Once the ApexSQL: Report issue command is clicked, the Quest support portal will be opened along with the location of the zipped ApexSQL Database Power Tools for VS Code log files:
Login to the Quest portal, and on the Create Service Request page, create a support request with attached log files
Where the ApexSQL Database Power Tools for VS Code log files are stored on my machine?
The ApexSQL Database Power Tools for VS Code log files are stored under this location:
C:\Users\<User_Name>\AppData\Local\ApexSQL\ApexSQL Database Power Tools for VS Code\Log