Introduction to Supamode - The Admin Panel for Supabase

Supamode is a self-hosted admin dashboard for Supabase that provides CMS-style database management with granular role-based access control. It enables non-technical team members to safely view, filter, and edit PostgreSQL data without writing SQL.

Supamode gives your team controlled access to your database while developers retain full control over permissions and customization.

Get started in 10 minutes: Clone the repo, run pnpm dev, and connect to your Supabase project. No complex configuration required.

Why Supamode?

Unlike Supabase Studio's Data Explorer, Supamode is purpose-built for team collaboration with granular role-based access control. Your support team can search and update customer records. Your content team can manage blog posts. Your ops team can monitor audit logs. Each role sees only what they're permitted to access.

Key benefits:

• No SQL required: Non-technical users can safely browse, search, and edit data through an intuitive UI
• Granular RBAC: Table-level and column-level permissions for precise access control
• Self-hosted: Your data stays on your infrastructure with full source code access
• 10-minute setup: Clone, configure environment variables, deploy
• Extensible: Built with React 19, Hono, and TypeScript for developer-first customization

Core Features

Data Explorer

The Data Explorer provides a powerful interface for navigating your database:

• Full-text search across all columns with smart filtering (text, date, boolean, numeric, enum, reference)
• Saved views with shareable filters for common queries ("Active users", "Unpaid invoices")
• Inline editing with smart forms that adapt to column data types
• Batch operations for bulk updates and deletions
• Tabbed interface for working with multiple tables simultaneously
• Global search (Cmd+K) to find any record across your entire database

Role-Based Access Control (RBAC)

Supamode's permission system gives you precise control over who can access what:

• System permissions: Control access to admin features (roles, permissions, audit logs)
• Data permissions: Table-level and column-level read/write access
• Storage permissions: Bucket and path-level file access
• Permission groups: Bundle related permissions for easier role management
• Role hierarchy: Higher-ranked roles can manage lower-ranked accounts

Users Explorer

Manage Supabase Auth users directly from the dashboard:

• Search users by email
• Create, update, and delete user accounts
• Ban/unban users
• View authentication metadata

Storage Explorer

Browse and manage Supabase Storage buckets:

• Navigate folders and files
• Upload, download, and delete files
• View file metadata and generate presigned URLs
• Control access with storage permissions

Custom Dashboards

Build analytics dashboards with drag-and-drop widgets:

• Chart widgets: Bar, line, and area charts for trends and comparisons
• Metric widgets: KPIs with trend indicators
• Table widgets: Data grids with full filtering capabilities
• Role-based sharing: Share dashboards with specific roles

Audit Logs

Track all data changes for compliance and debugging:

• Filter by user, action, and date range
• View detailed change history with before/after values
• Severity levels for prioritizing alerts

Architecture

Supamode is built as a Turborepo monorepo with two main applications:

The frontend proxies /api/* requests to the Hono backend, enabling seamless deployment as a single unit or as separate services.

Deployment Options

Supamode can be deployed anywhere that supports Node.js:

• Docker: Multi-stage builds for API and frontend containers
• Vercel: Zero-config deployment with automatic builds
• Railway: One-click deployment template
• Self-hosted: Any platform supporting Node.js (AWS, GCP, DigitalOcean, Fly.io)

When to Use Supamode

Supamode is ideal when:

• Your support team needs to search and update customer data without database access
• Your content team needs a CMS interface for managing blog posts or products
• You need audit trails for compliance (SOC 2, HIPAA, GDPR)
• You want to give stakeholders read-only access to specific data
• You're building internal tools and need a head start on admin interfaces

Not the right fit if: You need a customer-facing dashboard (Supamode is for internal/admin use) or you require real-time collaborative editing.

Next Steps

1. Clone the repository and set up dependencies
2. Run the project locally with the demo data
3. Configure your tables for the Data Explorer
4. Set up RBAC for your team
5. Deploy to production when ready