2 months ago
Hey, I need to improve the observability of my database, which is a pgvector template that hasn't the default Postgres view that allow me to see the tables data without the need to access through pgadmin.
So I've included supabase template that has a bunch of stuff that I dont need and it's costing extra resource and causing bugs (because the order of the deployment causes undesired crashes accross services).
I wish to have an option to see through any gui, can be supabase if Im able to simplify these useless services that comes with it to be able to check my database tables easier.
here's my project ID:
f3ed5136-e24b-45a4-8543-4818f7039d59
3 Replies
2 months ago
Hey there! We've found the following might help you get unblocked faster:
If you find the answer from one of these, please let us know by solving the thread!
2 months ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open brody • about 2 months ago
2 months ago
I'm a little confused on your question here.
Are you looking to remove unneeded services? View your databases externally?
2 months ago
Hi! Thanks for the response. Let me clarify:
WHAT I WANT:
A simple GUI to view my pgvector database tables (like the GUI that comes with the standard Postgres template).
CURRENT PROBLEM:
- I'm using the pgvector template, which doesn't include a built-in GUI
- I added the Supabase template to get a GUI, but it includes many services I don't need (Auth, Storage, Realtime, REST API, etc.)
- These extra Supabase services are causing deployment crashes and increasing costs
MY QUESTIONS:
1. Can I keep only Supabase Studio+Kong (the GUI and external access part) and remove the other Supabase services?
- If yes, which services are safe to delete?
- Which ones does Studio depend on to function?
2. OR, is there a simpler/lighter alternative to view my database?
- Something like pgweb or Adminer that I could deploy as a single Railway service?
- Just need basic table viewing - no auth system or file storage needed
TO ANSWER YOUR QUESTIONS DIRECTLY:
- Yes, I want to remove unneeded Supabase services (if possible)
- Yes, I want to view my database, but preferably through Railway (not external tools like pgAdmin on my local machine), but currently Im following it by deploying supabase into a "supabase." subdomain, (and that's not a bad solution for me as well, but might increase egress costs I think)
GOAL:
Minimal setup - just my pgvector database + a lightweight web GUI to inspect tables.