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

Clone

Microblogging platform with tweets, follows, likes, retweets, and DMs

PostgreSQL17 tables
socialmicrobloggingreal-time+2
Social

Instagram

Clone

Photo and video sharing platform with stories, reels, explore, and direct messaging

PostgreSQL17 tables
photosocialstories+2
Social

YouTube

Clone

Video streaming platform with channels, videos, playlists, comments, and monetization

PostgreSQL15 tables
videostreamingcontent+2
Social

GitHub

Clone

Code hosting platform with repositories, issues, pull requests, and CI/CD

PostgreSQL16 tables
developer-toolsgitcollaboration+2
Web App

Netflix

Clone

Video streaming platform with content catalog, profiles, subscriptions, and recommendations

PostgreSQL15 tables
streamingvideosubscription+2
Web App

Spotify

Clone

Music streaming platform with tracks, artists, albums, playlists, and social features

PostgreSQL18 tables
musicstreamingplaylist+2
Web App

Discord

Clone

Community platform with servers, channels, roles, voice, and bots

PostgreSQL15 tables
gamingcommunityvoice+2
Web App

Slack

Clone

Team messaging platform with workspaces, channels, threads, and integrations

PostgreSQL14 tables
messagingcollaborationteam+2
Web App

WhatsApp Clone

Clone

Real-time messaging platform with conversations, groups, media, stories, and calls

PostgreSQL16 tables
messagingchatrealtime+1
Web App

Reddit Clone

Clone

Community voting platform with subreddits, posts, comments, and awards

PostgreSQL16 tables
socialcommunityvoting+2
Social

LinkedIn

Clone

Professional networking platform with profiles, connections, job boards, and content

PostgreSQL15 tables
professionalnetworkingjobs+2
Social

Shopify

Clone

E-commerce platform with multi-store support, product variants, fulfillment, and discounts

PostgreSQL15 tables
e-commercemulti-tenantinventory+2
E-Commerce

Airbnb

Clone

Short-term rental marketplace with listings, bookings, availability, and reviews

PostgreSQL15 tables
rentalmarketplacebooking+1
Web App

Uber

Clone

Ride-sharing platform with drivers, real-time tracking, fare calculation, and payments

PostgreSQL14 tables
ride-sharinggig-economygeolocation+2
Web App

Notion

Clone

All-in-one workspace with hierarchical pages, block-based content, and inline databases

PostgreSQL15 tables
productivitynoteswiki+2
Web App

Trello Clone

Clone

Kanban project management with boards, lists, cards, checklists, and labels

PostgreSQL16 tables
kanbanproject-managementtasks+1
SaaS

Stripe

Clone

Payment infrastructure platform with payment intents, subscriptions, invoices, and webhooks

PostgreSQL15 tables
paymentsfintechbilling+2
SaaS

Figma

Clone

Collaborative design platform with files, components, versions, and comments

PostgreSQL15 tables
designcollaborationprototyping+1
Web App

Medium Clone

Clone

Publishing platform with articles, publications, claps, and subscriptions

PostgreSQL14 tables
bloggingpublishingarticles+1
Web App

Pinterest Clone

Clone

Visual discovery platform with pins, boards, saves, and topic-based follows

PostgreSQL16 tables
socialvisualpins+2
Social

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.

PostgreSQL12 tables
e-commerceshoppingpayments+2
E-Commerce

Blog / CMS Platform

Content management system database schema with posts, categories, tags, comments, and user roles.

PostgreSQL10 tables
blogcmscontent+2
Web App

SaaS Multi-Tenant

Multi-tenant SaaS application database with organizations, team members, roles, subscriptions, and API keys.

PostgreSQL10 tables
saasmulti-tenantsubscription+2
SaaS

Multi-Vendor Marketplace

Database schema for a multi-vendor marketplace with stores, products, orders, reviews, and seller payouts.

PostgreSQL11 tables
marketplacemulti-vendore-commerce+3
E-Commerce

Subscription Box Service

Database schema for a subscription box service with recurring plans, curated boxes, and shipment tracking.

