db9 · Postgres database db9.ai

Serverless Postgres, from the terminal.

Create a database, branch it like code — the db, its data, and its files together — then query it straight from your shell. File storage is built in, so there's no S3 to wire up, and there's zero signup to start.

Branch db + data + filesFile storage, no S3Zero signupQuery from your shell
create · branch · query

Branch a database like a git branch.

sys9 db branch create forks the database, its rows, and its files into an isolated copy in one command — perfect for a review environment or a risky migration. Each branch is a separate database with its own credentials. Query it straight from your shell with sys9 db sql.

db + data + files zero signup query from shell
db9
# create a database without an account
$ sys9 db create --name my-app

# create an independent database from its data and files
$ sys9 db branch create my-app --name review

# inspect progress; creation can return CLONING
$ sys9 db db status review

Repeat the status check until ACTIVE. If it reports CREATE_FAILED, stop and investigate the failure. Only after ACTIVE, run:

$ sys9 db sql review -q "SELECT 1"
file storage built in

Files live with the database. No S3.

Every database has a filesystem attached. Copy files in with sys9 db fs cp, or mount a database's files as a local folder with sys9 db fs mount and work on them like they're on disk. Branch the database and its files come along for the ride. Mounting requires a supported FUSE backend; see the filesystem reference for platform setup.

fs cp fs mount no separate object store
db9
# replace ./data.csv with an existing local file
$ sys9 db fs cp ./data.csv my-app:/imports/data.csv

# optional: mount files after installing the required FUSE backend
$ sys9 db fs mount my-app ~/db9-files
how it works

Create. Branch. Query.

db9 treats a database the way you treat a repo — something you fork, work in, and throw away.

01 · Create

One command, no signup

sys9 db create --name my-app creates a Postgres database without an account. Keep the generated credentials; choose a name that is unused in your database list.

02 · Branch

Fork the whole thing

sys9 db branch create my-app --name review creates an independent database named review, including its source data and files. Creation is asynchronous: check sys9 db db status review until ACTIVE, or stop on CREATE_FAILED.

03 · Query

Straight from the shell

After the branch is ACTIVE, sys9 db sql review -q "SELECT 1" runs SQL against the new database from your terminal. Agents can use the same CLI or connect through the database protocol.

get started

Create your first database.

Install the sys9 CLI and create a database without signup. Follow the db9 quick start to keep your credentials and run your first query.