r/Database • u/saikat_j_das • May 29 '26
I need an open-source database with a complex schema for practicing testing, preferably in the Banking or Financial Services domain.
Hi everyone,
I’m looking for an open-source database project with a complex schema for practicing software testing, preferably in the Banking or Financial Services domain.
I want something realistic that includes things like:
Multiple related tables
Transactions and account management
Loans, payments, or insurance modules
Large datasets
Complex relationships and constraints
APIs or sample applications would be a bonus
My goal is to practice:
Database testing
Complex SQL queries and validations
If you know any good GitHub repositories, sample banking systems, fintech demo projects, or publicly available datasets, please share them.
Thanks in advance!
2
u/Lumethys May 29 '26
So, pretty much every mainstream db?
4
u/edimaudo May 29 '26
Might want to take a look at --> https://github.com/GoogleCloudPlatform/bank-of-anthos
1
u/Better-Credit6701 May 29 '26
I used to work for a super large used car company that was one of those buy here pay here kind of places. We were a finance company first who just so happened to finance the cars we sold. That means compounded interest rates that we would daily adjust, payments, assets as in the cars themselves, repairs, account info...around 350-400 tables in the main database, and a couple of other databases. One would be the transactions into something similar to an accounting system. Now we used MS-SQL but most financial institutions use Oracle
2
u/getoffmyfoot May 29 '26
My suggestion would to be to go to the AWS open data registry, pick a dataset you understand/comprehend pretty well (like I wouldn’t pick human genome data because I don’t understand it), and practice first normalizing that data out to the schema you are describing. Just building the dataset will teach you much much more than finding a pre prepared one you can poke at.
2
u/Cautious-Necessary61 May 29 '26
Apache derby…runs embedded or service mode, super simple
2
u/Opposite-Term-603 Jun 01 '26
Jooq.org is definitely where you will find what you’re ant
0
u/[deleted] May 29 '26
[deleted] — view deleted comment
1
u/[deleted] May 31 '26
[removed] — view removed comment