Official Supabase extension for VS Code and GitHub Copilot

12 Aug 2024

3 minute read

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 extension 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.

Features

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.

What's Next?

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.

Contributing to Supabase

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!

Resources

Share this article

Build in a weekend, scale to billions