database-design
Database schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases. Use for designing schemas, writing migrations, or optimizing queries.
Security Assessment
About database-design
The 'database-design' skill provides comprehensive tools and guidelines for database schema design, optimization, and migration strategies across various database systems, including PostgreSQL, MySQL, and NoSQL databases. It addresses the challenges of ensuring efficient database architecture, optimizing queries for performance, and managing smooth migration processes. By following the principles of normalization, denormalization, and index optimization, this skill helps to improve database performance while maintaining integrity and scalability across applications.
FAQ
How can I use the 'database-design' skill for schema design?
You can use this skill to design normalized schemas using best practices like 1NF, 2NF, and 3NF, as well as denormalize tables for performance optimization. The provided SQL examples can guide you in setting up clean, efficient database schemas.
Is this skill compatible with PostgreSQL, MySQL, and NoSQL databases?
Yes, the 'database-design' skill is designed for use with PostgreSQL, MySQL, and NoSQL databases. It provides specific guidelines and SQL examples tailored for relational databases like PostgreSQL and MySQL, and general strategies that can be applied to NoSQL databases.
What is the recommended way to handle migrations using this skill?
The skill includes migration templates that focus on safe and zero-downtime migrations. It recommends using transactions, creating indexes concurrently, and backfilling data in batches to minimize the impact on database performance during schema changes.
How does the skill assist with query optimization?
The skill offers detailed advice on query optimization, including using EXPLAIN ANALYZE for performance insights, replacing IN clauses with EXISTS for large datasets, and utilizing keyset pagination for better performance in large result sets.
Are there any limitations to this skill?
The skill is focused on relational and NoSQL database schema design, query optimization, and migration strategies. It may not be suitable for specialized databases or advanced features that require custom solutions not covered by the general guidelines.
Install database-design
Quick Setup:
- Copy the skill folder to
.claude/skills/ - Claude will automatically detect and use the skill
Repository
skillcreatorai/Ai-Agent-Skills