Today we're launching a new GitHub Copilot extension for VS Code to make your development with Supabase and VS Code even more delightful, starting with a Copilot-guided experience for database migrations.
The foundation for this extenions was created by Anas Araid during a previous Launch Week Hackathon. Impressed with their work, we partnered with them to add a "Chat Participant", an exciting new feature recently launched by the GitHub and VS Code teams at Microsoft.
The VS Code extension is quite feature rich:
GitHub Copilot Chat Participant
The extension provides a Chat Participant for GitHub Copilot to help with your Supabase questions. Simply type @supabase in your Copilot Chat and the extension will include your database schema as context to Copilot.
Copilot-guided database migrations
The extension provides a guided experience to create and apply database migrations. Simply type @supabase /migration <describe what you want to do> in your Copilot Chat and the extension will generate a new SQL migration for you.
Inspect tables & views
Inspect your tables and views, including their columns, types, and data, directly from the editor:
List database migrations
See the migration history of your database:
Inspect database functions
Inspect your database functions and their SQL definitions:
List Storage buckets
List the Storage buckets in your Supabase project.
We're excited to continue adding more features that will make your development experience with Supabase even more delightful - and for this we need your help! If you have any feedback, feature requests, or bug reports, please open an issue on GitHub.
The extension requires you to have the Supabase CLI installed and have your project running locally. In a future release, we will integrate the Supabase Managamenet API into the extension to make connecting to your hosted Supabase projects as seamless as possible.
The entire Supabase stack is fully open source, including this extension. In fact, this extension was originally created by Anas Araid during a previous Launch Week Hackathon.
Your contributions, feedback, and engagement in the Supabase community are invaluable, and play a significant role in shaping our future. Thank you for your support!