Guide to Keeping Breeding Records | Pedigree Management and Efficient Data Utilization

The Meaning of Keeping Breeding Records—Why Data Sustains Life

For breeders who breed living organisms, records are not mere notes. Only when data on parent fish/parent individuals' health status, breeding pair combinations, number of offspring and survival rates, and growth transitions of juveniles and young animals accumulate can you answer questions like "Why can this pair breed successfully every time?" and "Why does this line show color enhancement so quickly?"

As experience accumulates, one tends to think they can manage everything in their head, but after 3 or 5 years, memories inevitably become hazy. Whether you have records on hand—whether paper or digital—significantly affects your reproducibility and accountability as a breeder.

Five Essential Items to Record

Start by organizing the minimum items to track.

1. Individual Identification Information Assign a unique ID to each individual. For corals, "Acro-2024-001" or for goldfish "RYU-F-23-05"—using species abbreviation + year + serial number is easiest to manage. Link it to a tag, chip, or photo.

2. Pedigree (Parent Records) Always record the IDs of both father and mother. For imported individuals, also note the source, farm name, and import date. If you can trace back three generations, you can visualize inbreeding risk.

3. Breeding and Spawning Date/Time Record breeding date, spawning confirmation date, and hatching date separately. This allows you to statistically understand the incubation period and breeding cycle for each species, enabling predictions for the next spawning.

4. Number of Offspring and Survival Rate Record the number spawned, number hatched, and number surviving (at one week and one month). If you also note environmental variables (water temperature, stocking density, food type), you can later verify the correlation with survival rate.

5. Health and Medication History Keep parasite treatment, illness, and medication records for each individual. If the same line repeatedly contracts the same illness, genetic immune characteristics may become visible.

Pedigree Management in Practice—Breeding Design with Inbreeding Coefficient in Mind

If you're pursuing breeding beyond a hobby level, you need to be aware of pedigree "depth." Inbreeding is effective for fixing specific traits, but it comes with drawbacks like reduced immunity, increased malformation rates, and decreased breeding capacity.

A practical metric is the Inbreeding Coefficient (Wright's Inbreeding Coefficient). The calculation is complex, but if you manage parent IDs in a tree structure, spreadsheets or specialized software can calculate it to some degree automatically. It is generally recommended to manage so the coefficient doesn't exceed 12.5% (equivalent to first-cousin mating).

A simpler approach is the Three-Generation Rule—an empirical guideline: "Avoid breeding combinations where the same individual appears more than once within three generations." Many breeders, not just those with well-documented pedigrees in dogs and cats, but also those working with corals and tropical fish, regularly refresh their lines by pairing imported wild-caught individuals with domestically-bred ones.

Using Digital Tools—From Spreadsheets to Databases

The choice of record medium depends on scale and use case.

Spreadsheets (Small-scale, Low Setup Cost) Google Sheets is accessible and easy to share. Simply dividing sheets into "Individual Ledger," "Breeding Records," and "Health Records" and linking them by ID is practical enough. Using filters and pivot tables, you can compile statistics like "Average survival rate of line X."

Notion & Airtable (Medium-scale, Relational Database Operation) Tools with relational database features allow you to create relations, making it convenient to instantly pull a list of offspring from a parent ID. Airtable excels at visual management with its gallery view, which displays individual photos in a list.

Specialized Software and Custom Systems (Large-scale, Reproducibility-focused) As scale expands, consider using pedigree management software for dogs and cats (e.g., BreederEarth, Breeders Assistant). Since commercial software for fish and reptiles is limited, more breeders are either embedding inbreeding coefficient calculation macros in spreadsheets or building custom systems with Notion + automation (Zapier / Make).

Building Analysis Habits to "Leverage" Your Data

Simply keeping records without using them is a waste. I recommend reviewing the following once a month.

• Breeding Pair Success Rate Ranking: Which pairs consistently spawn and rear fry successfully?
• Verification of Survival Rate and Environmental Variable Correlation: How do differences in water temperature, feeding amount, and stocking density affect survival rate?
• Comparison of Growth Speed Between Lines: Under identical conditions, compare body length and weight of individuals of the same age, and select faster-growing lines.

As this data accumulates, breeding design becomes possible—determining "which parent combination will produce stable traits in the next generation." Selective breeding and pairing based on numbers rather than intuition greatly increases your value as a breeder.

Information Disclosure to Buyers and Record Credibility

Record management is not just for yourself. When buyers want to know "what parents this individual came from and what environment it was raised in," a breeder who can present detailed care and breeding records gains overwhelming trust.

For rare organisms like corals and reptiles, pedigree transparency directly impacts price and reputation. If you can provide parent photos, spawning dates, and cultivation temperature and feeding history as a package, that itself becomes a differentiating factor.

When selling organisms through a breeder-direct marketplace, the richness of these records translates to buyer confidence, fostering repeat customers and word-of-mouth referrals. Think of records not as a burden, but as a brand asset as a breeder.

Starting today, the first step is to assign numbers to your current individuals and start writing at least one line about breeding dates and parent information. A simple system you can sustain is far more valuable than a perfect system.