Database Design Expert

The Database Design Expert skill provides comprehensive guidance for designing efficient, reliable, and performance-oriented database schemas. It addresses critical challenges in database design such as ensuring data integrity, optimizing query performance, and supporting safe schema evolution. By following the structured principles and recommended reading protocols, users can prevent common pitfalls like redundant data, slow queries, and complex migration issues. This skill is particularly focused on desktop applications, where local-first architectures and high-performance query patterns are essential. It emphasizes careful planning before implementing any schema changes, ensuring that database structures are robust, maintainable, and aligned with best practices.

Key features of the skill include advanced normalization and denormalization strategies, indexing techniques tailored to query patterns, full-text search schema optimization using FTS5, and constraint management for enforcing data integrity. The skill provides a clear framework for creating migration-friendly schemas, incorporating reversible changes, and testing database structures before deployment. Core principles such as Test-Driven Development (TDD) for database design, performance-aware schema planning, and constraint-based safeguards are emphasized. Additionally, the skill provides detailed guidance on SQLite data types, normalization levels, and practical implementation patterns for tables and indexes.

This skill is ideal for software engineers, database administrators, and developers involved in designing and maintaining desktop applications or local-first systems. Target users benefit from structured approaches to data modeling, improved query performance, and reliable schema evolution. Typical use cases include building audit and history tracking systems, configuring application settings storage, and implementing efficient search and retrieval mechanisms. By leveraging this skill, users can ensure their databases are both high-performing and resilient to changes, supporting long-term maintainability and application stability.