Databases

SchemaHero supports multiple database engines. Each database section includes connection setup, table schema syntax, and database-specific features.

Select a database from the sidebar to view its documentation.

Supported Databases

Schema Definition

Each database has its own schema syntax under the database key:

apiVersion: schemas.schemahero.io/v1alpha4
kind: Table
metadata:
  name: users
spec:
  database: myapp
  name: users
  schema:
    postgres:     # or mysql, sqlite, cassandra, cockroachdb, rqlite, timescaledb
      primaryKey: [id]
      columns:
        - name: id
          type: uuid
        - name: email
          type: varchar(255)

See each database's Tables page for complete schema reference.