Forem: Kyle Ledbetter

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

Kyle Ledbetter — Wed, 25 Feb 2026 16:11:44 +0000

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:

Write SQL queries manually every time someone asks (unsustainable)
Set up Mixpanel or Amplitude (requires tracking code, event schemas, weeks of setup, and now your data lives somewhere else)
Build a custom internal dashboard (months of engineering work you don't have)
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:

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.

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.

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

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

Connect your Supabase project — read-only access, 30 seconds
Define Topics in the Data Dictionary — map your business concepts to your schema
Select Topics and write a prompt — "Show me subscription growth by plan with MRR and churn rate over the last 90 days"
Dashboard generates in the background — close the tab, come back when it's done
Refine with drag-and-drop or AI assistant — iterate until it's exactly right
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)

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.

Allow your team to share product analytics reports from Supabase without giving them database access

Kyle Ledbetter — Fri, 21 Nov 2025 00:09:47 +0000

Public Report Sharing for Supabase: Stop Being Your Team's Analytics Middleman

TL;DR: We just shipped one-click public sharing for Supabase analytics reports. Your stakeholders can now self-serve their metrics instead of asking you to run queries.

The Problem Every Developer Knows

It's 3 PM on a Thursday. You're deep in a complex feature implementation. Then Slack lights up:

PM: "Hey, can you pull the user retention numbers for last month?"

Founder: "What's our MRR growth looking like?"

Investor: "Can you send me the latest engagement metrics?"

You have two choices:

Context-switch, write SQL queries, format the results, send them over (there goes your afternoon)
Give them database access (security nightmare)

Both options are terrible. And you'll be doing it again next week.

What We Built

Dreambase connects directly to your Supabase database and generates analytics reports using AI. We just added public report sharing—one click to make any report publicly accessible.

The workflow:

Your PM/founder generates a report in Dreambase (no SQL required)
They click the share button in the report toolbar
Toggle "Report Visibility" from Private to Public
Copy the URL and share it

You're not involved. They get their metrics. You keep coding.

How It Actually Works

For Internal Teams

By default, reports are private. Workspace Owners, Admins, and Project Managers already have access based on their roles. They just copy the internal link and share it in Slack.

No configuration. No tickets. No interrupting developers.

For External Stakeholders

When they need to share outside the workspace (investors, advisors, customers), they:

Click share button
Toggle to Public
Copy the new public URL
Save changes

The report is now accessible to anyone with the link. No login required. A globe icon appears next to public reports so everyone knows what's shared.

Interactive Data, Not Static Images

This is the key part: reports query your Supabase database directly. When the data updates, the report updates. Share the link once, stakeholders interact with the data.

No more "can you regenerate that report with updated numbers?" They can generate a new report in seconds themselves.

Why This Matters for Supabase

When your analytics connect directly to your Supabase database (your actual source of truth) there's no reason to treat insights like they're locked in a vault.

Traditional analytics tools were built around the assumption that data lives in a separate system, accessed by a separate team, exported to separate files. That made sense when analytics required complex ETL pipelines and dedicated data warehouses.

But Dreambase connects directly to Supabase. Your product data is already there. Your analytics should flow as easily as your data flows.

If you can share a Google Doc or a Figma file with a link, you should be able to share a product analytics report the same way.

That's what we built.

Why This Matters for Dev Teams

You stop being the analytics middleman.

Your stakeholders can:

Generate their own reports (AI writes the SQL)
Share reports with each other
Bookmark public links for recurring metrics
See live data without asking for updates

You maintain security.

Public reports are read-only views. No database credentials exposed. No write access. Toggle back to private anytime.

Internal reports respect workspace permissions. You control who has access at the workspace and project level.

Your Supabase data stays in Supabase.

No JavaScript tracking libraries to install. No data piping to external platforms. No event schemas to maintain. Dreambase connects directly via PostgREST.

Your source of truth remains your source of truth.

Real Use Cases

Investor Updates

Your founder generates a monthly metrics report and shares the public link. Investors bookmark it. They check progress whenever they want. Nobody asks you to pull numbers.

