Supabase Studio

Summary

Supabase has released Supabase Studio, making the web dashboard used on its hosted platform available for local development and self-hosted environments. The dashboard originally existed within a single internal monorepo alongside cloud infrastructure, but managing split repositories and code synchronization significantly slowed down production release cycles. To streamline development, the team unified the frontend into a single open-source codebase modeled after Sentry's shared architecture strategy. Built with Next.js, Tailwind CSS, Supabase UI, and MobX, the application works directly with existing deployments across Docker and the Supabase CLI. The open-source release focuses strictly on database management features, including SQL editors, role policies, and extensions, while excluding cloud project administration.

Context

Supabase originally maintained a single monorepo housing its dashboard, cloud infrastructure, and experimental code to ensure a single source of truth. As user adoption surged and new features were built, maintaining separate codebases or attempting to sync them with submodules caused significant friction and slowed time-to-production.

Approach / What changed

The team open-sourced all frontend code into a single shared codebase for both the hosted platform and self-hosted environments, drawing inspiration from Sentry's codebase strategy. Built with Next.js, Tailwind CSS, Supabase UI, and MobX, Supabase Studio exposes database management capabilities—including table and SQL editors, policies, roles, extensions, replication, and generated API documentation—to local Docker and CLI environments.

Takeaways

• Attempting to synchronize separate codebases across open-source and hosted environments severely slowed down release velocity.
• Supabase unified its frontend into a single open-source codebase, allowing community bug fixes to be deployed to both the hosted platform and self-hosted setups in hours.
• Supabase Studio confines its self-hosted feature set to database management, keeping cloud project deployment and administration out of scope.

Related reading

• Supabase · Dec 2, 2021

  Supabase acquires Logflare

  Supabase announced the acquisition of Logflare, a realtime log ingestion and analytics platform. Modern database architectures encompass APIs, authentication, storage, and CDNs, requiring unified observability to diagnose slow queries and trace user requests effectively. Built with Elixir—the same language powering Supabase's Realtime Engine—Logflare automates schema adaptation for streaming inserts and enables developers to construct APIs from SQL queries via Logflare Endpoints. The integration roadmap includes embedding log querying with SQL directly into the Supabase Dashboard, maintaining existing integrations for Vercel and Cloudflare, and transitioning Logflare toward a fully open-source implementation with multiple backend storage engines. Over the coming months, existing Logflare users will be migrated to the Supabase platform under matching pricing tiers.

  Paul Copplestone

• Supabase · Jul 26, 2021

  Supabase is now on Postgres 13.3