Supabase for Hackathons

Build something amazing before lunch.

In just a few hours, you can turn your idea into a working app. Supabase gives you everything you need: a database, authentication, storage, serverless functions, real-time updates, and more.

We used Supabase at the hackathon because it let us go from idea to MVP in under two days. Then it took only a couple of months to turn that janky MVP into a production-ready application.
Elijah MuraokaCEO and Co-Founder, Soshi

Win with Supabase

Supabase is the Postgres developer platform and Firebase alternative that developers everywhere love and trust. Build an instant backend for your application using everything you need to ship a winning app in seconds. Integrate with your favorite AI Builder tools and write code even faster.

  • Build in a weekend

    Supabase spins up everything you need instantly so you can get to the fun part: building a winning app. Enjoy a fully managed Postgres database with REST and GraphQL APIs out of the box. Connect using your favorite frontend or server-side framework.

  • Everything you need to ship a winning app

    Support login from any social or OAuth provider. Build server-side logic using Edge Functions. Build immersive, collaborative experiences using Realtime. Use Amazon S3-compatible Storage to maintain files, images, and videos.

  • Speed and AI-powered innovation

    Supabase is just Postgres, so it's easy to scale your Hackathon project into a real product. Connect to your favorite AI tools and use built-in Vectors to store embeddings in Postgres. Use Foreign Data Wrappers to connect to Google Sheets, MySQL, BigQuery, and more.

Supabase helps you build

Supabase includes everything you need to create the winning app.

Database

A fully managed Postgres database.
No forks: 100% pure Postgres.

NAMEPUBLICATION
Jon MeyersAll
Chris MartinAll
Amy QuekNo
Riccardo BussettiNo
Beng EuAll
Tyler HilleryAll

Authentication

Secure authentication with email/password, magic links, OAuth (Google, GitHub, Twitter, etc.), SAML, SSO, and phone/SMS OTP.

Role-Based Access Control

Secure your data properly.

Realtime

Postgres replication enables live sync functionality for collaborative applications.

Storage

Scalable S3-compatible object storage for managing files, images, and videos.

Edge Functions

Serverless functions powered by Deno, deployed globally for low-latency execution.

Vectors

pgvector extensionfor AI/ML applications, enabling fast semantic search and embedding storage.

Row Level Security

Granular access control policies to secure data at the row level.

Build faster with Supabase

Features that help developers move quickly and focus.

AI Assistant

A single panel that persists across the Supabase Dashboard and maintains context across AI prompts.

AI Assistant

Entity: Auth

Schema:

Issue: We have detected that you have enabled the email provider with an expiry time of more than an hour. It is recommended to set this value to less th...

MCP Server

Connect your favorite AI tools such as Cursor or Claude directly with Supabase.

Auto-generated APIs

Learn SQL when you're ready. In the meantime, Supabase generates automatic APIs to make coding a lot easier.

Foreign Data Wrappers

Connect Supabase to Redshift, BigQuery, MySQL, and external APIs for seamless integrations.

Instant and secure deployment

No need to set up servers, manage DevOps, or tweak security settings.

Observability

Built-in logs, query performance tools, and security insights for easy debugging.

Choose your platform to start building in seconds

Or, start with Supabase AI Prompts

Bootstrap Next.js app with Supabase Auth

1. Install @supabase/supabase-js and @supabase/ssr packages.
2. Set up environment variables.
3. Write two utility functions with `createClient` functions to create a browser client and a server client. 
4. Hook up middleware to refresh auth tokens

Writing Supabase Edge Functions

1. Try to use Web APIs and Deno’s core APIs instead of external dependencies (eg: use fetch instead of Axios, use WebSockets API instead of node-ws)
2. If you are reusing utility methods between Edge Functions, add them to 'supabase/functions/_shared' and import using a relative path. Do NOT have cross dependencies between Edge Functions.
3. Do NOT use bare specifiers when importing dependecnies. If you need to use an external dependency, make sure it's prefixed with either 'npm:' or 'jsr:'. For example, '@supabase/supabase-js' should be written as 'npm:@supabase/supabase-js'.
4. For external imports, always define a version. For example, 'npm:@express' should be written as 'npm:express@4.18.2'.
5. For external dependencies, importing via 'npm:' and 'jsr:' is preferred. Minimize the use of imports from @'deno.land/x' , 'esm.sh' and @'unpkg.com' . If you have a package from one of those CDNs, you can replace the CDN hostname with 'npm:' specifier.

Declarative Database Schema

Mandatory Instructions for Supabase Declarative Schema Management
## 1. **Exclusive Use of Declarative Schema**
-**All database schema modifications must be defined within '.sql' files located in the 'supabase/schemas/' directory.

Create RLS policies

You're a Supabase Postgres expert in writing row level security policies. Your purpose is to generate a policy with the constraints given by the user. You should first retrieve schema information to write policies for, usually the 'public' schema.
The output should use the following instructions:

- The generated SQL must be valid SQL.

Supabase MCP server works seamlessly with your favorite AI code editor

Connect your AI tools