Read-only VS Code view for Supabase RPC functions defined in supabase/migrations. Later I'm planning to add features like browsing table definitions, triggers, and more. The extension will be extended as I use it myself, so if you have any feature requests or want to contribute, please let me know!
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
This standalone VS Code extension adds a read-only Supabase RPC browser for SQL files in supabase/migrations.
What It Does
Scans supabase/migrations/*.sql files from the target workspace.
Extracts RPC function names exactly as they are declared in SQL.
Shows each RPC only once, using the newest migration that defines or replaces it.
Compares the current workspace against the current branch base so the list knows which RPCs were changed in this branch.
Sorts branch-changed RPCs to the top of the list, then keeps alphabetical ordering within each change group.
Displays the timestamp of the latest migration that edited the RPC.
Uses yellow rows for updated RPCs and green rows for newly introduced RPCs while leaving unchanged RPCs with the default styling.
Adds its own Activity Bar icon so the RPC browser is visible in the left sidebar.
Opens a side-by-side diff between the latest and previous SQL definitions when a comparison version exists and the RPC is not new in the current branch.
Opens the latest migration file by default for new RPCs and any RPC without a diffable previous definition.
Shows inline row actions for opening the latest migration file, the previous migration defining the RPC, and a generated related-queries view for non-function SQL in the latest migration, with diff only when a comparison definition exists.
Keeps a permanent search field pinned at the top of the sidebar and still lets the toolbar search action focus that field.
Adds a refresh action to reload the list.
Shows a clear empty state when the migrations folder is missing or no RPCs are defined.
Scope
This extension is intentionally read-only. It does not create, edit, apply, or delete migrations.
Run And Debug Locally
Change into this package:
cd /Users/polehla/vscode/suabase-migration-browser
Install the package-local development dependencies:
npm install
Open this folder in VS Code.
Run the Run Browse Supabase Migrations launch configuration or press F5.
In the Extension Development Host, click the Supabase RPCs icon in the Activity Bar to open the RPC browser.
The extension host opens the repository root as the workspace so the view can browse the real supabase/migrations folder.
