The stitchdb command line tool: local development, migrations, TypeScript types, Edge Functions, secrets and preview branches.
The stitchdb CLI runs your whole project on your machine, keeps your schema in migration files next to your code, and deploys migrations and functions to StitchDB from your terminal or CI.
npm install -g stitchdb-cli
stitchdb login
stitchdb init
stitchdb link --project-ref <project-ref>Install and log in
Install the CLI and connect it to your account with an access token.
Local development
Postgres, Auth, REST, Realtime, Storage, Edge Functions and a local Studio on your machine.
Migrations
Write schema changes as SQL files and push them to your project.
TypeScript types
Generate a Database type for stitchdb-js from your schema.
Edge Functions
Create, serve locally and deploy functions; manage secrets.
CI and GitHub Actions
A preview branch for every pull request, production deploys on merge.
Import from Postgres
stitchdb import: copy another Postgres database into a project, live or once.