Team Dashboards

Your PM creates reports for feature adoption, user engagement, conversion funnels. They share them with the team. Everyone sees the same data. No more "what's the latest on X?" in Slack.

Customer Transparency

Building in public? Share usage stats or uptime metrics. Your customers see the same data you see. No custom status page to build and maintain.

Cross-Functional Collaboration

Share reports with contractors, advisors, or part-time team members who don't need full workspace access. They get insights without database credentials.

Technical Details

Performance

Reports are cached at the edge
Sub-second load times globally
Optimized for mobile viewing

Open Graph Previews

Dynamically generated preview images for each report
Shows key metrics when shared in Slack/Discord/Twitter
No more "click this random URL and trust me"

Security Model

Public reports are read-only
No database credentials in URLs
Toggle visibility anytime
Workspace-level permission controls

Integration

Direct PostgREST connection to Supabase
Respects your RLS policies
Works with your existing Supabase setup
No schema changes required

See It Live

Here's a public report we're using ourselves:
Pickleball Court Analytics

Notice:

Loads instantly
Shows live data
Clean public page
Preview when you share the link

Getting Started

Public report sharing is available now for all Dreambase users, including the free tier.

Sign up at dreambase.ai
Connect your Supabase project (30 seconds, read-only access)
Generate a report (AI writes the queries)
Click share → toggle public → copy link

Your stakeholders can now self-serve their analytics. You can get back to building features.

Why We Built This

We're developers too. We've been the analytics middleman. We've context-switched out of deep work to run SQL queries for stakeholders who just want to see if a number went up or down.

It's a waste of developer time. And it's a waste of stakeholder time waiting for you.

When your analytics connect directly to Supabase—your actual source of truth—there's no reason insights should require developer intervention.

If your PM can share a Google Doc, they should be able to share an analytics report.

That's what we built.

Questions? Drop them below or reach out @DreambaseAI

Try it: dreambase.ai

Create Product Analytics Reports Directly from Supabase in Seconds

Kyle Ledbetter — Thu, 16 Oct 2025 22:18:21 +0000

When you search for "Supabase analytics" or "Supabase dashboards," you'll find three types of results: Supabase's own documentation about logs and monitoring, Reddit threads asking how to do analytics on Supabase, or ads for products that loosely connect click tracking to your database.

None of these truly solve the analytics problem. And the issue isn't Supabase, it's how we've been thinking about analytics entirely.

The Traditional Analytics Approach Is Fundamentally Broken

For years, we've accepted a painful reality: if you want product analytics, you need to install third-party JavaScript libraries, pipe your data to external platforms like Posthog, Mixpanel or Amplitude, pay escalating costs as you scale, and then... hope the data actually matches what's in your database.

It's backwards. Your source of truth is your Supabase database. Why are we treating it like a second-class citizen? Your real product data lives in your database, but your analytics live somewhere else entirely.

Supabase Analytics & Reports: Good Infrastructure, Missing the Last Mile

Supabase recently launched Analytics Buckets with Apache Iceberg support: a solid move toward separating analytical workloads from transactional ones. They've built a robust "Reports" feature with telemetry for monitoring database performance, logs, auth metrics, and storage stats. For self-hosters, there's even a Prometheus endpoint for Grafana dashboards.

This is excellent infrastructure for database management if you know SQL.

But here's what's missing for real product analytics:
You still need to:

Write complex SQL queries to extract insights
Build your own dashboards from scratch
Understand data modeling and partitioning strategies
Wait for engineers to pull reports when stakeholders need answers
Manually connect the dots between user behavior and product decisions

And if you're a startup founder, product manager, or anyone without a dedicated data team? You're stuck begging engineers for basic metrics or settling for incomplete pictures of your users.

Enter Dreambase: Database-First Analytics & Dashboards for Supabase

Here's a pic of the Dreambase Report generate in action:

We built Dreambase because we were tired of the same old trade-offs. We asked a simple question: What if your Supabase database could just show you what's happening?

More on Dreambase here: https://dreambase.ai/blog/supabase-analytics