Docs
Getting Started

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:

Terminal
silos db connection-string my-app

It looks like this:

postgres://user:password@db-xxxx.silos.sh/main?sslmode=require

You 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:

Terminal
silos connect my-app

You'll drop straight into a psql prompt:

main=>

Connect with psql directly

If you'd rather use psql yourself, pass the connection string:

Terminal
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=require

That means you can point a preview deployment or a test run at a branch just by swapping the host.

Next steps

On this page