PostgreSQL10 tables
subscriptionrecurringbox+3
E-Commerce

Digital Product Store

Database schema for a digital product marketplace with creators, licenses, downloads, and customer reviews.

PostgreSQL10 tables
digitaldownloadslicenses+3
E-Commerce

Inventory Management System

Database schema for warehouse inventory management with products, stock movements, suppliers, and purchase orders.

PostgreSQL11 tables
inventorywarehousestock+3
E-Commerce

Forum / Community

Community forum database schema with users, categories, threads, posts, and likes.

PostgreSQL10 tables
forumcommunitydiscussion+2
Web App

Job Board

Job board database schema with companies, job listings, applications, candidates, and skills.

PostgreSQL10 tables
jobsrecruitmenthiring+2
Web App

Booking / Reservation System

Booking system database schema with venues, services, time slots, bookings, and customers.

PostgreSQL10 tables
bookingreservationappointment+2
Web App

Wiki / Knowledge Base

Wiki and knowledge base database schema with users, spaces, pages, page versions, and comments.

PostgreSQL10 tables
wikiknowledge-basedocumentation+2
Web App

Analytics Dashboard

Analytics platform database with workspaces, dashboards, widgets, data sources, events, and reports.

PostgreSQL6 tables
analyticsdashboardwidgets+3
SaaS

Helpdesk Ticketing

Helpdesk platform database with agents, customers, tickets, messages, categories, and SLA policies.

PostgreSQL6 tables
helpdeskticketingsupport+3
SaaS

Project Management

Project management tool database with workspaces, projects, tasks, comments, and team members.

PostgreSQL5 tables
project-managementtasksagile+3
SaaS

CRM

Customer relationship management database with organizations, contacts, deals, activities, pipelines, and pipeline stages.

PostgreSQL6 tables
crmsalespipeline+3
SaaS

Social Network

Database schema for a social networking platform with users, profiles, posts, comments, friendships, and likes.

PostgreSQL10 tables
social-networksocial-mediaposts+3
Social

Messaging & Chat

Database schema for a real-time messaging and chat application with conversations, members, messages, and file attachments.

PostgreSQL10 tables
messagingchatreal-time+2
Social

Content Creator Platform

Database schema for a content creator platform with creators, content, media, subscriptions, comments, and likes.

PostgreSQL10 tables
contentcreatorssubscriptions+3
Social

Dating App

Database schema for a dating application with users, profiles, preferences, matches, and messaging.

PostgreSQL10 tables
datingmatchingprofiles+3
Social

Community Forum

Database schema for a community forum platform with users, communities, memberships, posts, and comments.

PostgreSQL10 tables
forumcommunitydiscussion+3
Social

ERP Basic

Core ERP database schema with departments, employees, products, customers, orders, and invoices for small to mid-sized businesses.

PostgreSQL10 tables
erpenterprisedepartments+3
Enterprise

HR Management

Human resources database schema with employees, departments, positions, leave requests, payroll, and performance reviews.

PostgreSQL10 tables
hrhuman-resourcesemployees+3
Enterprise

Asset Management

IT asset management database schema with assets, categories, assignments, maintenance logs, and vendors.

PostgreSQL5 tables
assetsit-managementinventory+3
Enterprise

Document Management

Document management system schema with users, folders, documents, version history, and granular permissions.

PostgreSQL5 tables
documentsdmsfile-management+3
Enterprise

Workflow Automation

Workflow automation database schema with workflows, steps, runs, run steps, and triggers for business process orchestration.

PostgreSQL5 tables
workflowautomationbpm+3
Enterprise

LMS Learning Platform

Complete database schema for a Learning Management System with courses, lessons, enrollments, progress tracking, and quizzes.

PostgreSQL11 tables
lmslearningcourses+3
Education

School Management System

Database schema for managing schools with students, teachers, classes, subjects, grades, and attendance tracking.

PostgreSQL10 tables
schoolstudentsteachers+3
Education

Online Course Platform

