All Episodes

June 9, 2025 24 mins

In this episode of The Scrappy Piano Teacher, Jaclyn Mrozek interviews pianist and educator William Perry, creator of the Piano Music Database.

What began as a spreadsheet to help one adult student quickly turned into a tool that’s helping teachers across the country save hours of lesson planning.

William shares how the database was built, how teachers are using it to find repertoire by concept, level, mood, and theme, and why it’s quickly becoming a favorite resource in both private studios and pedagogy classrooms.

The conversation also explores how the tool supports living composers, provides preview recordings, and allows teachers to build custom lists for their students.

The best part...it’s currently free to try during the beta period.

Visit pianomusicdatabase.com to create a free account, and join the Piano Music Database Users group on Facebook to stay connected.


Subscribe at www.scrappypianoteacher.com or send an email to jaclyn@scrappypianoteacher.com to connect with Jaclyn

Mark as Played
Transcript

Episode Transcript

Available transcripts are automatically generated. Complete accuracy is not guaranteed.
(00:02):
Hey everybody, and welcome back to the Scrappy Piano Teacher
Podcast, the show for independent piano teachers who
are building studios with heart,grit, and a heck of a lot of
coffee. I'm your host, Jacqueline, and
today's episode is when you're going to want to bookmark.
I am chatting with William Perry, the creator of Piano
Music Database, a powerful tool built by a teacher for teachers.

(00:23):
And if you've ever found yourself frantically flipping
through books, scrolling screenshots, or begging Facebook
groups for music ideas midway through a lesson, Yup, I do that
here all the time. Well, I have to tell you.
William's story and this resource are about to change how
you plan, search, and organize music for your students.

(00:44):
You're going to love this. I'm going to jump right in.
Thanks for being here. Hi teachers, thank you so much
for joining me today. I have a special guest who I've
been wanting to have on my podcast for a long time, Liam
Perry, and you are joining us from Piano Music Database.
But before we get into that, I want to talk a little bit more

(01:06):
about you as a teacher because Iknow you because you're here in
Cincinnati with me. But if you wouldn't mind just
sharing a little bit about who you are, your background as a
pianist of? Course, Yeah, Yeah, I'm in
Cincinnati now. I love Cincinnati.
It's a great town, a lot of great music.
It's a great place to be. MTNA is headquartered here, so
it's a, It's a lot going on. Yeah.
I been playing piano my whole life.

(01:30):
I did not come from a musical family.
My parents are not musical. Nobody in my family does music.
So I sort of stumbled upon musicon my own first or second grade.
A student brought in a keyboard to show and tell and was like,
playing it for everyone. And they were all like, Oh my
God, this is so cool. So I saw that and I was like, I
I need to play piano. This seems really exciting.

(01:53):
I started taking piano lessons. My parents always told me that I
was a very good practicer and never had to be asked to
practice. I really enjoyed enjoyed piano
as a child. I guess like a ideal student or
something. I started getting very serious
into piano in high school and applied to college and and went
to undergrad for piano performance and in school

(02:15):
started teaching piano at the school that I first learned
piano. And so it was a very great
experience being able to do thatin in undergrad.
From there, decided that I wouldstudy pedagogy and so for my
graduate program is in was in piano performance and pedagogy
at Florida State University. Since then I've been teaching in

(02:36):
Florida. I'm from Florida and then moved
to Ohio in 2020 right during thepandemic and I've been teaching
at academies in in Cincinnati and then now I have my own
studio in Pleasant Ridge. I did.
Not know you were from Florida? I know that you're good friends
with my good friend Jill, which is How I Met you.

(02:57):
My wife and I met who is also a pianist.
Her name is Ariadne and we met teaching piano at Piano Academy
in Tampa, FL and we were both there for I was there for two
years, she was there for one year.
She left to go to CCM for her doctorate, so I went with her.

(03:18):
We met there, we started dating,and then I just followed her up
to Cincinnati. So that's how we ended up here.
I think that Jill was already out of CCM so I don't actually
remember how they met, but it's like CCM connections in some
way. Yeah, I I was under the
impression you all went to CCM together, so I just learned
something completely new about. Yeah, I just sort of like

(03:38):
attached myself to CCM stuff even though I never went there.
Well, it's great people, it's a great place to attach yourself
to. So non musical family, you kind
of started it and now you're married to a musician as well.
So start to a wonderful musical family.
So you guys being teachers, is that how you got the idea for

