Use Supabase with Flutter
Learn how to create a Supabase project, add some sample data to your database, and query the data from a Flutter app.
1. Create a Supabase project#
Before you can use Supabase, you need a Supabase project. You can create a project visually in the Dashboard or programmatically using the Management API.
Create a new Supabase project from the Dashboard of any organization you belong to.
You can also use database.new to create a new Supabase project.
2. Install agent skills (optional)#
Agent Skills are curated instruction sets that give your AI agent procedural knowledge about working with Supabase.
Install them in your project with:
1npx skills add supabase/agent-skills3. Set up your database#
When your Supabase project is up and running, create an instruments table with some sample data. Then set only the privileges each Postgres role needs, add Row Level Security (RLS) for enhanced security for database data by default, and create an RLS policy to make the data in the table publicly readable.
Save some steps by clicking here to prefill the SQL in the SQL Editor, and then clicking Run.
Or do this manually in your project's SQL Editor, by pasting the SQL below, and clicking Run.
1-- Create the table2create table instruments (3 id bigint primary key generated always as identity,4 name text not null5);67-- Insert sample data into the table8insert into instruments (name)9values10 ('violin'),11 ('viola'),12 ('cello');1314-- Grant the privileges the role needs, which is read access15grant select on public.instruments to anon;1617-- Enable row level security for the table18alter table instruments enable row level security;1920-- Create a policy to allow the anon role to read from the instruments table21create policy "public can read instruments"22on public.instruments23for select to anon24using (true);If you disabled the Data API during project setup, enable it in the Integrations > Data API section of the Dashboard and expose the specific tables or functions you want to access. To automatically grant access for new tables and functions in public, enable Automatically expose new tables.
4. Create a Flutter app#
Create a Flutter app using the flutter create command.
1flutter create my_app5. Install the Supabase client library#
The fastest way to get started is to use the supabase_flutter client library which provides a convenient interface for working with Supabase from a Flutter app.
Open the pubspec.yaml file inside your Flutter app and add supabase_flutter as a dependency.
pubspec.yaml
1supabase_flutter: ^2.0.0Get API details#
To interact with data in database tables, you use the client libraries that wrap the auto-generated Data API endpoints, authenticating using the Project URL and key from the project Connect dialog.
Project URL
Publishable key
Read the API keys docs for a full explanation of all key types, their uses, and where to find them.
6. Initialize the Supabase client#
Open lib/main.dart and edit the main function to initialize Supabase using your project URL and publishable key, which you can get from the helper above, or from the project Connect panel:
Open Connect panel
lib/main.dart
1import 'package:supabase_flutter/supabase_flutter.dart';23Future<void> main() async {4 WidgetsFlutterBinding.ensureInitialized();56 await Supabase.initialize(7 url: 'YOUR_SUPABASE_URL',8 publishableKey: 'YOUR_SUPABASE_PUBLISHABLE_KEY',9 );10 runApp(MyApp());11}7. Query data from the app#
Use a FutureBuilder to fetch the data when the home page loads and display the query result in a ListView.
Replace the default MyApp and MyHomePage classes with the following code.
lib/main.dart
1class MyApp extends StatelessWidget {2 const MyApp({super.key});34 @override5 Widget build(BuildContext context) {6 return const MaterialApp(7 title: 'Instruments',8 home: HomePage(),9 );10 }11}1213class HomePage extends StatefulWidget {14 const HomePage({super.key});1516 @override17 State<HomePage> createState() => _HomePageState();18}1920class _HomePageState extends State<HomePage> {21 final _future = Supabase.instance.client22 .from('instruments')23 .select();2425 @override26 Widget build(BuildContext context) {27 return Scaffold(28 body: FutureBuilder(29 future: _future,30 builder: (context, snapshot) {31 if (!snapshot.hasData) {32 return const Center(child: CircularProgressIndicator());33 }34 final instruments = snapshot.data!;35 return ListView.builder(36 itemCount: instruments.length,37 itemBuilder: ((context, index) {38 final instrument = instruments[index];39 return ListTile(40 title: Text(instrument['name']),41 );42 }),43 );44 },45 ),46 );47 }48}8. Start the app#
Run your app on a platform of your choosing! By default an app should launch in your web browser.
Note that supabase_flutter is compatible with web, iOS, Android, macOS, and Windows apps.
Running the app on macOS requires additional configuration to set the entitlements.
1flutter run9. Setup deep links (optional)#
Many sign in methods require deep links to redirect the user back to your app after authentication. Read more about setting deep links up for all platforms (including web) in the Flutter Mobile Guide.
Going to production#
Android#
In production, your Android app needs explicit permission to use the internet connection on the user's device which is required to communicate with Supabase APIs.
To do this, add the following line to the android/app/src/main/AndroidManifest.xml file.
1<manifest xmlns:android="http://schemas.android.com/apk/res/android">2 <!-- Required to fetch data from the internet. -->3 <uses-permission android:name="android.permission.INTERNET" />4 <!-- ... -->5</manifest>