Skip to content

Clarification and roadmap request: schema migration strategy and zero-downtime support in multi-pod environments #4347

Closed as duplicate

Description

@ajinkya-vaze

Hi ADK team,

I’m using the Python ADK with a CockroachDB session store in a Kubernetes deployment. As we upgrade ADK versions over time, we’ve observed that the database schema for session tables evolves, but there isn’t a built-in mechanism to reliably manage those changes.

Looking at existing issues (for example #3343, #3520, and the bug in #3681), it appears that:

We need to manually discover and apply ALTER TABLE migrations when ADK updates add or change columns.

The current ADK migration support tends to only create new tables, not handle column changes or schema evolution automatically.

I have two specific questions about the current strategy and future plans:

Schema management strategy:
When ADK evolves the session or other internal schemas (e.g., new columns, dropped fields), what is the recommended approach for reflecting those changes in existing database instances? Will ADK provide incremental migration scripts (for example, Alembic migrations) that can be applied without data loss? Or will each schema update result in a new schema version requiring manual migration and downtime?

In other words, is there a roadmap toward built-in schema migrations that handle altering existing tables rather than requiring operators to write and apply manual SQL migrations when upgrading ADK versions?

Zero-downtime migrations:
In scalable multi-pod environments (e.g., Kubernetes), downtime during schema updates is costly. Are there plans to support zero-downtime database migrations, either in ADK itself (via migration tooling) or recommendations for integrating with external tools/workflows that can perform safe, online schema changes? CockroachDB supports live schema changes at the database layer, but application-level schema management (including coordination across pods) is currently manual.

We’re keen to adopt a long-term strategy that avoids unexpected breakages during ADK upgrades and keeps session persistence robust across versions. Any guidance on planned features or recommended practices would be very helpful.

Thanks!

Activity

  1. added
    services[Component] This issue is related to runtime services, e.g. sessions, memory, artifacts, etc
    on Feb 1, 2026
  2. added theissue type on Feb 1, 2026
  3. self-assigned this
    on Feb 2, 2026
  4. achilleasatha commented on Feb 3, 2026

    @achilleasatha

    Thanks @ajinkya-vaze for raising this. Bringing in alembic is my intent via #3343 it would be good to know there is support from the maintainers and the community on this.

    I was planning to also provide reference docs for helm hooks to operate this in k8s - what you're describing here is exactly our problem with the existing sdk not providing a graceful way to manage this.

    Will comment back here when I raise the new issue with the draft RFC - I think it's probably worth consolidating all the open issues into 1.

  5. wuliang229 commented on Feb 4, 2026

    @wuliang229
    Collaborator

    Consolidating this issue to #3343

  6. achilleasatha commented on Feb 5, 2026

    @achilleasatha

    @ajinkya-vaze Raised draft RFC #4387 relating to issue #3343 and #4347
    Feedback most welcome

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Labels

services[Component] This issue is related to runtime services, e.g. sessions, memory, artifacts, etc

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions