Schema Governance Platform

Every Schema Shifts. Governed.

The database operations layer for AI-native engineering teams. Versioned migrations, immutable audit logs and real-time schema intelligence for Apache Cassandra, Google Cloud Spanner, Google Bigtable, Amazon DynamoDB, TiDB, CockroachDB, YugabyteDB, Vitess, and SingleStore. One platform. Nine databases. Zero schema drift.

cassachange — production deploy
$ cassachange deploy --profile prod --tag 2.1.0
[secrets] resolved 3 keys via azure-keyvault
[lock] acquired global (host:a4f3b1 run:9e2c)
[RUN] V1.0.0__create_users.cql 44ms
[RUN] V1.1.0__add_orders.cql 29ms
[SKIP] V1.2.0__add_profiles.cql already applied
[RUN] R__users_by_email.cql checksum changed
[audit] 3 events written → change_history
[notify] Slack → deploy_success
✓ myapp_prod: run 3 | skip 1 | errors 0
$
Validated on Apache Cassandra AstraDB ScyllaDB Azure Managed Cassandra Amazon Keyspaces Google Cloud Spanner Google Bigtable Amazon DynamoDB TiDB · TiDB Cloud CockroachDB · CRDB Cloud Azure CosmosDB Bigtable Proxy YugabyteDB · YB Aeon Vitess · PlanetScale SingleStore Helios
9
Database Engines
15+
Validated Platforms
LWT
Distributed Locking ((or engine-specific locking)
0
JVM Required
SOC2
Audit Ready
Products

Nine Tools.
One Platform.

Each tool is purpose-built for its database — no leaky abstractions, no lowest-common-denominator API. All share the same CLI contract, the same history table schema, and the same audit log format. SQL, NoSQL, NewSQL, wide-column, distributed OLAP — every major distributed database category covered.

Your AI assistant is fast everywhere except the database. Schema mistakes on distributed systems are catastrophic, expensive to reverse, and impossible to audit after the fact. SchemaShifts closes that gap — giving Claude, Copilot, and Cursor native access to migration state, schema health, capacity risk, and compliance history across your entire data infrastructure.

Cassandra-compatible databases
cassachange

CQL-native schema migration for Cassandra and every Cassandra-compatible database. Versioned scripts, LWT distributed locking, multi-keyspace deploys, and an MCP server for AI-assisted development.

pip install cassachange
pip install cassachange-enterprise
Versioned, repeatable, always, undo scripts
LWT distributed deploy lock
23-rule schema analyser (enterprise)
MCP server for AI agents
Learn more →
Google Cloud Spanner
spanchange

SQL DDL migration tool purpose-built for Cloud Spanner. Handles Spanner's async DDL operations, interleaved tables, TTL policies, VECTOR indexes, and property graphs — with a full history and audit trail.

pip install spanchange-enterprise
Spanner DDL — interleave, TTL, vector, graph
Serialisable transaction locking
Shadow test replay against emulator
Multi-database pipeline deploys
Learn more →
Google Cloud Bigtable
bigtablechange

YAML-driven schema migration for Bigtable — tables, column families, GC policies, and app profiles. Unique column registry for schemaless governance, drift detection across 9 categories.

pip install bigtablechange-enterprise
GC policy advisor + drift detection
Column registry with PII tagging
9 drift categories incl. COLUMN_REGISTRY
Row key hotspot linter
Learn more →
Amazon DynamoDB
dynamochange

The only governance tool that treats DynamoDB schema as code. GSI lifecycle management, TTL policies, table class, streams — versioned, drift-detected, and audited. Other tools have no DynamoDB support.

pip install dynamochange
GSI lifecycle — create, backfill, monitor, drop
TTL, streams, table class, tags as code
YAML migration scripts
Credential isolation per profile
Learn more →
TiDB · TiDB Cloud · TiDB Serverless
tidbchange

First-class TiDB migration tool — goes beyond SQL DDL to version TiFlash replicas, placement policies, and resource groups natively in YAML. Handles Serverless tier feature gaps with PARTIAL status tracking.

pip install tidbchange
SQL + YAML hybrid migrations
TiFlash replica lifecycle management
Resource group versioning (OLTP/OLAP)
TiDB Cloud Serverless PARTIAL support
Learn more →
CockroachDB · CockroachDB Cloud
cockroachchange

The only migration tool that manages CockroachDB multi-region topology as code. REGIONAL BY ROW locality, survival goals, zone configs — versioned and drift-detected. Includes DDL job monitoring other tools ignore.

pip install cockroachchange
Multi-region locality & survival goals as YAML
DDL background job monitoring
Zone config lifecycle management
Hash-sharded index scaffolding
Learn more →
YugabyteDB · YugabyteDB Cloud
ybchange

The only migration tool that manages YugabyteDB's colocation, geo-partitioned tablespaces, and xCluster DDL sequencing as code. Goes beyond psycopg2 to handle YB-native YAML migrations other tools ignore entirely.

pip install ybchange
Tablegroup & colocation_id YAML migrations
Geo-partitioned tablespace lifecycle
xCluster DDL sequencing hints
YB-aware psycopg2 param workaround
Learn more →
Vitess · PlanetScale · VTGate
vitesschange

Vitess-native migration tool — versions VSchema (vindexes, sharding keys, sequence tables) as YAML migrations. Polls Online DDL per shard, detects vtcombo for local dev, and keeps migration history in a dedicated keyspace.

pip install vitesschange
VSchema migration as YAML (vindexes, sharding)
Online DDL per-shard polling & failure details
vtcombo auto-detection → direct DDL fallback
Dedicated history keyspace isolation
Learn more →
SingleStore · SingleStore Cloud
singlestorechange

The first migration tool built around SingleStore's distributed SQL model — versions SHARD KEY, SORT KEY (columnstore), and VECTOR INDEX as YAML. 7-rule analyser catches sharding anti-patterns other tools can't even see.

pip install singlestorechange
SHARD KEY + SORT KEY YAML migrations
VECTOR INDEX (HNSW/IVF) lifecycle
7-rule analyser: S001–S007 anti-patterns
Columnstore vs rowstore type tracking
Learn more →
Compliance Infrastructure

Your Schema Migrations
Are an Audit Trail.

When a SOC2 auditor or HIPAA assessor asks who changed the schema, when, and whether it was approved — cassachange, spanchange, and bigtablechange answer automatically. No additional tooling. No manual evidence gathering.

CC6 · CC7
📋
Immutable Audit Log

Every deploy, rollback, script execution, and lock event is written append-only to the history database. Rows are never updated or deleted. Operator identity, timestamp, run ID, and outcome — captured automatically on every migration.

CC6.1 · Secrets
🔐
Zero Credential Exposure

Passwords, SSL certificates, and AstraDB secure bundles are pulled from HashiCorp Vault, AWS Secrets Manager, or Azure Key Vault at runtime. Nothing sensitive touches disk on a CI/CD runner. URIs never appear in logs.

Change Management
🔀
Version-Controlled Changes

Every schema change is a versioned, checksummed file committed to source control before it runs. No ad-hoc changes can be applied without appearing in migration history. Deploy fencing with tags provides release-level traceability.

CC7.5 · Recovery
↩️
Tested Rollback Procedures

Every versioned migration ships with a paired undo script. Any change can be reversed in a single command with a full audit record. This is a documented, tested recovery procedure — exactly what incident response controls require.

Policy Enforcement
📏
Policy-as-Code Schema Contracts

Encode naming conventions, mandatory TTL on sensitive tables, prohibited patterns, and PII column requirements as version-controlled rules. Enforced as CI gates with GitHub annotation output. Automated policy enforcement is accepted audit evidence.

Availability
🔒
Concurrent Deploy Prevention

Distributed locking (Cassandra LWT, Spanner serialisable transactions, Bigtable advisory lock) prevents two operators or CI pipelines from running simultaneously. No partial schema state. No conflicts. Availability controls satisfied.

Sample audit log — append-only · never modified
Timestamp Run ID Event Operator Script Detail
2026-03-23 09:14:02 9e2c8f1a DEPLOY_START ci-runner-07 tag=2.1.0 dry_run=false
2026-03-23 09:14:03 9e2c8f1a SCRIPT_RUN ci-runner-07 V1.0.0__create_users.cql 44ms SUCCESS
2026-03-23 09:14:03 9e2c8f1a SCRIPT_RUN ci-runner-07 V1.1.0__add_orders.cql 29ms SUCCESS
2026-03-23 09:14:04 9e2c8f1a DEPLOY_END ci-runner-07 errors=0 tag=2.1.0
Enterprise Feature

AI-Assisted Schema Intelligence

The enterprise edition ships a 23-rule schema analyser, a CI/CD contract enforcement gate, and a real-time CI/CD analytics dashboard — all surfaced natively inside Claude, Copilot, and Cursor via the MCP server. Catch anti-patterns before they reach production, enforce policy as code, and monitor deploy health across every keyspace.

Schema Analyser · 23 Rules

Instant Anti-Pattern
Detection

Every table in every keyspace is scored against 23 rules covering partition hotspots, missing clustering columns, absent temporal anchors, TTL gaps, and ALLOW FILTERING risks. Each finding includes actionable CQL advice — not just a score.

QS001 · ALLOW FILTERING risk
SA003 · No temporal anchor / no TTL
QS004 · No clustering — point lookups only
Contract checks and remediation dashboard showing CI gate blocked with hard failures and warnings per table
CI/CD analytics dashboard showing deploy success rates, slowest scripts, and per-keyspace breakdown
Policy-as-Code · CI Gate

Contract Checks
& Remediation

Encode your team's schema rules as version-controlled contracts — naming conventions, mandatory TTL, prohibited anti-patterns, PII column requirements. Enforced as a hard CI gate with exit code 2 on failure. Fully automated, fully auditable.

CI GATE · BLOCKED · exit code 2
22 rules enforced · 4 hard failures · 14 warnings
Both keyspaces · 8 tables affected
CI/CD Analytics · 90-day Window

Deploy Health
at a Glance

The MCP server surfaces a real-time CI/CD analytics dashboard — total deploys, success rates, p95 deploy times, slowest scripts per keyspace, and a per-keyspace breakdown. Ask Claude for your deploy health and get a live visual answer.

SUCCESS RATE
100%
AVG DEPLOY
15.1s
Schema analysis dashboard showing 9 tables analysed with criticals, warnings, and per-table rule findings
Schema Intelligence is an Enterprise Feature
23-rule analyser · policy contracts · CI gate · CI/CD analytics · MCP Server
Request a Demo
AI-Native Development

MCP Servers.
Every Tool.

Every Schemashifts tool ships with a Model Context Protocol server — letting Claude, Cursor, and any MCP-compatible AI assistant query your schema history, run drift detection, validate migrations, and plan deployments without leaving the chat. Schema governance meets agentic AI.

MCP CAPABILITIES

What AI agents can do with Schemashifts MCP

Connect your AI assistant to any Schemashifts tool and unlock schema-aware conversations — ask about pending migrations, get drift reports, validate scripts before running them, or generate new migration files from a natural language description.

Query migration history and status
Run drift detection and schema analysis
Validate scripts offline without a database connection
Generate scaffolded migration files
Get pre-deploy risk advisories
Inspect audit logs and compliance records
MCP COVERAGE

Available across all nine tools

MCP servers for dynamochange, tidbchange, cockroachchange, ybchange, vitesschange, and singlestorechange are in active development. cassachange, spanchange, and bigtablechange MCP servers are available now. All follow the same tool schema and Claude Desktop configuration pattern.

● AVAILABLE
cassachange
Cassandra, AstraDB & beyond
● AVAILABLE
spanchange
Cloud Spanner
● AVAILABLE
bigtablechange
Cloud Bigtable
● AVAILABLE
dynamochange
Amazon DynamoDB
● AVAILABLE
tidbchange
TiDB / TiDB Cloud
● AVAILABLE
cockroachchange
CockroachDB
● AVAILABLE
ybchange
YugabyteDB
● AVAILABLE
vitesschange
Vitess / VTGate
● AVAILABLE
singlestorechange
SingleStore Helios
# Claude Desktop config
"mcpServers": {
  "cockroachchange": {
    "command": "cockroachchange-mcp"
  }
}
Editions

Community & Enterprise

The core migration engine is free and open source. The enterprise edition adds compliance infrastructure, schema intelligence, observability, and enterprise platform support.

Community
Free

Everything you need to run reliable schema migrations across Cassandra, Spanner, Bigtable, DynamoDB, TiDB, and CockroachDB in production.

✓  Deploy · rollback · validate · status · repair
✓  Versioned, repeatable, always, undo scripts
✓  Distributed locking
✓  CQL / SQL / YAML linters
✓  Dry run + JSON plan output
✓  Per-environment config profiles
✓  Release tagging + tag-based rollback
✓  Slack / Teams / webhook notifications
✓  GitHub Actions CI/CD integration
✓  MCP server for AI-assisted development
pip install cassachange
Enterprise

Everything in Community, plus compliance infrastructure, schema intelligence, observability, and support for Google Bigtable proxy, Azure CosmosDB, and Azure Keyspaces.

✓  Everything in Community
Security & Compliance
✓  Secret manager integration Vault · AWS SSM · AWS SM · Azure KV
✓  Immutable audit log SOC2 / HIPAA ready
✓  Policy-as-code schema contracts
Schema Intelligence
✓  23-rule schema scorer hotspots, anti-patterns, TTL gaps
✓  Live keyspace diff BREAKING / WARNING / INFO
✓  OLS growth projections 180-day horizon per table
Platform Extensions
✓  Azure CosmosDB for Cassandra
✓  ScyllaDB
✓  Azure Managed Cassandra
✓  Azure Keyspaces mTLS + AKV cert vault
✓  Google Bigtable proxy schema-map, proxy lint
✓  Priority support
pip install cassachange-enterprise
Contact: enterprise@schemashifts.com