Database Schema Templates
Browse open-source database schema templates for your next project. Use them as a starting point for your ERD design.
Real Service Schemas
Schema designs inspired by real-world products
Twitter / X
CloneMicroblogging platform with tweets, follows, likes, retweets, and DMs
Photo and video sharing platform with stories, reels, explore, and direct messaging
YouTube
CloneVideo streaming platform with channels, videos, playlists, comments, and monetization
GitHub
CloneCode hosting platform with repositories, issues, pull requests, and CI/CD
Netflix
CloneVideo streaming platform with content catalog, profiles, subscriptions, and recommendations
Spotify
CloneMusic streaming platform with tracks, artists, albums, playlists, and social features
Discord
CloneCommunity platform with servers, channels, roles, voice, and bots
Slack
CloneTeam messaging platform with workspaces, channels, threads, and integrations
WhatsApp Clone
CloneReal-time messaging platform with conversations, groups, media, stories, and calls
Reddit Clone
CloneCommunity voting platform with subreddits, posts, comments, and awards
Professional networking platform with profiles, connections, job boards, and content
Shopify
CloneE-commerce platform with multi-store support, product variants, fulfillment, and discounts
Airbnb
CloneShort-term rental marketplace with listings, bookings, availability, and reviews
Uber
CloneRide-sharing platform with drivers, real-time tracking, fare calculation, and payments
Notion
CloneAll-in-one workspace with hierarchical pages, block-based content, and inline databases
Trello Clone
CloneKanban project management with boards, lists, cards, checklists, and labels
Stripe
ClonePayment infrastructure platform with payment intents, subscriptions, invoices, and webhooks
Figma
CloneCollaborative design platform with files, components, versions, and comments
Medium Clone
ClonePublishing platform with articles, publications, claps, and subscriptions
Pinterest Clone
CloneVisual discovery platform with pins, boards, saves, and topic-based follows
Domain Templates
General-purpose templates by industry domain
E-Commerce Platform
Complete database schema for an online store with products, orders, customers, payments, and inventory management.
Blog / CMS Platform
Content management system database schema with posts, categories, tags, comments, and user roles.
SaaS Multi-Tenant
Multi-tenant SaaS application database with organizations, team members, roles, subscriptions, and API keys.
Multi-Vendor Marketplace
Database schema for a multi-vendor marketplace with stores, products, orders, reviews, and seller payouts.
Subscription Box Service
Database schema for a subscription box service with recurring plans, curated boxes, and shipment tracking.
Digital Product Store
Database schema for a digital product marketplace with creators, licenses, downloads, and customer reviews.
Inventory Management System
Database schema for warehouse inventory management with products, stock movements, suppliers, and purchase orders.
Forum / Community
Community forum database schema with users, categories, threads, posts, and likes.
Job Board
Job board database schema with companies, job listings, applications, candidates, and skills.
Booking / Reservation System
Booking system database schema with venues, services, time slots, bookings, and customers.
Wiki / Knowledge Base
Wiki and knowledge base database schema with users, spaces, pages, page versions, and comments.
Analytics Dashboard
Analytics platform database with workspaces, dashboards, widgets, data sources, events, and reports.
Helpdesk Ticketing
Helpdesk platform database with agents, customers, tickets, messages, categories, and SLA policies.
Project Management
Project management tool database with workspaces, projects, tasks, comments, and team members.
CRM
Customer relationship management database with organizations, contacts, deals, activities, pipelines, and pipeline stages.
Social Network
Database schema for a social networking platform with users, profiles, posts, comments, friendships, and likes.
Messaging & Chat
Database schema for a real-time messaging and chat application with conversations, members, messages, and file attachments.
Content Creator Platform
Database schema for a content creator platform with creators, content, media, subscriptions, comments, and likes.
Dating App
Database schema for a dating application with users, profiles, preferences, matches, and messaging.
Community Forum
Database schema for a community forum platform with users, communities, memberships, posts, and comments.
ERP Basic
Core ERP database schema with departments, employees, products, customers, orders, and invoices for small to mid-sized businesses.
HR Management
Human resources database schema with employees, departments, positions, leave requests, payroll, and performance reviews.
Asset Management
IT asset management database schema with assets, categories, assignments, maintenance logs, and vendors.
Document Management
Document management system schema with users, folders, documents, version history, and granular permissions.
Workflow Automation
Workflow automation database schema with workflows, steps, runs, run steps, and triggers for business process orchestration.
LMS Learning Platform
Complete database schema for a Learning Management System with courses, lessons, enrollments, progress tracking, and quizzes.
School Management System
Database schema for managing schools with students, teachers, classes, subjects, grades, and attendance tracking.
Online Course Platform
Database schema for an online course marketplace with instructors, courses, sections, lectures, and student reviews.
Library Management System
Database schema for a library system with books, members, loans, reservations, and categories.
Student Portal
Database schema for a student portal with courses, assignments, submissions, grades, and announcements.
Patient Records (EHR)
Electronic health records system with patients, doctors, appointments, medical records, prescriptions, and diagnoses.
Pharmacy Management
Pharmacy management system with medications, suppliers, inventory, prescriptions, and sales tracking.
Clinic Appointment System
Clinic management system with doctors, patients, appointments, services, and payment tracking.
Telemedicine Platform
Telehealth platform with providers, patients, consultations, prescriptions, and video session management.
Lab Management System
Laboratory management system with patients, tests, test results, samples, and lab technician tracking.
Banking System
Core banking system with customers, accounts, transactions, transfers, cards, and loan management.
Payment Gateway
Payment processing platform with merchants, transactions, payment methods, refunds, and webhook event logs.
Accounting System
Double-entry accounting system with chart of accounts, journal entries, journal lines, invoices, and invoice items.
Investment Portfolio
Investment management system with investors, portfolios, assets, trades, and dividend tracking.
Insurance Claims
Insurance claims management with policyholders, policies, claims, claim documents, and adjuster assignments.
Fitness Tracker
Database schema for a fitness tracking app with workouts, exercises, and personal goals.
Food Delivery App
Database schema for a food delivery platform with restaurants, menus, orders, and delivery drivers.
Ride Sharing App
Database schema for a ride-sharing platform with riders, drivers, rides, payments, and ratings.
Task Management
Database schema for a task management app with projects, tasks, labels, and user assignments.
News Feed App
Database schema for a news aggregation app with articles, categories, comments, and bookmarks.
IoT Device Management
Database schema for IoT device management with telemetry data, alerts, and firmware tracking.
Real Estate Platform
Database schema for a real estate platform with properties, agents, listings, inquiries, and appointments.
Event Management
Database schema for event management with organizers, events, tickets, attendees, and venues.
Logistics & Shipping
Database schema for logistics and shipping management with shipments, packages, warehouses, carriers, and tracking.
Gaming Leaderboard
Database schema for a gaming platform with players, games, scores, achievements, and player achievements.