skills.rest
Leavesfly
LeavesflyCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Provide database schema design guidelines covering naming, keys, normalization, and indexing.

233|49|Updated Nov 4, 2025
Search Tags:#performance#indexing#schema design#database#optimization#sql
One-click install
npx skills add https://github.com/Leavesfly/Jimi --skill database-design-leavesfly
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/Leavesfly/Jimi/tree/main/src/main/resources/skills/database-design
Command: npx skills add https://github.com/Leavesfly/Jimi --skill database-design-leavesfly

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides comprehensive guidelines and best practices for designing efficient, maintainable, and scalable database schemas and optimizing SQL queries.

Core Features & Use Cases

  • Database Design Principles: Covers naming conventions, field type selection, primary/foreign key design, and normalization.
  • Indexing Strategies: Details different index types and optimization principles to improve query performance.
  • SQL Optimization: Offers techniques for query tuning, pagination, and avoiding common performance pitfalls.
  • Use Case: Ensure your new e-commerce platform's database schema is well-structured, performant, and adheres to industry best practices by following these guidelines.

Quick Start

Review the database design principles and best practices for creating efficient tables and queries.

Frequently Asked Questions about database-design

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
What are the best practices for database schema design and normalization?▼

Database schema design best practices involve applying naming conventions, selecting appropriate field types, and managing primary and foreign keys to ensure data integrity and normalization.

How do I optimize SQL queries and improve database indexing strategies?▼

Optimize SQL queries by applying effective indexing strategies, tuning queries, and avoiding common performance anti-patterns to significantly improve database application performance.

How should I handle SQL pagination for large datasets?▼

Handle SQL pagination by following specific optimization techniques provided for query tuning and pagination to avoid common performance pitfalls when querying large datasets.

What common database performance anti-patterns should I avoid during schema design?▼

Avoid database performance anti-patterns by adhering to structured schema design guidelines, ensuring proper field types and key management to maintain application performance.

Can I use these database design principles for an e-commerce platform?▼

Yes, these database design principles ensure new e-commerce platform schemas are well-structured, performant, and adhere to industry best practices for data integrity.

Related Skills

Explore More Software Engineering Skills→
Prorise-coolProrise-cool
24

data-modeling

Create conceptual, logical, and physical data models with ERDs and data dictionaries.

Community
Intermediate
H2OSLabsH2OSLabs
1

designing-database-schemas

Design relational database schemas and generate automated migrations with Python scripts.

Official
Intermediate
ShaulLavoShaulLavo

drizzle-orm

Provide type-safe SQL ORM queries for TypeScript applications.

Community
Advanced
duylinhdang1998duylinhdang1998

nosql-expert

Design NoSQL data models and optimization strategies for MongoDB and DynamoDB.

Community
Advanced