Skip to main content
Community
Q&A

Database testing strategies when your team does not own the database schema?

Ajitesh Mohanta
Ajitesh MohantaAmbassador
Apr 18, 2026 948 0
We're an SDET team testing a service that uses a database we don't own — the schema is managed by a platform team and changes without always notifying us. Current problem: when the platform team adds a NOT NULL column or changes a type, our test fixtures silently start inserting bad data and tests give false positives. Is there a standard approach to: 1. Detecting schema drift between our fixtures and the live schema? 2. Getting notified when schema changes affect our test data? 3. Making fixture data generation schema-aware? We use SQLAlchemy + alembic but don't control the migrations.

No replies yet. Be the first to answer this question!

Join the discussion

Sign in to join the discussion

Sign in
Database testing strategies when your team does not own the database schema? — Community | QABash