Supabase has become the go-to open-source Firebase alternative, offering Postgres, authentication, real-time subscriptions, storage, and edge functions in one platform. The ecosystem of companion tools has grown rapidly to fill gaps and extend capabilities. Here are the tools we use at GEXP Software to build production Supabase applications efficiently.
01Database Management & Admin
Tools for managing, visualizing, and administering Supabase PostgreSQL databases.
Supabase Studio
freemiumSupabase's built-in dashboard with a table editor, SQL editor, and real-time log viewer. The table editor makes database management accessible to non-technical team members who need to view and edit data.
Spreadsheet-like table editor for non-technical team members
Supabase CLI
open-sourceOfficial CLI for local development, database migrations, type generation, and edge function management. Run a full Supabase stack locally with `supabase start` for offline development.
Full local Supabase stack with one command
pgAdmin
open-sourceThe most feature-rich PostgreSQL administration tool with query builder, ERD visualization, and server monitoring. Connect it to your Supabase database for advanced operations beyond Studio.
DBeaver
freemiumUniversal database management tool that connects to Supabase's PostgreSQL with full SQL editing, data export, and ER diagram generation. Ideal for developers managing multiple database types.
Supabase Schema
freeVisual schema designer that generates Supabase-compatible SQL migrations. Design your database visually with tables, relationships, and RLS policies, then export migration files.
Drizzle Studio
open-sourceLightweight database browser from the Drizzle ORM team that connects to your Supabase Postgres. Faster and more focused than pgAdmin for everyday data browsing and editing tasks.
02Type Safety & Code Generation
Tools that generate TypeScript types, client code, and API interfaces from your Supabase database schema.
Supabase Type Generator
open-sourceOfficial CLI command that generates TypeScript types from your database schema. Run `supabase gen types typescript` and get full type safety for every table, view, and function.
Auto-generated types for every table, view, and RPC function
Drizzle ORM
open-sourceTypeScript ORM with first-class Supabase support that provides type-safe queries without code generation. Define your schema in TypeScript and get autocompletion for every query.
Prisma
freemiumSchema-first ORM that connects to Supabase's PostgreSQL with introspection support. Pull your existing Supabase schema into a Prisma schema and get a type-safe client instantly.
Kysely
open-sourceType-safe SQL query builder that pairs beautifully with Supabase-generated types. Write raw SQL with full TypeScript autocompletion when you need queries the Supabase client can't express.
supabase-js
open-sourceOfficial JavaScript/TypeScript client library for Supabase with real-time subscriptions, authentication, storage, and database operations. The primary interface for frontend applications.
03Authentication & Security
Tools and libraries that extend Supabase's built-in authentication with additional providers, UI components, and security features.
Supabase Auth UI
open-sourcePre-built React authentication components that connect to Supabase Auth. Drop in a styled login form with social providers, magic links, and password reset in minutes.
Pre-built login/signup forms with social provider buttons
Supabase Auth Helpers
open-sourceFramework-specific authentication utilities for Next.js, SvelteKit, and Remix. Handles cookie-based sessions, server-side auth, and middleware protection patterns.
supabase-swr
open-sourceSWR hooks for Supabase that combine real-time subscriptions with stale-while-revalidate caching. Automatically refetches data when Supabase broadcasts changes.
Row Level Security Policies Generator
open-sourceSupabase's built-in RLS policy editor with templates for common patterns — owner-only access, team access, public read, and admin override. Essential for securing your data layer.
Built-in policy templates for common authorization patterns
04Edge Functions & Backend
Tools for building, testing, and deploying serverless functions and backend logic on the Supabase platform.
Supabase Edge Functions
freemiumDeno-based serverless functions that run on Supabase's global edge network. Write TypeScript functions that execute close to your users with direct access to your Supabase database.
Deno-based TypeScript functions on a global edge network
Supabase Realtime
freemiumReal-time engine that broadcasts database changes, presence information, and custom events over WebSockets. Build collaborative features like live cursors, chat, and multiplayer without external services.
Database change broadcasts + presence + custom events
Supabase Storage
freemiumS3-compatible object storage with built-in image transformations. Upload, serve, and transform images with automatic CDN distribution and fine-grained RLS-based access control.
Supabase Cron (pg_cron)
open-sourceSchedule recurring tasks directly in your database using pg_cron extension. Run cleanup jobs, aggregate data, or trigger edge functions on a schedule without external cron services.
05Testing & Development
Tools for testing Supabase integrations, seeding databases, and streamlining the development workflow.
Supabase Local Development
open-sourceRun a complete Supabase stack locally with Docker — database, auth, storage, edge functions, and Studio dashboard. Develop and test everything offline before deploying.
Full Supabase stack running locally on Docker
Snaplet
freemiumDatabase snapshot and seeding tool that creates realistic test data from your Supabase schema. Generates type-safe seed scripts with referential integrity preserved.
Generate realistic test data that respects foreign keys
Supabase Branching
paidCreate isolated database branches for feature development, like git branches for your database. Each branch gets its own Supabase instance with migrations tracked independently.
Git-like branching for your database — one branch per PR
pgTAP
open-sourceTAP-compliant testing framework that runs unit tests directly inside PostgreSQL. Write tests for your RLS policies, functions, and triggers that execute within the database itself.
Test RLS policies and database functions inside PostgreSQL
Supabase Bootstrap
freeStarter templates and quickstart guides for common Supabase + framework combinations. Scaffold a full-stack app with auth, database, and storage pre-configured in minutes.