skills.rest
0r0loo
0r0looCOMMUNITY
Explore all skills by this author →
GitHub

database

Guide database schema design, normalization, relationships, and optimization strategies.

Updated Feb 10, 2026
Search Tags:#indexing#schema design#database#optimization#sql#normalization
One-click install
npx skills add https://github.com/0r0loo/my-claude-code-toolkit --skill database-0r0loo
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/0r0loo/my-claude-code-toolkit/tree/main/.claude/skills/Database
Command: npx skills add https://github.com/0r0loo/my-claude-code-toolkit --skill database-0r0loo

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides comprehensive guidance on database design and optimization, ensuring efficient and scalable data management for any application.

Core Features & Use Cases

  • Schema Design: Establishes clear naming conventions and common column patterns.
  • Normalization & Relationships: Guides through normalization levels and relationship types (1:N, N:M, 1:1).
  • Optimization Techniques: Covers indexing, N+1 problem prevention, query optimization, and connection pooling.
  • Use Case: When designing a new e-commerce backend, use this Skill to define optimal table structures for products, orders, and users, ensuring efficient querying and data integrity.

Quick Start

Use the database skill to generate a SQL schema for a blog with posts and comments, including proper indexing and soft delete.

Frequently Asked Questions about database

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

FAQPage Schema
How do I design a database schema with proper normalization and relationships?▼

Database schema design requires following normalization levels and defining relationship types like 1:N, N:M, and 1:1. This Skill provides guidelines for table and column naming conventions, common columns, and relationship modeling to ensure data integrity and efficient querying.

What's the best way to optimize SQL queries and resolve the N+1 problem?▼

Optimize SQL queries by applying indexing strategies and analyzing execution plans using EXPLAIN. This Skill outlines techniques for N+1 problem prevention and query optimization to improve database performance and reduce latency.

How do I implement soft delete patterns and indexing strategies in my database?▼

Soft delete patterns and indexing strategies are implemented by following specific schema design guidelines. This Skill covers soft delete implementation, optimal indexing techniques, and connection pool configuration to maintain scalable data management.

Does this database design guidance work across different languages and ORMs?▼

Yes, the database design and optimization strategies apply across various languages and ORMs. This Skill provides language-agnostic guidelines for schema design, normalization, relationship modeling, and optimization techniques suitable for any application stack.

When do I need connection pool configuration for database optimization?▼

Connection pool configuration is needed when optimizing database performance for scalable applications. This Skill covers connection pooling alongside indexing strategies and query optimization using EXPLAIN to manage concurrent database connections efficiently.

Related Skills

Explore More Software Engineering Skills→
luanrodriguesluanrodrigues
2

bee:pre-dev-data-model

Model conceptual data structures, relationships, and ownership before database selection.

Community
Advanced
xloxn69xloxn69
7

sql-schema-generator

Generate SQL schemas, migrations, and table definitions with DDL constraints.

Community
Basic
EIS-ITSEIS-ITS

Backend Queries

Generate secure, optimized database queries with parameterized statements, eager loading, indexing, and transactions.

Official
Intermediate
ArieGoldkinArieGoldkin
10

database-schema-designer

Design normalized SQL and NoSQL database schemas with indexing and migration planning.

Community
Basic