Database

Every Stack namespace gets its own Postgres cluster via CloudNativePG. You interact with it the same way you would any Postgres server.

Connect with kubectl + psql

The demo manifest (demo.stack.yaml) creates a database in the stack-demo namespace.

Open a psql session as the default user, then connect to stack-demo:

kubectl -n stack-demo exec -it stack-demo-db-cluster-1 -- psql -d stack-demo

Create a table and insert data

create table instruments (
  id bigint primary key generated always as identity,
  name text not null
);

insert into instruments (name)
values
  ('violin'),
  ('viola'),
  ('cello');

select * from instruments;

You should see

CREATE TABLE
INSERT 0 3
 id |  name  
----+--------
  1 | violin
  2 | viola
  3 | cello
(3 rows)

Roles Stack creates for you

Stack bootstraps several roles so different services can connect safely:

• db-owner for migrations and admin tasks.
• application_user for your app runtime.
• application_readonly for read-only access.
• authenticator and anon for PostgREST.
• service_role and authenticated for auth-aware workloads.

Connection strings live in the database-urls secret and are wired into your app when you set database_url, migrations_database_url, or readonly_database_url in your manifest.

Quick checks

kubectl -n stack-demo get pods
kubectl -n stack-demo get secret database-urls -o yaml