Connect to your database
Get a connection string and open a session with psql or the Silos CLI.
Silos speaks the standard PostgreSQL wire protocol, so anything that talks to
Postgres talks to Silos — psql, your application's driver, your ORM. The only thing
you need is a connection string.
Get a connection string
Fetch the connection string for a database with the CLI:
silos db connection-string my-appIt looks like this:
postgres://user:password@db-xxxx.silos.sh/main?sslmode=requireYou can also copy it from the database page in the Console.
Connections are encrypted with TLS. Keep sslmode=require in the connection string —
Silos does not accept unencrypted connections.
Connect with the CLI
The fastest way to get an interactive session is the connect command, which opens
psql against the database for you:
silos connect my-appYou'll drop straight into a psql prompt:
main=>Connect with psql directly
If you'd rather use psql yourself, pass the connection string:
psql "postgres://user:password@db-xxxx.silos.sh/main?sslmode=require"Connect from your app
Because the engine is real PostgreSQL behind a standard wire protocol, your existing
drivers and ORMs connect the same way they would to any Postgres — pg (node-postgres),
psycopg, SQLAlchemy, Prisma, Drizzle, Kysely, and friends. Point them at the Silos
connection string and they work like they always have. See
Connecting for driver- and ORM-specific guidance.
Branch endpoints
Each branch of a database gets its own endpoint. The host encodes the branch name:
postgres://user:password@db-xxxx--branchname.silos.sh/main?sslmode=requireThat means you can point a preview deployment or a test run at a branch just by swapping the host.