Appearance
Supported Databases
Migrata currently targets PostgreSQL. This is the only dialect with full support for schema inspection, diff generation, and migration execution.
PostgreSQL
All features are fully implemented:
- Schema inspection (tables, columns, indexes, constraints, enums, views, materialized views, functions, stored procedures, partitions)
- SQL generation for all DDL operations
- Schema diffing and comparison
- Safe cast multi-step migrations
- Advisory locking
- Dev-database validation via Docker
- Table partition support
- Enum management
Connection format:
postgresql://user:password@host:5432/database| Component | Description |
|---|---|
postgresql:// | The scheme prefix identifying the database type |
user | The database user name |
password | The password for the database user |
host | The database server address (e.g., localhost, 127.0.0.1, or a remote host) |
5432 | The port the database server is listening on (default PostgreSQL port) |
database | The name of the database to connect to |