ApexSQL Database Power Tools for VS Code

Connect to MySQL and MariaDB instances, run queries and display results, auto-complete SQL statements, search for objects and data within them, format scripts, export query results into several standard formats, generate DDL and DML scripts from object explorer, and much more to come. For the latest news and updates, visit the VS Code extension official product page.

Description

ApexSQL Database Power Tools for VS Code is a development and management tool for working with MySQL and MariaDB databases and servers including the following features:

• Connect to MySQL, MariaDB, Amazon MySQL, Microsoft Azure MySQL
• Create, Drop, Select, Insert, Update, and Delete script snippets
• Write and execute queries
• Automatically fill in SQL keywords and database objects
• Export query results as Excel, CSV, JSON, and HTML
• Search for objects and quickly find them in server explorer
• Text search within MySQL Server and MariaDB databases
• Format MySQL and MariaDB scripts
• Show system databases
• Customize keyboard shortcuts

Features

Connections to MySQL and MariaDB instances

Connect to MySQL and MariaDB instances using TCP/IP, Local Socket/Pipe and TCP/IP over SSH types of connection

Cross-platform support

Run the extension on as many existing platforms as needed (Windows, Linux, macOS)

Query execution

Run MySQL and MariaDB queries and display results

SQL code completion

Automatically fill in SQL keywords and database objects

Object search

Search for objects in database object definitions

Text search

Text search within MySQL Server and MariaDB databases

Script formatting

Beautifying SQL code by using predefined built-in formatting rule

Automatically create statements

Generate scripts (Create, Drop, Select, Insert, Update, and Delete) from object explorer

Save query results

Export query results into several standard formats (Excel, CSV, JSON, and HTML)

Content

FAQs page

What's new in ApexSQL Database Power Tools for VS Code 2020 R6

Visual Studio Code for MySQL and MariaDB development

How to export MySQL data to JSON

Exporting MySQL data to CSV file format using different methods

ApexSQL Database Power Tools for VS Code for a first-time user

What's new in ApexSQL: ApexSQL Database Power Tools for VS Code

Supported platforms

ApexSQL Database Power Tools for VS Code supports the following platforms:

• OS X 10.10 and higher
• Windows 7 and higher
• Ubuntu Desktop 14.04 and higher
• Debian 7 and higher
• CentOS 7 and higher
• Fedora 23 and higher

System requirements

Full list of ApexSQL Database Power Tools for VS Code software requirements is specified on the official System requirements page.

Privacy policy

By using this extension you are providing consent to our Privacy policy.

License

This extension is licensed under Quest Software Transaction Agreement.