cli

# Publish to Maincloud (default)
spacetime publish my-database --yes
 
# Publish to local server
spacetime publish my-database --server local --yes
 
# Clear database and republish
spacetime publish my-database --delete-data=always --yes

# SQL queries
spacetime sql my-database "SELECT * FROM users"
spacetime sql my-database --interactive   # REPL mode
 
# Call reducers (each argument is a separate positional arg)
spacetime call my-database my_reducer '"value"' '123'
 
# Subscribe to changes
spacetime subscribe my-database "SELECT * FROM users" --num-updates 10
 
# View logs
spacetime logs my-database -f              # follow logs
spacetime logs my-database -n 100          # up to 100 log lines
 
# Describe schema
# (without --json, output is human-readable text)
spacetime describe my-database --json
spacetime describe my-database tables --json   # also views, reducers, procedures, routes, env, types
spacetime describe my-database tables users --json
spacetime describe my-database reducers my_reducer --json

# List databases
spacetime list
 
# Delete database
spacetime delete my-database
 
# Rename database
spacetime rename <database-identity> --to new-name

# List configured servers
spacetime server list
 
# Add server
spacetime server add local --url http://localhost:3000 --default
spacetime server add myserver --url https://my-spacetime.example.com
 
# Set default server
spacetime server set-default local
 
# Test connectivity
spacetime server ping local
 
# Start local instance
spacetime start
 
# Clear local data
spacetime server clear

# Login (opens browser)
spacetime login
 
# Login with token
spacetime login --token <token>
 
# Show login status
spacetime login show
 
# Logout
spacetime logout

spacetime login
# Or use --anonymous for public operations

spacetime server ping <server>
# For local: ensure spacetime start is running

# Clear data and republish
spacetime publish my-db --delete-data=always --yes

# Check Rust/C# toolchain
rustup show
# For Rust modules, ensure wasm32-unknown-unknown target
rustup target add wasm32-unknown-unknown