Google Database Migration API

Name: Database Migration API
Brand: Database Migration API
Availability: InStock

✓ Official Vendor SpecStorageDatabaseoauth241 EndpointsREST

Install Jentic One Beta

Connect the Database Migration API to your agent

Jentic One is a self-hosted execution layer for AI agents. It lets your agent call the Database Migration API, or any other public or private API you need. You set the rules, the agent never sees your credentials, and every call is logged.

Two steps, two machines. Install the instance in a safe environment, then register your agent from wherever it runs.

Step 1: Jentic One Host machine

# On the machine that will host your Jentic One instance:
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh

Step 2: Agent machine

# On the machine where your agent runs (keep this separate from the instance):
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh
jentic register       # connects your agent to your Jentic One instance

Jentic One is in public beta. The setup above keeps your agent separate from the instance, which is what you want before using real credentials: an agent running as the same OS user as Jentic One can read its stored keys directly. Just evaluating? A single local install is fine to start. See the secure deployment guide for the tiers.

Capabilities

What an agent can do with Database Migration API.

Create connection profiles for MySQL, PostgreSQL, Oracle, and SQL Server source databases

Run continuous-replication migration jobs from on-prem or cloud sources to Cloud SQL or AlloyDB

Convert Oracle and SQL Server schemas to PostgreSQL using conversion workspaces

GET STARTED

Start building with Database Migration API

Explore with Jentic

View OpenAPI Document

For Agents

Drive database migrations into Cloud SQL, AlloyDB, and Spanner programmatically. Lets agents create connection profiles, run migration jobs, and manage conversion workspaces without the Cloud Console.

Use for: I need to migrate a MySQL database from on-prem to Cloud SQL, Create a connection profile for a PostgreSQL source database, Promote the migration job to cut over to the destination, Convert an Oracle schema to PostgreSQL inside a conversion workspace

Not supported: Does not run application data backfills, perform query-level transformations, or replicate non-database event streams - use for managed homogeneous and heterogeneous database migrations into Cloud SQL, AlloyDB, and Spanner only.

Use Cases

Patterns agents use Database Migration API for, with concrete tasks.

★ Continuous-Replication Migration to Cloud SQL

Move a production MySQL or PostgreSQL database from on-prem or another cloud into Cloud SQL with continuous replication and a near-zero-downtime cutover. The API creates source and destination connection profiles, starts the migration job in DUMP_AND_CONTINUOUS mode, and exposes a promote operation when the team is ready to switch traffic. Most one-database migrations complete in hours plus the replication lag.

Create source and destination connection profiles, start a migration job named 'mysql-prod-to-cloudsql' in CONTINUOUS mode, verify it, and promote when source and destination report consistent state

Heterogeneous Oracle-to-PostgreSQL Conversion

Convert an Oracle schema to PostgreSQL by creating a conversion workspace, importing the source DDL, applying conversion rules, and exporting the converted schema. The API exposes describeDatabaseEntities and describeConversionWorkspaceRevisions to inspect the conversion result before applying it to a destination AlloyDB or Cloud SQL for PostgreSQL instance.

Create a conversion workspace 'oracle-finance-cw', describe its database entities, apply conversion to a PostgreSQL destination, and report any UNSUPPORTED entities back to the user

Migration CI/CD with Verification Gates

Wire migration jobs into a release pipeline: createConnectionProfile and createMigrationJob from the build environment, verifyMigrationJob as a quality gate, and promote only when the gate passes. The API's restart and stop operations let pipelines retry transient failures or abort cleanly. This supports repeatable database refreshes for staging environments.

Run verifyMigrationJob on 'staging-refresh-2026-06', wait for the operation to complete, and only call promoteMigrationJob if verification reports OK

AI Agent Migration Operator

An AI agent can drive database migrations end-to-end through Jentic without touching the Console. Jentic search returns the matching connection-profile, migration-job, or conversion-workspace operation, the agent loads its schema, and Jentic executes against datamigration.googleapis.com using vault-stored credentials. This removes the multi-day OAuth and long-running-operation plumbing work.

Use Jentic to search 'create a database migration job', load the createMigrationJob schema, and execute it from the configured source profile to a Cloud SQL destination

Key Endpoints

41 endpoints — the google cloud database migration api drives the lifecycle of homogeneous and heterogeneous database migrations into cloud sql, alloydb, and spanner.

METHOD

PATH

DESCRIPTION

POST

/v1/{+parent}/connectionProfiles

Create a source or destination connection profile

POST

/v1/{+parent}/migrationJobs

Create a migration job

POST

/v1/{+name}:verify

Verify a migration job before promotion

POST

/v1/{+name}:promote

Promote the migration job to cut over

POST

/v1/{+migrationJob}:generateSshScript

Generate SSH script for self-managed source

POST

/v1/{+conversionWorkspace}:describeDatabaseEntities

Inspect entities in a conversion workspace

POST

/v1/{+parent}/connectionProfiles

Create a source or destination connection profile

POST

/v1/{+parent}/migrationJobs

Create a migration job

POST

/v1/{+name}:verify

Verify a migration job before promotion

POST

/v1/{+name}:promote

Promote the migration job to cut over

POST

/v1/{+migrationJob}:generateSshScript

Generate SSH script for self-managed source

Why Jentic?

Three things that make agents converge on Jentic-routed access.

Credential isolation

Your Google OAuth credential is stored once, encrypted, by your own Jentic One instance and injected at execution time. It never enters the agent's prompt, logs, or context.

Intent-based discovery

Agents search Jentic by intent such as 'create a database migration job', and Jentic returns the matching Database Migration operation with its input schema so the agent calls the right endpoint without browsing the reference docs.

Time to first call

FAQs

Specific to using Database Migration API through Jentic.

What authentication does the Database Migration API use?

The Database Migration API uses OAuth 2.0 with the cloud-platform scope. Through Jentic the OAuth client and refresh tokens live in your Jentic One instance and the agent receives short-lived scoped tokens, so raw Google credentials never enter the agent context.

Can I migrate Oracle to PostgreSQL with this API?

Yes. Create a ConversionWorkspace, import the Oracle DDL, call describeDatabaseEntities to inspect the converted entities, and apply the conversion to a PostgreSQL destination (Cloud SQL for PostgreSQL or AlloyDB). Heterogeneous MySQL-to-PostgreSQL is also supported through the same workflow.

What are the rate limits for the Database Migration API?

Google enforces standard Cloud quotas on datamigration.googleapis.com: per-project rate limits on read/write calls and limits on concurrent migration jobs per region. Quotas are visible in the Cloud Console under IAM and admin, quotas, filtered to datamigration.googleapis.com.

How do I cut over a migration through Jentic?

Search Jentic for 'promote a database migration job', load the schema for POST /v1/{+name}:promote, and execute with the migration-job resource name. Jentic returns the long-running operation; poll until done before pointing application traffic at the destination.

Is the Database Migration API free?

Migrations into Cloud SQL are free for the migration phase; you pay only the standard Cloud SQL or AlloyDB charges of the destination instance plus any egress from the source. Migrations into other targets and ongoing replication beyond cutover may attract additional fees per the official pricing page.

How do I connect to a self-managed source database?

Call POST /v1/{+migrationJob}:generateSshScript or generateTcpProxyScript to retrieve a script that opens a reverse-SSH tunnel or TCP proxy from your bastion host to Google's migration service. Run the script on the bastion before starting the migration job.

Google Database Migration API

Connect the Database Migration API to your agent

Capabilities

Start building with Database Migration API

Use Cases

Key Endpoints

Why Jentic?

Related APIs

FAQs