Database schema for an online course marketplace with instructors, courses, sections, lectures, and student reviews.

PostgreSQL10 tables
online-coursesmarketplaceinstructors+3
Education

Library Management System

Database schema for a library system with books, members, loans, reservations, and categories.

PostgreSQL10 tables
librarybooksloans+3
Education

Student Portal

Database schema for a student portal with courses, assignments, submissions, grades, and announcements.

PostgreSQL10 tables
student-portalassignmentssubmissions+3
Education

Patient Records (EHR)

Electronic health records system with patients, doctors, appointments, medical records, prescriptions, and diagnoses.

PostgreSQL10 tables
healthcareehrpatients+3
Healthcare

Pharmacy Management

Pharmacy management system with medications, suppliers, inventory, prescriptions, and sales tracking.

PostgreSQL5 tables
healthcarepharmacymedications+3
Healthcare

Clinic Appointment System

Clinic management system with doctors, patients, appointments, services, and payment tracking.

PostgreSQL5 tables
healthcareclinicappointments+3
Healthcare

Telemedicine Platform

Telehealth platform with providers, patients, consultations, prescriptions, and video session management.

PostgreSQL5 tables
healthcaretelemedicinetelehealth+3
Healthcare

Lab Management System

Laboratory management system with patients, tests, test results, samples, and lab technician tracking.

PostgreSQL5 tables
healthcarelaboratorydiagnostics+3
Healthcare

Banking System

Core banking system with customers, accounts, transactions, transfers, cards, and loan management.

PostgreSQL10 tables
financebankingaccounts+3
Finance

Payment Gateway

Payment processing platform with merchants, transactions, payment methods, refunds, and webhook event logs.

PostgreSQL10 tables
financepaymentsgateway+3
Finance

Accounting System

Double-entry accounting system with chart of accounts, journal entries, journal lines, invoices, and invoice items.

PostgreSQL10 tables
financeaccountingdouble-entry+3
Finance

Investment Portfolio

Investment management system with investors, portfolios, assets, trades, and dividend tracking.

PostgreSQL10 tables
financeinvestingportfolio+3
Finance

Insurance Claims

Insurance claims management with policyholders, policies, claims, claim documents, and adjuster assignments.

PostgreSQL10 tables
financeinsuranceclaims+3
Finance

Fitness Tracker

Database schema for a fitness tracking app with workouts, exercises, and personal goals.

PostgreSQL10 tables
fitnesshealthworkout+2
Mobile

Food Delivery App

Database schema for a food delivery platform with restaurants, menus, orders, and delivery drivers.

PostgreSQL6 tables
fooddeliveryrestaurant+2
Mobile

Ride Sharing App

Database schema for a ride-sharing platform with riders, drivers, rides, payments, and ratings.

PostgreSQL5 tables
ride-sharingtransportationmobile+2
Mobile

Task Management

Database schema for a task management app with projects, tasks, labels, and user assignments.

PostgreSQL5 tables
tasksproductivityproject-management+2
Mobile

News Feed App

Database schema for a news aggregation app with articles, categories, comments, and bookmarks.

PostgreSQL5 tables
newscontentarticles+2
Mobile

IoT Device Management

Database schema for IoT device management with telemetry data, alerts, and firmware tracking.

PostgreSQL5 tables
iotdevicestelemetry+2
Other

Real Estate Platform

Database schema for a real estate platform with properties, agents, listings, inquiries, and appointments.

PostgreSQL5 tables
real-estatepropertylistings+2
Other

Event Management

Database schema for event management with organizers, events, tickets, attendees, and venues.

PostgreSQL5 tables
eventsticketingvenues+2
Other

Logistics & Shipping

Database schema for logistics and shipping management with shipments, packages, warehouses, carriers, and tracking.

PostgreSQL5 tables
logisticsshippingwarehouse+2
Other

Gaming Leaderboard

Database schema for a gaming platform with players, games, scores, achievements, and player achievements.

PostgreSQL5 tables
gamingleaderboardachievements+2
Other
Database Schema Templates | ERD Studio