(04:01):
Piano Music Database? Were you seeing a need and you
wanted to fill it? It was a need for myself,
really. I had this adult student that
I've been teaching for a while, and she was very particular
about the kinds of music that she would play.
So I had things that I needed her to learn.
We weren't in a method book. And so I just had all these
concepts I was introducing to her and she would tell me very

(04:25):
bluntly, like, I don't like thispiece.
I can't play this one, I don't want to do this one.
So I was always looking for music for this student and it
was kind of a pain because thereweren't a lot of good resources
that were doing or that were giving me the kinds of pieces
that I was looking for, giving me access to the pieces I was

(04:45):
looking for. So I just started creating my
own spreadsheets for, for repertoire, analyzing the music
and coming up with the teaching concepts in them so that I could
like have like a list of pieces I would pull for her and other
students. And eventually I realized that
this was something that other teachers probably would be
interested in. And so I talked to my brother

(05:08):
who is a web developer, and I was like, how can I turn this
spreadsheet into a website or something that other people can
use? And that's when it really
started to take off for me. That was in 2020, so May of
2020, right during the pandemic.I, I feel like I have all these
random lists of music in different places, or I'll see

(05:30):
something on social media and I'll tag it, I'll screenshot it,
but everything is so scattered. So when I actually need to look
at stuff, which is usually in the middle of a lesson, and I
never know where to look, like I'm like, wait, where did I put
that? Is that my drive?
Is that in Word? You know, so I can see how this
would make so much more sense because it's all in one place.

(05:51):
Yes, yeah. And I'm like a natural
organizer. My, I have like a very
analytical brain, which maybe doesn't work so well for music,
but in this case, putting both of my interests together, I just
am like obsessed with organizingthings and trying to understand
how everything works together and to make it like for me, give

(06:12):
me kind of a broad sense of, of,of everything.
So this project just sort of like slotted itself really
nicely into my. I love that.
OK, so and let's talk about piano music database itself.
So this is much more than just having a spreadsheet saved in
your computer. You have it where we have
filters and different things. Could you just describe what

(06:36):
exactly this database is and whyit's so useful for teachers?
Yes. So we have analyzed now
thousands of pieces, myself and some other teachers that I work
with on this project, we go in and we find all of the teaching
concepts in the pieces. We also find and categorize the

(06:57):
key signature, the time signature, the mood of the
piece, the style, any kind of like theme, like animals or
trains or whatever the piece might be about.
That's important. Yes, some students, definitely.
And so every piece that goes into the database has all these
data points and that allows teachers who are using it to

(07:18):
then apply filters to find pieces with all of those data
points that they need in their teaching.
And it's very like specific for,for teaching.
So imagine like you have a late elementary student who's
learning how to play eighth notes.
And so you're, you need a piece that will help reinforce their
skills with 8th notes. And they like playing pieces

(07:40):
about animals, for example. So you can find all those things
really easily in the database. You just go to the levels
filter, you click it and you do 8 elementary, then you do 8th
notes teaching concept, and thenyou do the animals theme.
And it's just going to show you all the results in our database
where the pieces match all threeof those those qualifications.

(08:00):
You can imagine like how long that would take with other
sources where it'd be like I'm looking through the repertoire
guidebook and I'm just flipping around and I'm an hour has gone
behind. I haven't found anything close
to what I'm looking for. Or if I go to my library and I'm
searching through my anthologiesand I'm trying to find this, it
would be very time consuming. So we're basically taking all of
that effort that you would that you would have to expend finding

(08:23):
in different locations, putting it all on in one place and
giving you the power to search through all the data that we
collect. That's amazing.
I think it's Joy. Morin just had a recital and it
was food themed. A lot of teachers have these
themes. I think it's such a great idea.
And I know that's gonna be hard to find the music to fit.

(08:44):
You know, maybe it is jungle animals or food or that kind of
thing. So you could probably look that
stuff up in your database. I have done that for my own
students for their recitals cuz I do like doing themed recitals.
So yeah, it's very easy on the database.
You just go to the search page and you go to themes and you can
like type your own themes out and see if it comes up.

(09:06):
You can find closely related themes.
So like if we just had spring recital season, so if I wanted
to find pieces about spring, I could just do the tag, the theme
tag for spring and it would showme at this point probably 100 or
so pieces that have spring related to spring in some way.
And then I could go through and start applying levels filters.

(09:26):
So I could find a spring piece for my pre readers.
I could find a spring piece for my intermediate and elementary
all the way up to like master level if there was pieces like
that. So you could essentially plan or
find pieces for your whole recital using the the database
and it would be pretty simple. To think about how much time
that would save somebody, I mean, it sounds like you just

