Connecting to Amazon RDS
SchemaHero can manage a MySQL or Postgres schema running in RDS without any additional requirements.
The recommended way to connect SchemaHero to RDS is to deploy a secret to your cluster that contains the database connection credentials.
apiVersion: v1 kind: Secret metadata: name: rds-postgres namespace: default stringData: uri: postgresql://user:firstname.lastname@example.org/db-name?connect_timeout=10&application_name=schemahero
Then, deploy the database connection using:
apiVersion: databases.schemahero.io/v1alpha4 kind: Database metadata: name: rds-postgres namespace: default spec: connection: postgres: uri: valueFrom: secretKeyRef: key: uri name: rds-postgres
Once these are deployed, you can deploy tables using the standard SchemaHero tools, and the schemas will be applied to the RDS instance defined in the secret.