CLI reference

All commands read credentials from .env.local; to override, pass the global flags before the command (result --url <url> --key <key> <command>). Run result <command> --help for full flags.

init

result init

Verifies credentials, persists backend rules into AGENTS.md/CLAUDE.md. Idempotent - re-run any time.

status

result status

Tables (with row counts), buckets, functions and auth at a glance. Run this before creating anything - it may already exist.

db

result db tables                 # list tables
result db schema posts           # one table's columns as JSON

db create-table

result db create-table posts \
  -c "title:string:required" \
  -c "user_id:uuid"

Column spec: name:type[:required][:unique]
Types: string, integer, float, boolean, datetime, date, json, uuid
id, created_at, updated_at are added automatically - never spec them
RLS is on by default; a user_id uuid column scopes rows to the signed-in user. --no-rls for shared/public data.

db migrate

result db migrate --name add-posts-index --sql "CREATE INDEX idx_posts_title ON posts (title);"
result db migrate --name setup-pgvector --file ./migration.sql

Raw SQL for anything create-table can’t express: indexes, custom RLS policies, triggers, extensions (pgvector). Versioning is automatic; the migration already runs in one transaction, so never write BEGIN/COMMIT.

result db migrations             # list applied migrations

storage

result storage buckets
result storage create-bucket uploads              # public: files get stable URLs
result storage create-bucket private-docs --private   # private: use signed URLs

realtime

result realtime channels
result realtime add-channel "chat:%" --description "chat rooms"

% is a wildcard - chat:% covers chat:room-1, chat:room-2, etc. Clients cannot subscribe until a pattern covers the channel.

functions

result functions list
result functions deploy my-fn --file fn.ts    # creates, or updates if it exists

The function runs at $NEXT_PUBLIC_BACKEND_URL/functions/my-fn.

secrets

result secrets list                  # your keys only, values never shown
result secrets set STRIPE_KEY=sk_... OPENWEATHER_KEY=...

Read inside functions with Deno.env.get("STRIPE_KEY"). Treat secrets as permanent - deletion is unreliable on current backend versions.

payments

result payments status stripe
result payments connect stripe --env test --secret-key sk_test_...
result payments connect razorpay --env test --key-id rzp_test_... --secret-key ...

Providers: stripe, razorpay. Environments: test, live. Razorpay needs both --key-id and --secret-key; Stripe only --secret-key. Webhooks are configured automatically on connect.

auth

result auth users                    # admin view of signed-up users

logs

result logs                          # list sources
result logs backend.logs --limit 20  # read one source

Getting started

SDK

CLI

Guides

init

status

db

db create-table

db migrate

storage

realtime

functions

secrets

payments

auth

logs

​init

​status

​db

​db create-table

​db migrate

​storage

​realtime

​functions

​secrets

​payments

​auth

​logs

init

status

db

db create-table

db migrate

storage

realtime

functions

secrets

payments

auth

logs