Data sources
Connect Databses


With Querier, you can integrate with MySQL and execute various queries.


Connecting via IP Whitelisting

Add the following IP address to the whitelist in your database's firewall rules:

Connecting via SSH Tunneling

Please refer to this document to set up a bastion server.

Connection Method

1. Create a new data source connection

  1. Click the [Resources] tab.
  2. Click the [Create] button next to [Resources].
  3. Select [MySQL].

2. Enter the connection information

Common Items

NameEnter the name of the MySQL connection (e.g., Querier DB).
Managed serviceSelect None or Cloud SQL.
Database nameEnter the database name of the MySQL you are connecting to.
Database usernameEnter the database username for the MySQL connection.
Database passwordEnter the password for the MySQL connection.

🙋‍♂️ About Managed Service

Currently, Querier supports connections via Cloud SQL Proxy. If you use Cloud SQL, select Cloud SQL under [Managed Service] to connect via Cloud SQL Proxy.
If not, please choose None.

If None is selected for Managed Service

HostEnter the host of the MySQL connection.
PortEnter the port for the MySQL connection (e.g., 3306).

If Cloud SQL is selected for Managed Service

Project IDEnter the Project ID for the GCP where Cloud SQL is set up.
Instance nameEnter the instance name of the Cloud SQL you are connecting to.
RegionEnter the region of the Cloud SQL (e.g., asia-northeast1).
Credentials JSONEnter the service account for the GCP where Cloud SQL is set up in JSON format.

🙋‍♂️ Required Permissions for the Service Account

The service account must have one of the following permissions:

  • Cloud SQL Client
  • Cloud SQL Editor
  • Cloud SQL Admin

3. Set Up a Bastion Server

If you are connecting via a bastion server, follow these additional steps. If not, skip this section.

  1. Check [Set up a bastion server].
  2. Select the bastion server you set up during the preparation.