Create a cli environment for supabase.
The Docker environment to be used for construction is obtained from the latest repository of supabase.
Usage: spabase-cli [options] [command]
Options:
-V, --version output the version number
-h, --help display help for command
Commands:
init Initialize supabase
start Launch supabase
stop Stop supabase
restart Restart supabase
remove Remove supabase
update Update supabase
reset Database initialization
info View access to supabase
regions List of region
backup <filename> Backup database
restore <filename> Restore database
user [command]
create <email> <password> Create a user
list Displaying the user list
migration [command]
create [name] Create migration
-t, --tableName <tableName> Output table name
up Apply migrations
remote [command]
restore [options] <filename> Restore remote databases
-a, --host <host> Host address of database
-p, --password <password> Password for database
backup [options] <filename> Backup remote databases
-a, --host <host> Host address of database
-p, --password <password> Password for database
migration [options] Migration remote databases
-a, --host <host> Host address of database
-p, --password <password> Password for database
reset [options] Reset the remote
-a, --host <host> Host address of database
-p, --password <password> Password for database
user [command]
create <email> <password> Create a remote user
-u, --url <url> Url of supabase
-k, --service_role <service_role> Service role of supabase
list [options] Display of remote user list
-u, --url <url> Url of supabase
-k, --service_role <service_role> Service role of supabase
project
list [options]
-t, --token <accessToken> AccessToken
create [options] name dbpass
-t, --token <accessToken> AccessToken
-p, --plan <plan> Plan of project
-r, --region <region> Region of project
-o, --org <org> Organization of project
organization
list [options]
-t, --token <accessToken> AccessToken
help [command] display help for command
Remote commands refer to the value of supabase/.env.remote
url=https://xxxxx.supabase.co
service_role=xxxx
db_password=xxxx
access_token=xxxx
You will need superuser privileges, so run the following command from SQLEditor on the web.
alter role postgres with superuser;
Remote operation is an experimental feature.
supabase-cli init
For the second and subsequent runs, the file is updated.
- https://github.com/supabase/supabase/tree/master/docker
.gitignore
will not be overwritten
- https://github.com/supabase/storage-api/tree/master/migrations/tenant/
- https://github.com/supabase/realtime/tree/master/server/priv/repo/migrations
- If the file already exists, it will not be overwritten
- supabase/docker/.env
- supabase/docker/volumes/api/kong.yml
Recalculation of AccessKey by JWT_SECRET is also done at start.
supabase-cli start
supabase-cli stop
supabase-cli remove
After applying the following migrations, realtime functions will no longer work.
The current version has been modified to not include them in system-migrations.
- 20220603231003_add_quoted_regtypes_support.exs
- 20220603232444_add_output_for_data_less_than_equal_64_bytes_when_payload_too_large.exs
- 20220615214548_add_quoted_regtypes_backward_compatibility_support.exs