Discover a curated selection of Entity-Relationship Diagrams (ERDs) from open-source projects. Each diagram represents an actively maintained codebase, offering insights into how developers architect and manage their relational databases.
- Streamline Onboarding & Contributions: By visualizing a database schema, you can quickly comprehend an open-source project's structure, making it easier to submit valuable commits and stay engaged in the development process.
- Refactoring & Design Inspiration: Observe how various projects design their data models, define foreign keys, and optimize performance—sparking fresh ideas for your own applications.
- Hands-On Database Learning: Compare different schema designs to strengthen your database modeling skills and deepen your understanding of best practices.
- mastodon: Your self-hosted, globally interconnected microblogging community. (Source Code)
99 tables/PostgreSQL/Rails/100+ FK/bigint- Account Management, Timelines, Notifications, Conversations, Relationships, Content Filtering, Distributed Federation
- Maybe: The OS for personal finance (Source Code)
52 tables/PostgreSQL/Rails/Multi-Tenancy/Async Jobs/uuid/jsonb- Bank Aggregation, Budgeting, Investments, Payment Tracking, Multi-Tenancy, Data Enrichment, Data Syncing
- DocuSeal: Open source DocuSign alternative. Create, fill, and sign digital documents ✍️ (Source Code)
27 tables/PostgreSQL/Rails/31 FK/bigserial/Many-to-many relationships/Multi-tenancy- Document signing, template management, user management, OAuth authentication, webhooks
- dawarich: Self-hostable alternative to Google Location History (Source Code)
16 tables/PostgreSQL/Rails/bigint/jsonb/Active Storage- User Management, Points, Visits, Places, Trips, Notifications, Data Import/Export, Statistics