(09:46):
took hours of research and put it into minutes.
That's amazing. Yes, we're kind of doing the
research for you. Like ahead of time we were going
through and categorizing all thestuff.
So then you don't have to do that on your own.
So is this just supplemental music or is this methods as
well? Is it a little bit of everything
you're just always adding we? Have a little bit of everything
we have. We just now started working

(10:09):
through method books. We have several of them already
in the database and we are working on adding more of them.
So that's in there. We have supplemental repertoire
by like modern living composers,pedagogical composers and non
pedagogical like. We have standard classical Rep
as well. Public domain music by all of

(10:30):
the famous composers. And then we also are focusing a
lot of our effort on getting underrepresented composers in
the database too, so you can useit to find a little bit of
everything. I love that so much.
So let's say that you have this list.
Do you have websites and all that good stuff on how to access

(10:50):
the music if we need to purchaseit?
Yes, so, but we are in, in a sense we're kind of like Kayak.
If you're familiar with Kayak where you go and it's got all
the hotels that fit your criteria and then from there you
go to the hotel's website or someplace else to buy them.
You the the hotel. So we're kind of like that.
We show you all the pieces, you go to the pieces page and you

(11:13):
can see all the information about it, the video and all
that. And then it will show you all
the different locations where it's available to purchase.
So most of the time Sheet music Plus or Amazon, but increasingly
we are just linking directly to the composer's website or
directly to the publishers website.
If it's a public domain piece, we'll do all of that, plus we'll
show the IMSLP page for it. So you'll have an option if you

(11:36):
want to buy a newer edition of it.
Or if you want to wade through all of the editions on IMSLP to
find a free 1, you could do thattoo.
Wow. OK, hold on.
You said videos. Does that mean that we get to
preview the music? Yes.
As well. So we'll go to YouTube and we'll
try to find the best recording we can of each of the pieces.

(11:58):
So most of the music has a recording, but not everything
has a recording yet. So I would say at this point,
maybe 85 to 90% of the pieces are recorded and on YouTube.
So we've just linked those. This has had to have taken so
much work. Yeah, behind the scenes.
Yeah, I do split it up. I have a team of of teachers who

(12:19):
helped me with this and they'll be set on tasks.
Like they just go, one person goes and finds all the videos,
one person finds all the teaching concept, one does the
leveling. And I kind of then it's all sent
to me. And then I do like a final
review of it all before it gets published.
But yeah, at the beginning I wasdoing it all on my own and I
realized that that was a severe bottleneck.
Like it was just getting piled up at me.

(12:41):
And I was like, had all these ideas and all this music go on
and it's just not enough time todo it all.
So yeah, it's, there's, there's a few people that that work with
me on this. I just had my recital finish up
a few weeks ago and the lesson after we do kind of a reflection
and then I find myself with somestudents.
So what do you want to work on this summer?

(13:04):
Do you want to work on a specialproject?
You know, because summer is coming up and I always try to do
something a little bit different.
So I could pull up this website in the middle of a lesson, I
could do like a beep bop boop type thing, Type it in and in
front of the student I could have them listen to the piece
and we could decide right then and there if they want it.

(13:25):
Oh yeah, put. Them to preview.
Yeah, totally. So a new, along those same
lines, a new feature that we're coming out with is the ability
to like put everything into customized lists.
So you could do that in a lessonwith your student, find all
these pieces, put them into a list and then you could like
send the list to them and have them listen to them again at

(13:47):
home. Or you could do it like before
the lesson and send it to them in between a lesson and have
them listen to everything. There's a lot of ways that you
can use that feature. And that's a very exciting thing
that for me because like the search engine is exciting
enough, but also being able to then do other things on the site
besides music or besides findingmusic, like organizing all the

(14:08):
music, is very exciting to me too.
See, this is just goes to show why it's so important that
teachers are the ones who do this because you know what to
look for because you're experiencing it first hand.
Let's say that you're maybe not so much a techie teacher like
you said you were very analytical and spreadsheet.
I am like miss post it notes everywhere and learning new

(14:33):
things on the computer for me take a lot of time.
Would you say that this is pretty simple for teachers to
use? Like pretty user friendly or is
that something you've been working on?
Yes. So we're really focused on it
being easy to use. It's just a website.
It's not like an app or a piece of software that needs to be
downloaded first or anything. You just need to create an

(14:55):
account to to access it, which is a fairly simple process.
But the the site has been built to work well on desktop, tablet,
phone and we try to design it sothat it's very minimal that
there's only enough information to get you what you need.
We don't we try not to like blast you with all kinds of

