Supabase Studio unable to connect to database

[JamesPartington]

Bug Report

Environment

Operating System: macOS Monterey 12.4
Processor: Apple M1 Pro

Installed Version

Command Used to Install: brew install supabase/tap/supabase
Supabase Version: 1.47.0
Supabase Configuration: Default

Issue Description

I am unable to use certain features of the Supabase local studio at http://localhost:54323/project/default. Specifically, I cannot view any tables, nor can I run any SQL on the editors. When I attempt to run a simple SQL query such as SELECT version();, I receive the error message: "An error has occurred: Invalid URL".

Cause of Issue

This issue began after upgrading Supabase, although I do not remember the specific version number of the previous installation. The issue persists even after attempting to resolve it through various troubleshooting steps.

Functioning Features

I am able to successfully run the following Supabase commands:

supabase init
supabase start
supabase db reset
Additionally, I am able to connect to the database using the command psql 'postgres://postgres:postgres@localhost:54322/postgres' < database-dump-all.sql.

Troubleshooting Steps
I have attempted the following steps to resolve the issue, but the problem persists:

Uninstalled and reinstalled Supabase using Homebrew.
Restarted the computer.
Deleted all Docker images, containers, and volumes.
Ran supabase start after removing everything in Docker.
Tried using Chrome and Safari

[JamesPartington]

Hi, I have managed find a solution.

It turns out that creating a new local supabase instance does work. It was when I was trying to run my old project with supabase start that the studio did not work. I would assume that the config.toml file I was using was not compatible with the new Supabase CLI. I have just migrated the files from the old directory to the new directory.

If you are curious, the old config.toml file is here:

# A string used to distinguish different Supabase projects on the same host. Defaults to the working
# directory name when running `supabase init`.
project_id = "hvmc_supabase_2.1"

[api]
# Port to use for the API URL.
port = 54321
# Schemas to expose in your API. Tables, views and stored procedures in this schema will get API
# endpoints. public and storage are always included.
schemas = []
# Extra schemas to add to the search_path of every request.
extra_search_path = ["extensions"]
# The maximum number of rows returns from a view, table, or stored procedure. Limits payload size
# for accidental or malicious requests.
max_rows = 1000

[db]
# Port to use for the local database URL.
port = 54322
# The database major version to use. This has to be the same as your remote database's. Run `SHOW
# server_version;` on the remote database to check.
major_version = 14

[studio]
# Port to use for Supabase Studio.
port = 54323

# Email testing server. Emails sent with the local dev setup are not actually sent - rather, they
# are monitored, and you can view the emails that would have been sent from the web interface.
[inbucket]
# Port to use for the email testing server web interface.
port = 54324
smtp_port = 54325
pop3_port = 54326

[auth]
# The base URL of your website. Used as an allow-list for redirects and for constructing URLs used
# in emails.
site_url = "http://localhost:3000"
# A list of *exact* URLs that auth providers are permitted to redirect to post authentication.
additional_redirect_urls = ["https://localhost:3000"]
# How long tokens are valid for, in seconds. Defaults to 3600 (1 hour), maximum 604,800 seconds (one
# week).
jwt_expiry = 3600
# Allow/disallow new user signups to your project.
enable_signup = true

[auth.email]
# Allow/disallow new user signups via email to your project.
enable_signup = true
# If enabled, a user will be required to confirm any email change on both the old, and new email
# addresses. If disabled, only the new email is required to confirm.
double_confirm_changes = true
# If enabled, users need to confirm their email address before signing in.
enable_confirmations = false

# Use an external OAuth provider. The full list of providers are: `apple`, `azure`, `bitbucket`,
# `discord`, `facebook`, `github`, `gitlab`, `google`, `twitch`, `twitter`, `slack`, `spotify`.
[auth.external.apple]
enabled = false
client_id = ""
secret = ""