Free Aurora-MySQL SQL IDE

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.

Start Aurora-MySQL
Connecting to Aurora-MySQL
Querying 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.

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:

Server Type: MySQL
Host: database-1-instance-1.ctayqjdfp8vl.eu-west-1.rds.amazonaws.com
Port: 3306
Username: admin
Password: XXXXXXXXXXX
Click Add

Sending Queries

CREATE DATABASE IF NOT EXISTS bob;
USE bob;
DROP TABLE IF EXISTS sales;
create table sales(item text, sale_time timestamp, quantity int);
insert into sales values('a', '2001-01-01 00:18:00', 10);
insert into sales values('b', '2001-01-01 00:18:30', 20);
insert into sales values('c', '2001-01-01 00:19:00', 30);
insert into sales values('c', '2001-01-01 00:20:00', 33);
insert into sales values('c', '2001-01-01 00:21:00', 35);
insert into sales values('c', '2001-01-01 00:22:00', 34);
insert into sales values('c', '2001-01-01 00:23:00', 30);
SELECT * FROM sales;

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

Command	Shortcut
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

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.