Xata Agent ‐ GCP CloudSQL integration guide

This guide walks you through creating a GCP IAM user to be used by the Xata Agent.

Step 1: Create a service account

1. Open the IAM > Service accounts page.
2. Click Create service account.
3. Name the account xata-agent and enter a description like Service account for the Xata Agent..

4. Add the following roles: Cloud SQL Viewer, Logs Viewer, Monitoring Viewer.

5. Click Continue and then Done (skip adding granting user access).

Step 2: Create access keys as JSON file

1. Open the user you created and then switch to the Keys tab.
2. Click Add key > Create new key*.
3. Leave JSON as the key type.
4. Download the JSON file.

Step 3: Upload the credentials JSON to the Xata Agent

1. Go to the Xata Agent Cloud connect integration page and upload the JSON file:

2. After uploading, click the Fetch Cloud SQL instances button:

3. And then associate the database with the instance: