# aimeos/upscheme

Database migrations and schema updates made easy

Repository: https://github.com/aimeos/upscheme
Canonical: https://ross.abutalabs.com/products/upscheme
Homepage: https://upscheme.org
Language: PHP
License: LGPL-3.0
License Family: copyleft
Topics: database, database-migrations, database-schema, migrations, php, sqlite, mysql, postgresql, sql-server, sqlsrv, sqlserver, database-schema-migration, database-management, db, sql, rdbms, schema, migration
Last push: 2026-07-29T09:04:41+00:00

## Health v2 (maintenance only)
Score: 75/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 95, release rhythm 35, longevity 100
- inputs: {"age_days": 2368, "days_push": 35, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2726, forks 5 (observed 2026-08-28T04:07:15.870530+00:00)

## What it is
Upscheme is a PHP library for database schema migrations and updates, letting developers define tables, columns, indexes, foreign keys, and sequences in one place. It automatically upgrades existing databases from any intermediate state to the expected schema and supports data migration between versions.

## Use cases
- manage database schema migrations in a PHP application
- upgrade database schema across deployments
- define tables and columns in code instead of SQL
- migrate data between application versions
- keep database state consistent across installations
- generate schema definitions from an existing database
- automate schema updates in continuous deployment pipelines

## When to choose
- you have a PHP application needing reliable, repeatable schema migrations
- you want declarative table/column definitions that auto-upgrade existing databases
- you deploy to cloud environments where consistent schema state matters
- you need multi-database support (MySQL, PostgreSQL, SQLite, SQL Server)

## When to avoid
- your project is not written in PHP
- you need a full ORM with query building and entity management
- you require destructive migrations that drop columns automatically (Upscheme avoids deletions for safety)

## Facets
- artifact type: library
- maturity: active
- function: database, orm
- domain: databases, developer-tools, backend
- platform: php, cross-platform
- tags: database-migrations, schema-management, db-schema, php-library, sql

## Member repositories
- aimeos/upscheme (main) score 75

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:15.870530+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T02:14:44.080643+00:00, confidence not recorded.
  - readme: https://github.com/aimeos/upscheme (fetched 2026-08-28T04:07:15.870530+00:00, sha 6eef456d1737)
  - homepage: https://upscheme.org (fetched 2026-08-29T09:57:50.982510+00:00, sha 9cf9f2b90bca)
- Data as of 2026-08-30T08:39:29.467469+00:00.