Currently, the Database Management section of the Supabase dashboard (specifically for Indexes, Functions, and Triggers) presents objects in a single, flat list.As a project grows and more tables are added, this list becomes cluttered and difficult to navigate. Finding all indexes or triggers associated with a specific table requires manual scanning or searching, which is inefficient and prone to oversight. There is currently no way to "group" these objects by their parent table, making it hard to see a consolidated view of all secondary assets for a specific piece of the schema.Describe the solution you'd likeI would like to see a "Group by Table" or "Sort by Table" option added to the list views for:IndexesFunctionsTriggersEnumerated Types (if applicable)Ideal Behavior:Toggle for Grouping: A simple toggle or dropdown at the top of these lists to "Group by Table."Accordion/Collapsible Headers: When grouped, objects should be nested under a header naming the table they belong to.Cross-Schema Support: If multiple schemas are present, grouping should respect the schema.table hierarchy.Describe alternatives you've consideredManual Search: Using the search bar to type the table name. This works but requires the user to remember the exact name and only shows one table’s assets at a time, rather than providing an organized overview of the entire project.SQL Editor: Writing custom SQL queries to list triggers or indexes by table. While functional, it defeats the purpose of having a visual management UI.Additional contextThis improvement would bring the dashboard closer to the experience of professional database IDEs (like pgAdmin or DBeaver), where assets are naturally nested under their respective tables, greatly improving developer productivity for large-scale projects.
Benedict Mwenda requests an improvement to the Supabase dashboard's Database Management section. He suggests adding a 'Group by Table' or 'Sort by Table' option for better organization of indexes, functions, and triggers. This feature would enhance navigation and productivity, especially in large projects, by grouping objects under their respective tables.