If you run a SaaS product, DAU, WAU, and MAU are three numbers you need to know at all times. But for most non-technical founders and product teams, getting these numbers means filing a request with an engineer — or paying for an analytics platform on top of a database you already own.
Here's the thing: your database already has this data. You don't need a separate analytics tool. You need a way to ask your database the right questions without writing SQL.
What DAU, WAU, and MAU Actually Measure
Daily active users (DAU), weekly active users (WAU), and monthly active users (MAU) tell you how many unique users performed a meaningful action in your product within a given time window.
The DAU/MAU ratio — sometimes called the stickiness ratio — is a quick gauge of engagement. A ratio above 20% is generally healthy for SaaS. Below 10% and you have a retention problem worth investigating now, not at your next weekly review.
The Usual Way to Track This — And Why It Breaks Down
The standard method is to write SQL against your events or activity table. A COUNT(DISTINCT user_id) filtered by date range and an activity flag. Simple enough — if you know SQL.
Most product teams and founders don't. So they rely on weekly reports from an engineer, pay for Mixpanel or PostHog, or just guess from rough memory. Each option has a cost: engineering time, tool cost, or flying blind on the metric that tells you whether your product is working.
What Counts as an Active User?
This depends on your product — and that's actually the core problem with third-party analytics. Mixpanel and Amplitude define 'active' based on events you send through their SDK. If you haven't instrumented the right events, the number is wrong.
When you query your own database, you define 'active' exactly how your business defines it: a login, a feature interaction, a file upload, a message sent. The definition lives in your query, not in someone else's SDK configuration.
How to Track DAU Without Writing SQL
AI for Database (aifordatabase.com) connects directly to your database and lets you ask questions in plain English. You type 'How many unique users were active each day this week?' and it translates that into SQL, runs it against your database, and returns the results.
No query language required. No data migration. The results come straight from your source of truth.
Step 1: Connect your database. PostgreSQL, Supabase, MySQL, MongoDB, BigQuery, Snowflake — connect once in minutes. The connection is read-only by default.
Step 2: Ask your question. Something like: 'Show me daily active users for the past 30 days. An active user is anyone who logged an event in the user_events table.' The AI figures out the right table and columns from your schema.
Step 3: Pin it to a dashboard. Once you get the result you want, pin that panel to a dashboard. It refreshes automatically — hourly, daily, or on demand. You now have a live DAU chart with zero ongoing maintenance.
Tracking WAU and MAU the Same Way
The same workflow applies for weekly and monthly counts. Ask: 'What's my WAU for the past 12 weeks?' or 'Show monthly active users for each month in 2026.' Each result becomes a pinned dashboard panel.
Your dashboard shows DAU, WAU, and MAU side by side — automatically updated from your live database. No manual exports, no pivot tables, no waiting for the data team.
The DAU/MAU Stickiness Ratio
Once DAU and MAU are both tracked, you can monitor stickiness directly. Ask: 'What's my DAU/MAU ratio for this month?' The AI runs both underlying queries and computes the ratio in one response.
Pin that as a dashboard panel and you'll see the trend line over time — no SQL editor, no spreadsheet.
Set an Alert When Active Users Drop
Active user drops are worth knowing about immediately, not at your next weekly review. AI for Database's workflow feature lets you define a threshold and trigger an automated alert. For example: 'If DAU drops below 50, send a Slack message to #product.'
The workflow monitors your database on a schedule, checks the condition, and fires the notification if it's met. No code, no Zapier pipeline, no cron job to maintain.
Common Questions
How do I track active users without a data analyst? Connect your database to a natural language query tool like AI for Database. Ask questions like 'show me DAU for the last 30 days' without writing any SQL. Set up a dashboard and the numbers update automatically.
What's the best way to track DAU, WAU, and MAU without SQL? If your event data already lives in your database — which it usually does in Supabase, PostgreSQL, or MySQL apps — you don't need to migrate to a separate analytics platform. Query your existing database directly in plain English and skip the SDK instrumentation entirely.
Can I track active users from Supabase, PostgreSQL, or MySQL? Yes — AI for Database supports all three, plus MongoDB, BigQuery, Snowflake, Redshift, and more. As long as your database has a table with user activity records and timestamps, you can query active users in plain English.
What if my definition of 'active user' is non-standard? That's the advantage of querying your own database. You tell the AI exactly what 'active' means for your product — any login, a specific feature event, a transaction — and the query is built against that definition. No SDK configuration, no waiting on third-party support.
Start Tracking Today
If you have a database with user activity data, you're 10 minutes away from a live DAU/WAU/MAU dashboard. Connect your database at aifordatabase.com, ask your first question in plain English, and pin the result. No SQL, no analytics SDK, no engineering ticket required.
Start querying your database for free → Connect in 2 minutes at aifordatabase.com, no SQL required.