skills.rest
HouseGarofalo
HouseGarofaloOFFICIAL
Explore all skills by this author →
GitHub

database-mode

Guide relational and NoSQL database design, modeling, and query optimization.

3|1|Updated Feb 2, 2026
Search Tags:#query optimization#schema design#database#data modeling#sql#performance tuning
One-click install
npx skills add https://github.com/HouseGarofalo/claude-code-base --skill database-mode
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-mode
Source: https://github.com/HouseGarofalo/claude-code-base/tree/main/.claude/skills/database-mode
Command: npx skills add https://github.com/HouseGarofalo/claude-code-base --skill database-mode

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps users design efficient database schemas, write optimized queries, and understand database architecture principles, preventing performance bottlenecks and ensuring data integrity.

Core Features & Use Cases

  • Data Modeling: Guides through understanding domains, identifying entities, and normalizing schemas.
  • Query Optimization: Provides strategies for writing performant SQL and understanding EXPLAIN ANALYZE.
  • Index Strategies: Recommends appropriate indexing techniques for various database scenarios.
  • Use Case: When designing a new e-commerce platform, use this Skill to create a normalized schema for products, orders, and users, and to define optimal indexes for fast product searches and order lookups.

Quick Start

Use the database-mode skill to design a PostgreSQL schema for a blog with posts, authors, and comments.

Frequently Asked Questions about database-mode

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

FAQPage Schema
How do I design a normalized database schema for a new application?▼

Database schema design begins with domain understanding and entity identification. This Skill guides you through data modeling and normalization to ensure data integrity and prevent performance bottlenecks in relational databases.

What's the best way to optimize slow SQL queries?▼

Query optimization involves analyzing execution plans using `EXPLAIN ANALYZE`. This Skill provides strategies for writing performant SQL and recommends indexing techniques to resolve database performance bottlenecks.

How do I choose the right indexing strategies for my database?▼

Indexing strategies depend on specific query patterns and database scenarios. This Skill recommends appropriate indexing techniques alongside normalization and query optimization to ensure fast data retrieval and architecture performance.

Does this database design approach work for NoSQL databases?▼

Yes, this Skill provides expert database architecture guidance for both relational and NoSQL databases. It covers data modeling, transaction management, and performance tuning using database-specific best practices.

Why does my database transaction management cause performance bottlenecks?▼

Performance bottlenecks often stem from poor transaction management and unoptimized schema design. This Skill offers structured response formats for query analysis and database architecture best practices to resolve these issues.

Related Skills

Explore More Software Engineering Skills→
musujmusuj

phase-1-schema

Define project terminology, entities, relationships, and data structures.

Community
Intermediate
ntaksh42ntaksh42
1

database-migration-generator

Generate SQL and TypeORM database migration scripts with rollback support.

Community
Intermediate
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
miles990miles990
20

data-design

Guide relational and NoSQL database schema design with normalization and pipeline patterns.

Community
Advanced