DEV Community

Kyle Ledbetter
Kyle Ledbetter

Posted on

Supabase Dashboards That Don't Suck: Production-Ready Analytics Without the Setup Hell

TL;DR: We just shipped the most powerful Supabase dashboards ever built. Live data, intelligent caching, AI-assisted refinement, and a semantic layer that means the AI actually understands your schema. Free to try.

If you're a Supabase developer, you've probably hit this wall.

You ship a product. Users start showing up. And then someone asks: "What does our retention look like?" or "Which features are people actually using?" or "Why did signups drop last Tuesday?"

Your options:

  1. Write SQL queries manually every time someone asks (unsustainable)
  2. Set up Mixpanel or Amplitude (requires tracking code, event schemas, weeks of setup, and now your data lives somewhere else)
  3. Build a custom internal dashboard (months of engineering work you don't have)
  4. Just... not have good analytics (most common option, worst outcome)

None of this is ideal for you. We built something better.

What We Shipped

Dreambase just launched production-ready dashboards built specifically for Supabase. Here's what that actually means:

Dreambase Supabase Dashboards

Live, interactive dashboards with proper filtering that applies across the entire dashboard, not just individual charts.

Drag-and-drop edit mode for rearranging, resizing, and adding components without touching the AI.

Edit Mode for Dashboards

AI assistant for refinement that understands your full data model and helps you adjust queries, add visualizations, and iterate. Use slash commands (/) for quick actions and at commands (@) to reference Topics, dashboard items, or specific tables.

Dreambase AI Analyst Assistant

Intelligent caching that saves query results as datasets directly in your Supabase Storage. Your dashboard loads from cache. Your production database doesn't get hit on every page load. You control the refresh schedule.

Background generation so you can close the tab and come back when the dashboard is ready.

Query and dataset analysis that audits the queries powering your dashboards using our Supabase Health Assessment technology. You'll see query performance signals and optimization recommendations directly in the dashboard.

The Part That Makes It Actually Accurate: Topics

Supabase Data Dictionary

Most AI analytics tools struggle with accuracy because they don't understand your specific data model. They hallucinate table names, misinterpret column relationships, and produce queries that look right but return wrong results.

We solved this with the Data Dictionary and Topics.

Topics are your AI-native semantic layer. You define them once and the AI uses them every time.

A Topic maps your business concepts to your actual Supabase tables and columns:

  • "Subscriptions" maps to your subscriptions table with your specific definitions of MRR, churn, and active subscribers
  • "User Engagement" maps to your events or sessions table with your DAU and feature adoption metrics
  • "Revenue" maps to your transactions table with your custom revenue calculations

When you create a dashboard, you select one or more Topics and write a short prompt. The AI has deep context about your schema and generates accurate queries from the start.

Define once. Reuse across every dashboard and report you ever create.

We help you create your first Topics during onboarding so you're not starting from a blank slate.

How It Works End to End

Dreambase Easy Onboarding

  1. Connect your Supabase project — read-only access, 30 seconds
  2. Define Topics in the Data Dictionary — map your business concepts to your schema
  3. Select Topics and write a prompt — "Show me subscription growth by plan with MRR and churn rate over the last 90 days"
  4. Dashboard generates in the background — close the tab, come back when it's done
  5. Refine with drag-and-drop or AI assistant — iterate until it's exactly right
  6. Set a refresh schedule — hourly, daily, weekly. Your call. Cache saves to Supabase Storage.

Dashboard Components

Dashboards support a flexible set of components, all of which can pull from one or multiple data sources:

  • Metric cards with trend indicators
  • Line, bar, area, and pie charts
  • Flexible lists with sorting
  • Full data tables with pagination, search, and export
  • Internal links to other dashboards

The Caching System (Worth Understanding)

Supabase Data Profiler

This is where Dreambase makes a different architectural choice than most analytics tools.

When your dashboard refreshes, query results are saved as datasets directly in your Supabase Storage. Subsequent loads read from the dataset cache, not from your production database.

This means:

  • Sub-second dashboard load times regardless of query complexity
  • No read load on your production Postgres instance from analytics traffic
  • Full audit trail of dataset snapshots
  • You control refresh frequency

Manual refresh is always available if you need current data right now.

What Else Shipped in This Release

We rebuilt the entire product around dashboards. Beyond the dashboards themselves:

Data Dictionary and Topics replace the old Projects system. Better DX, cleaner mental model.

New navigation rail and completely redesigned UI.

New AI-powered homepage with instant Quick Insights. Ask a metric question the moment you log in, get charts without creating a full dashboard.

Refreshed Supabase Health Assessments with a benchmarking view. Track your database health score over time as you implement recommendations. Security, performance, indexing, and architecture all scored and tracked.

Pinnable dashboards with grid and list views, search, and filters for managing your dashboard library.

Pricing

Free trial — no credit card required. Connect your Supabase project and build your first dashboard.

Developer — a personal developer account to immediately get value, test, and do a PoC for your team.

Pro — Designed for Teams. Collaborative dashboards, scheduled refresh, advanced AI models, more projects.

Team/Enterprise — custom pricing for larger teams.

What's Coming Next

Reports are about to evolve. Right now they're AI-generated summaries with supporting charts. We're transforming them into executive summaries of actionable insights that get delivered to Slack and your inbox on a schedule.

The analytics come to you. No dashboard login required.


Try Dreambase →

Questions? Drop them below or find us at @DreambaseAI


Built by @kyleledbetter and the Dreambase team. We're a small team of operators and designers building AI-native analytics for the Supabase ecosystem.

Top comments (1)

Collapse
 
alwaysunday profile image
🤓 Andy Keil

Been waiting for this update! Can't wait to get the slack notifications setup.