awesome-database-design
github.com/sujeet-agrahari/awesome-database-design ↗:zap: A collection of resources and tutorials to design a better database schema.
Use this list with your AI agent
Add the Context Awesome MCP server to Claude, Cursor, or any MCP client, then ask:
"Show me common pitfalls resources from awesome-database-design"
Installation instructions →What's inside
Best Practices
- 8 Reasons Why MySQL's ENUM Is EvilCommon Pitfalls
ENUM pitfalls
- Boolean Field NamingCommon Pitfalls
Naming conventions
- Check ConstraintsData Integrity
Data validation
- Database Audit LoggingSecurity Considerations
Tracking database changes
- Database Design MistakesCommon Pitfalls
Common errors
- Database Security Best PracticesSecurity Considerations
Comprehensive security guide
Getting Started
- ACID Properties ExplainedFundamentals
Transaction properties every developer should know
- A Quick-Start Tutorial on Relational Database DesignDatabase Design Process
Comprehensive tutorial
- CAP TheoremFundamentals
Understanding distributed database tradeoffs
- Conceptual, Logical and Physical DesignDatabase Design Process
The three phases of database design
- Database Conceptual Design | Entities and RelationshipsDatabase Design Process
Understanding conceptual design
- Database Design BasicsFundamentals
Introduction to database design concepts
Tools & Software
- AlembicMigration Tools
Python database migrations
- ArchiMate ToolDatabase Design Tools
Enterprise architecture modeling
- BytebaseMigration Tools
Database governance platform: UI-driven or GitOps workflow (versioned or declarative), SQL review, approval, and a full API
- Datadog Database MonitoringMonitoring & Profiling
Multi-database monitoring
- DataGripDatabase Design Tools
JetBrains database IDE
- DB DesignerDatabase Design Tools
Online database designer
Database-Specific Resources
- Awesome MongoDBMongoDB
Curated MongoDB resources
- Awesome MySQLMySQL
Curated MySQL resources
- Awesome PostgreSQLPostgreSQL
Curated PostgreSQL resources
- Cassandra Data ModelingOther Databases
Wide-column store
- DynamoDB Best PracticesOther Databases
AWS NoSQL
- MongoDB Data ModelingMongoDB
Official guide
Design Patterns
- Best Practices for Multi-language Database DesignMulti-language Database Design
Comprehensive discussion
- Class Table InheritanceInheritance in Databases
Martin Fowler's pattern
- Closure Table PatternHierarchical Data Modeling
Efficient hierarchy storage
- Concrete Table InheritanceInheritance in Databases
Alternative approach
- Inheritance Modeling StrategiesInheritance in Databases
Detailed discussion
- Internationalization Database PatternsMulti-language Database Design
i18n patterns
Performance & Optimization
- B-Trees and B+ TreesDatabase Indexes
Understanding index structures
- Covering IndexesDatabase Indexes
Advanced indexing technique
- Explain Plan AnalysisQuery Optimization
Understanding query plans
- Full-Text Search IndexesDatabase Indexes
Text search optimization
- How Do Database Indexes Work?Database Indexes
Comprehensive explanation
- Indexed Views in SQL ServerViews and Materialized Views
SQL Server perspective
Core Concepts
- Cardinality in Data ModelingEntity-Relationship Modeling
Understanding relationships
- Character Set and CollationNaming Conventions
Understanding encoding
- Choose Your Database Identifiers WiselyNaming Conventions
Practical naming advice
- Composite KeysKeys and Relationships
When and how to use them
- Crow's Foot NotationEntity-Relationship Modeling
Popular ER diagram notation
- Database Naming StandardsNaming Conventions
Industry standards
Learning Resources
- Carnegie Mellon Database SystemsCourses & Video Tutorials
University lectures
- Database Design for Mere MortalsBooks
Beginner-friendly book
- Database Design PlaylistCourses & Video Tutorials
Design tutorials
- Database InternalsBooks
How databases work internally
- Database JournalBlogs & Articles
Featured articles
- Database Lessons PlaylistCourses & Video Tutorials
Comprehensive video series
Showing a sample of 200 resources. View the full list on GitHub →