The Mifos Data Model can be tricky to understand.  Understanding the Mifos data model including the Mifos production database schema, Mifos Data Warehouse schema and where information lies in what tables is essential to building reports and extracting data.

Linked to from this page are several resources to help you identify where to look for certain client and portfolio information that is stored in Mifos' MySQL Database.

Mifos Data Schema

A visualization of the tables in the Mifos database can be accessed from this Schemaspy output of the database. 

SQL Query Repository

On our developer wiki on MifosForge, we've created a repository of MySQL queries that are helpful in building out new custom reports in Pentaho, extracting data needed by management and Mifos users, and pulling out information from the Mifos database. Sample queries include number of loans outstanding, branchwise number of loans disbursed and amount disbured during period, etc.

• Database Query Repository (for queries run against production Mifos database)
• Data Warehouse Query Repository (for queries to be run against Mifos Data Warehouse - shipping with Leila E)