Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

I'm running into "Connection terminated unexpectedly" errors when I try to rename a table (`alter table "employees" rename to "people"`). I've tried doing it a few different ways. It's fine if I use the Supabase dashboard (using the UI or writing my own SQL), but if I connect directly via DBeaver the connection gets terminated when trying the run that statement. Is this expected behaviour or is something going wrong here?

Probably has to do with user PostGres (connection owner) not having ownership of those tables if they were created in the UI.

Good theory! I tried creating the table from the client instead of the Supabase UI, but the same problem happens.

I've opened in issue on GitHub: https://github.com/supabase/supabase/issues/3688

I just now created a table from PHPSTORM with the database plugin (basically DataGrip).  Oh wait maybe you created it OK, just could not alter it.... I'll check

Yeah, it's the altering that causes the problem for me. Creating is no problem.

Yep.  Error on rename.   I know I can do columns and such.  Odd.

Sorted (well, a workaround for now): https://github.com/supabase/supabase/issues/3688#issuecomment-953370874