Amazon Aurora is a global-scale relational database service built for the cloud with full MySQL and PostgreSQL compatibility.
qStudio is a free SQL IDE, it allows running SQL scripts, easy browsing of tables, charting and exporting of results. It works on every operating system, with every database including Aurora-MySQL.

Setting up a Aurora-MySQL connection in qStudio

Start Aurora-MySQL

Aurora-MySQL is available on AWS Cloud. Simply start a small service in your chosen region. The connection details should be provided, similar to shown:

  • Engine type: Aurora MySQL Compatible
  • Public access: Yes
  • VPN: With access permitted from our IP address.
Aurora-MySQL Console Aurora-MySQL Console

Connecting to a Server

Aurora-MySQL is MySQL compatible, qStudio includes MySQL drivers, for this demo we will use the MySQL driver.

When you first open qStudio click on the menu options Server->Add Server or on the add server button on the toolbar.
Then set the details:

  1. Server Type: MySQL
  2. Host:
    Port: 3306
  3. Username: admin
    Password: XXXXXXXXXXX
  4. Click Add

Add Aurora-MySQL Connection

Sending Queries

You can run queries by highlighting selected code and pressing Ctrl + e to run that code. See Keyboard Shortcuts.

Run highlighted text Ctrl + e
Run Line Ctrl + Enter

This will update your various results panels, result contains your table (excel export etc. supported), charts are generated based on your data and the console summarizes your recent commands

Run Aurora-MySQL Select

Well Done!

You have now got qStudio querying your database successfully.

We want to make qStudio the best SQL analysis tool. If you have any problems or want additional features, please post on our github repo.