Master databases of any size — without drowning in them.

Core®

Understand, automate and provision any database from its metadata.

• Reverse-engineer any supported database into a live model: every table, key and relationship, diagrammed in seconds.
• Explore and edit metadata and physical data together: diagrams, a filterable data dictionary with your own attributes, and related records at any depth with foreign-key lookups.
• Provision non-production databases as part of the platform: generate constraint-valid synthetic data, and save, compare, and restore datasets and snapshots from plain SQL.
• Automate with scripting, and with AI assistance: Xcase Assist answers from the documentation, Xcase Script turns plain language into reviewable scripts.

Xcase Core is included with every optional module - Evolve, Extract and Anonymize - and can also be licensed on its own.

Evolve®

Design and evolve the model, then synchronize, version and migrate from your own changes.

• Author and evolve the model: add tables, columns and relationships on the diagram, then synchronize - Xcase writes and submits the DDL.
• Keep model and database honest: integrity checks that find the broken rows your constraints never caught.
• Version your schema like source code: archive, compare and merge models, and commit them to Git as JSON.
• Migrate to a different DBMS: change the target and Xcase re-maps types and copies the data.

Includes Xcase Core.

Extract®

Extract compact, referentially complete subsets of production data.

• Take a compact, referentially complete slice of production: pick the tables, set the row counts, and Xcase follows every relationship.
• Every parent, child, and lookup row the slice depends on is included - and nothing that it doesn't need.
• Dramatic volume reduction with every foreign key intact, ready for development, test, and diagnosis.

Includes Xcase Core.

Anonymize®

Anonymize sensitive data consistently, with plain-SQL output and audit documentation.

• Discovery scans your schema for names, emails, phone numbers, and card numbers, and scores each match.
• Group columns that mean the same thing and anonymize each value identically everywhere it appears, so joins and counts survive.
• The output is plain SQL: preview the conversions, inspect the script, run it here or in your own pipeline.
• Document what is anonymized, by which method, in which tables.

Includes Xcase Core.

Publish models and control access across the team, with concurrent licensing.

• Share knowledge and updates through published models: a publisher publishes, and every team member receives the same current version.
• Control who can do what: permissions set per user, down to data dictionary management.
• Administer the deployment: manager controls and concurrent licensing.

Available as an optional module with concurrent licensing.