Seamlessly integrate your SQL queries and data with your favorite APIs and programming languages, using WayScript.
Run queries against a SQL database.
See Code Editors for more information on composing code in WayScript.


Add an Account

Select "Add an Account" to add a new database, or select a database you have already submitted.
The SQL module supports connections to MySQL, SQL Server, and PostgreSQL database instances.
Select a Database or Add An Account

Setting Up a New Database

You must supply the following information in order to connect to your database:
  • Database Type: MySQL, SQL Server, or PostgreSQL.
  • Endpoint: The publicly accessible URL for your database.
  • Port: The port where your database instance accepts connections.
    • Defaults are 3306 for MySQL, 1433 for SQL Server, and 5432 for PostgreSQL.
  • Database Name: The name of the database you want to run the query against.
  • User: The username to use to connect to the database.
  • Password: The corresponding password for the specified user.

Compose Your SQL Query

Compose your SQL query using the Code Editor.
You can run your query by clicking the "Run Code" button, or by running your program.


Any data returned by your SQL query will be displayed as a table in your code editor.
To use output data elsewhere in your program, assign a name to each column of data you want to use. The column will then appear as a list variable in your "Variables" panel.

IP Address Whitelisting

If your SQL server has a firewall enabled, please add the IP addresses listed in the link below to your firewall exceptions:

Connecting to AWS RDS

For information on connecting to AWS RDS, refer to the article below:

Connecting to SQL Azure

For information on connecting to SQL Azure, refer to the article below:


Cron+SQL+Twilio in 3 Minutes
Connecting a Heroku PostgreSQL Database to WayScript