(15:15):
things on the UI. So it's, it is fairly simple and
if you're used to like shopping online or using a search engine
for anything like Amazon or something, it's fairly similar
to that. You have your filters on one
side, you have your results on the other and like the ability
to sort and that sort of thing. So it it we tried to mimic other

(15:37):
sites that have search engines so that it feels natural and
there's not a big learning curvegoing from one to the next.
OK, awesome. Well, I'm really good at
shopping on Amazon, so we'll be just fine in the area.
Played around with your website.I have to admit, I, I keep
meaning to get on there because I know you have new promotions.
You have all kinds of new stuff because you were showing it to

(15:59):
me at the MTNA, which by the way, if anybody's going to the
NCKPI saw you posted on a post, you're going to have a zoo there
as well. OK, so everybody needs to visit
William at NCKP for sure. And you'll be wowed by this if
you don't just jump on and do itanyway because you should.
So I know that at NCKP you plan on having some special

(16:22):
announcements, but until then you're still kind of sampling
some stuff out. So how can a teacher join and
can they access all the features?
Do they need to pay for it? How?
How is it work right now? Right now we're in a beta
testing period, which we're calling early access.
So anybody who goes to pianomusicdatabase.com creates

(16:42):
an account for free. You can access all of the
features of the site that includes the search engine, the
ability to favorite a work and then creating unlimited custom
lists of works. All that is free for now for you
to try out and basically give usfeedback on and make sure that
we are developing the features the way that you want them.

(17:03):
And then at NCKP, when we launched the official
subscription, we'll be giving away coupon codes and discounts
for for everybody who signed up for the early access period.
Oh wow. So it's pretty much like if we
Join Now early June, you pretty much get like a four or five
week free in depth trial is how we can look at it.
When you try, when you sign up now, it's, you know, you're kind

(17:25):
of helping us shape the the future of the database.
You're giving us feedback, useful feedback about how we can
develop the product and make it better and more useful for you.
So, so it is as a thank you for that, we will be giving discount
codes afterwards. So awesome.
OK, so it's been up there for a bit and it has been free.
So have you gotten any feedback lately that's kind of surprised

(17:46):
you as you've released this betafeature?
So I go to these conferences a lot and I meet a lot of people
who are, we're just very excitedabout this project because
they'll tell me, oh, I, I don't know, like I've always wanted
something like this. And I've never had the time or

(18:06):
the energy to, to make a projectlike this come to reality.
And it is, it's really great to hear people say that because it
is a lot of work, you know, likeevery piece that goes in you
have to do an in depth analysis for and you know, they're like
the piano repertoire is endless.It just keeps going and going.
More people are making music andthere's all this and endless

(18:26):
music going backwards too. And so it is a lot of work.
But it is really great to hear piano teachers like me using the
software to find music for theirstudents.
I've also had collegiate professors tell me that they're
using it in their pedagogy classes, which has been really
awesome to hear. So just a lot of positive

(18:47):
feedback in terms of like the depth of this project and how
like how complex it is. It's been great.
It has to be so encouraging too,especially after all that work,
to hear that. I wouldn't even think about them
using that in classes. But that makes so much sense.
Sometimes I hear these things and I think about all that we
have access to and I think about20 years ago when I was, you

(19:10):
know, a new teacher and I'm thinking how did I no wonder why
I literally just stuck with the same method book for so many
years and now we can just do something like this.
So I. This is great.
I remember doing that when I wasyounger too.
And I actually, I find that I kind of have the same sort of
feeling when I'm on the website where I'm just like perusing

(19:31):
through books. I have a lot more information
about it than like perusing through a book because I can
then go and go to the composer'spage and learn more about the
composer and then go from the composer's page to other music
of theirs. And like, there's this web of
connections for all the music, so you get even more out of it.
But at the core for me is the the feeling of discovering new

(19:53):
music and just kind of browsing and seeing, seeing what I can
confine. That's a great feeling.
And yes, it is digital and so you don't get the physical
feeling of opening up a book, but I try to recreate that as
much as possible in the sort of digital format.
I, yeah, I and you know what else I love that you said at the

(20:14):
beginning is how you try to linkit as much as possible to the
composer. So if it's a living composer,
you try to get to that page. And I think that support is such
a big deal and it makes me want to go on there and support it
just so that I can support them directly as much as possible.
So if somebody wants to try it out, is it just
pianomusicdatabase.com? Is that right?

