Hi @zernonia,
Just wanted to say thanks for this project — I used it as the foundation for a native macOS desktop application for viewing Supabase schemas.
I wrapped the Vue frontend in Tauri v2 to produce a lightweight (~3MB) native .app bundle, and extended it with:
- A connection manager for switching between multiple Supabase instances (local and cloud)
- A structural schema view that shows only PKs and foreign keys on the canvas, with a detail panel for full column info
- Table selection that dims/filters unrelated tables to focus on specific relationships
- Visual distinction for views (dashed connectors to their source tables, queried via
information_schema.view_column_usage)
- Left-click canvas panning and filter-aware SQL export
Your approach of using the OpenAPI endpoint (/rest/v1/) to fetch the schema without needing a database password was really clever and made the whole thing possible without any backend changes.
My repo is private for now, but if there's interest I'm happy to share more details or make a public version. Note: I've only tested against local Supabase dev instances so far — cloud instances should work but are untested.
Thanks again for the solid starting point and the MIT license.
Hi @zernonia,
Just wanted to say thanks for this project — I used it as the foundation for a native macOS desktop application for viewing Supabase schemas.
I wrapped the Vue frontend in Tauri v2 to produce a lightweight (~3MB) native
.appbundle, and extended it with:information_schema.view_column_usage)Your approach of using the OpenAPI endpoint (
/rest/v1/) to fetch the schema without needing a database password was really clever and made the whole thing possible without any backend changes.My repo is private for now, but if there's interest I'm happy to share more details or make a public version. Note: I've only tested against local Supabase dev instances so far — cloud instances should work but are untested.
Thanks again for the solid starting point and the MIT license.