Connect Hasura Cloud to YugabyteDB Aeon

Use the Hasura GraphQL Engine with YugabyteDB Aeon to power your GraphQL applications with a distributed SQL database.

The following tutorial describes how to connect a YugabyteDB Aeon cluster to a Hasura Cloud project.

Obtain your YugabyteDB cluster connection information

Sign up for YugabyteDB Aeon and create a Sandbox cluster by following the steps in the Quick Start.

The cluster has a default database called yugabyte. You'll use this along with your database credentials (username and password) in your connection with the Hasura project. To connect, you'll also need the connection string with the cluster's host address and port number.

To get these details, in YugabyteDB Aeon:

  1. On the Clusters page, select the cluster you will use for the application, and click Connect.

  2. Click Connect to your Application.

  3. Select Optimize for Hasura Cloud.

  4. Copy and record the YSQL connection string, replacing <DB USER> and <DB PASSWORD> with your cluster database credentials.

Important

The connection string is a URL; be sure to encode any special characters in the hostname or password of the connection string.

Create a Hasura Cloud project

To create a Hasura Cloud account, sign up at https://cloud.hasura.io.

For details on using Hasura Cloud, refer to the Hasura Cloud documentation.

To create a project in Hasura Cloud:

  1. From the Hasura Cloud Dashboard, under Projects, click New Project.

  2. Select Free Tier.

    Create Hasura project

  3. Click Create Free Project.

    The project details are displayed. These include the GraphQL API endpoint URL and Admin Secret, which are used for connecting applications.

  4. Copy the endpoint URL and Admin Secret. You will need these to connect applications.

  5. Note the Hasura Cloud IP. You will need to add this to your cluster IP allow list in YugabyteDB Aeon.

Add the Hasura Cloud project to your Yugabyte cluster IP allow list

YugabyteDB Aeon restricts access to clusters to IP addresses whitelisted in IP allow lists. To connect the Hasura project, you must add the project's IP address to the cluster IP allow list.

  1. In YugabyteDB Aeon, select your cluster, click Actions, and choose Edit IP Allow List.

  2. Click Create New List and Add to Cluster.

  3. Enter a name for the allow list (such as the name of your Hasura project) and the project IP address, and click Save.

Connect the cluster to your Hasura Cloud project

To connect your cluster:

  1. In the Hasura Cloud Dashboard, click Launch Console.

    This displays the Hasura Cloud Console for the project.

  2. In the Hasura Cloud Console, click the Data tab.

  3. Under Connect Existing Database, enter the following details:

    • Database Display Name: enter a display name for your YugabyteDB Aeon cluster
    • Data Source Driver: PostgreSQL
    • Connect Database Via: Database URL

  4. Set the Database URL using your YSQL connection string. Be sure to encode any special characters in the string.

    For example

    postgresql://admin:qwerty@1234%20.cloud.yugabyte.com:5433/yugabyte?ssl=true&sslmode=require

    Connect Hasura database

  5. Click Connect Database and wait for confirmation that the database has connected.

  6. Click View Database.

The schema is empty, and your project is ready to be connected to an application.