Sample data: public sample database. This report shows a well-known demo database, so you can see what the report finds.

Run it on your own database (free)
Free · Read-only · No SQL needed

Your database, explained. Free.

For managers and owners — no SQL needed. Connect PostgreSQL or MySQL with read-only access and get your database explained in plain words, with exact numbers.

Run it on your own database — free
DVD rental shopAirline

Public sample databases. Their dates are moved forward so questions about recent periods work: the dates in the report are not the dates of the original data (the rental shop’s data is from 2022).

DVD rental shop (sample)

PostgreSQL · Measured Oct 14, 2026

Read-only: STYD never changes your database.

15 tables, 46,273 records, 5 business areas. Here’s what you can ask and build with it.

This database records details about a rental service, including customers, films, rentals, payments, and staff. It tracks which films are available at which stores, who rents them, and how payments are made. It also holds information about actors, film categories, and locations related to stores and customers.

How it works

  2. rents
  3. is paid for
  4. is handled by

Also here:

What stands out

  • Most of your data stopped updating in March 2026, while staff kept going until October 2026.

Questions you can ask

Ask this about your own database — sign up free

Which customers have rented the most films recently?What are the top ten most rented film categories?How much total payment was received last month?Which staff members processed the most rentals this year?Which stores have the highest rental activity currently?

Ideas you could build

  • Customer Rental Activity Dashboardreport

    A dashboard showing rental frequency and payment totals per customer to identify top renters.

  • Film Popularity Reportreport

    A report ranking films and categories by rental counts to guide inventory decisions.

  • Payment Reminder Alertsautomation

    Automatically notify customers who have overdue payments to improve cash flow.

  • Staff Performance Summaryreport

    Regular summaries of rentals and payments handled by each staff member to monitor productivity.

Tables

15

Records in total

46,273

Oldest record

Mar 2026

Latest activity

Oct 2026

What it can tell you

  • Which customers are most active in renting films.
  • Which films are rented the most and their categories.
  • How much revenue is generated from payments over time.
  • Which staff members handle the most rentals and payments.
  • Where stores and customers are located geographically and their activity levels.

Want something built on this data?

Is it safe?

  • Read-only: connect with a read-only database user. STYD only runs read queries and never changes your data.
  • What is stored: table and column names, how many records each table has, its first and last dates, how the tables link, and sample values from your columns (none from columns detected as email addresses, phone numbers or secrets). To understand the data, the analysis reads a limited sample of rows from each table.
  • What the AI sees: the written explanation is made from table and column names and a rough size of each table, not from your rows. To draft column descriptions, the analysis sends the AI a few example values per column, with long numbers partly masked.
  • Every number on the report is counted by the database itself, not written by the AI.
  • PostgreSQL and MySQL.
Privacy policy →
Run it on your own database — free