db9 · Database db9.ai

Serverless Postgres, from the terminal.

One logical Postgres per tenant, without a reserved database process per tenant. Create a database, branch it like code — the schema and its data into an independent copy — then query it straight from your shell. File storage is built in and readable from SQL, so there's no S3 to wire up, and there's zero signup to start. Anonymous evaluation is capped at 5 databases and 2 concurrent branch creations; claim the account for production use.

Branch schema + dataFile storage, no S3Zero signupQuery from your shell
create · branch · query

Branch a database like a git branch.

sys9 db branch create forks the database schema and its rows 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.

schema + data zero signup query from shell
db9
# create a database, no signup (db9 makes an anonymous account)
$ sys9 db create --name my-app

# branch: a full copy of its schema and data
$ 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, or read them from SQL with the fs9 extension. Mounting requires a supported FUSE backend (macFUSE on macOS); see the db9 agent guide 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 under an anonymous 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 with a copy of the source schema and data (at most 2 branch creations run concurrently). 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.