(20:35):
That is it. Yeah, you'll, you'll be, you'll
get. That'll take you to the home
page and you can create an account there and that'll open
up all of the features of the site for you.
So they can just go to the website, they can just create
their free account, they'll get some specials after NCKP time.
Is that right? And then are there other ways to
connect if we want to do so before all that good stuff

(20:57):
happens? Yes, there's a Facebook group
that we just started. It's just called Piano Music
Database Users and anybody who creates an account can sign up
as a member of that group. And that will be our community
hub for for the database where you can ask questions from me
and other people on the team, connect with other users.

(21:19):
We've got composers and publishers who are joining that
group too. They'll probably be promoting
their music. It will make promotions with
them, let you know about new, new things that are added to the
database. You'll also get to vote on new
features to come to the databaseor new music that we're going to
add. We want to make sure that we're
connecting with our users and giving our users what they feel

(21:43):
like they need. So if you want more from us and
you want to connect with us at the very beginning of this
project, the Facebook group is going to be a good way to do
that. And it's free.
It doesn't cost anything to go on there.
Yeah. So if any composers are
listening, they need to definitely be in that group.
Yes, for sure. And we have any composer or

(22:03):
publisher can create an account and start adding their music
themselves. So we already have lots of
composers who have started to dothat, especially independent
composers who just have their own website and are promoting
their music that way. This is a really great
opportunity to to promote your music to piano teachers.
Because when a teacher goes to the search engine to find a

(22:26):
piece and they've put in all of their characteristics that
they're looking for and they find a piece that matches
everything, you know that they're very likely to then go
and buy that music because they already know that it matches
what they need. When by the time we send our
user over to your site, they're probably going to buy the music.

(22:47):
We are trying to help everyone out.
Bigger publishers can be on the site and smaller independent
composers can get benefit from it as much.
And you are also on Instagram, so if somebody is not on
Facebook, you can go to Instagram, but they should
definitely join that Facebook page and then they can connect
with you directly from there if they have any questions.

(23:08):
And there's there's contact buttons on the site.
Every page of the site has like a feedback too.
So if you ever run into an issue, there's ways to contact
us directly if like something iswrong or you have a question.
Awesome. I am so excited for you.
All right, well, William, this was awesome.
Thank you so much for joining me.
And I'm I'm going to look, I'm going to be watching.
I'm excited to see where the sun's up.

(23:30):
Yeah. Thanks for having me.
Thanks for letting me come on and talk about things.
Thanks. I really appreciate.
It listen that's so good. Thank you William.
Big thank you to William for sharing both the behind the
scenes work and all of the incredible ways teachers can
start using piano music databaseright now.
And if you found this helpful, which I know you did, be sure to

(23:53):
leave a five star review on yourfavorite podcast app for yours
truly. And because I mean, hello, it
helps other piano teachers just like you find the show and feel
a little less alone in chaos. Also, come hang out with me on
the brand new YouTube channel The Scrappy Piano Teacher.
I'll be posting more this summer.

(24:14):
I'm going to post some extra stuff to you with some goodies
like reviews and all that kind of stuff.
And don't forget to subscribe atthe Scrappy pianoteacher.com so
you can stay in the loop with all the happenings.
Plus grab some new free resources the second day drop.
Thanks for listening all you Scrappy Vienna teachers.
I'm so thankful for you and I will see you next time.

(24:36):
Bye.
Advertise With Us

Popular Podcasts

Crime Junkie

Crime Junkie

Does hearing about a true crime case always leave you scouring the internet for the truth behind the story? Dive into your next mystery with Crime Junkie. Every Monday, join your host Ashley Flowers as she unravels all the details of infamous and underreported true crime cases with her best friend Brit Prawat. From cold cases to missing persons and heroes in our community who seek justice, Crime Junkie is your destination for theories and stories you won’t hear anywhere else. Whether you're a seasoned true crime enthusiast or new to the genre, you'll find yourself on the edge of your seat awaiting a new episode every Monday. If you can never get enough true crime... Congratulations, you’ve found your people. Follow to join a community of Crime Junkies! Crime Junkie is presented by audiochuck Media Company.

24/7 News: The Latest

24/7 News: The Latest

The latest news in 4 minutes updated every hour, every day.

Stuff You Should Know

Stuff You Should Know

If you've ever wanted to know about champagne, satanism, the Stonewall Uprising, chaos theory, LSD, El Nino, true crime and Rosa Parks, then look no further. Josh and Chuck have you covered.

Music, radio and podcasts, all free. Listen online or download the iHeart App.

Connect

© 2025 iHeartMedia, Inc.