skills.rest
xiaobei930
xiaobei930COMMUNITY
Explore all skills by this author →
GitHub

database

Design database schemas, indexes, and migrations across PostgreSQL, MySQL, Oracle, and SQLite.

49|3|Updated Jan 22, 2026
Search Tags:#design#indexing#database#postgresql#migrations#mysql#query-optimization
One-click install
npx skills add https://github.com/xiaobei930/claude-code-best-practices --skill database-xiaobei930
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/xiaobei930/claude-code-best-practices/tree/main/skills/database
Command: npx skills add https://github.com/xiaobei930/claude-code-best-practices --skill database-xiaobei930

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill centralizes best practices for database design, query optimization, and migrations across PostgreSQL, MySQL, Oracle, and SQLite, helping teams build scalable and maintainable data stores.

Core Features & Use Cases

  • Cross-database design principles covering multiple engines to ensure portability.
  • Best practices for naming conventions, indexing strategies, and migration workflows.
  • Use cases include designing normalized schemas, optimizing heavy read workloads, and safely applying schema changes in production.

Quick Start

Start by sketching a normalized orders schema with appropriate indexes and then plan a migration that minimizes downtime.

Frequently Asked Questions about database

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

FAQPage Schema
What's the best way to apply database migrations with minimal downtime in production?▼

Indexing strategies optimize heavy read workloads by applying per-engine guidelines for PostgreSQL, MySQL, Oracle, and SQLite, ensuring fast query performance and consistent database response times.

Does cross-database design guidance work for both MySQL and Oracle?▼

Cross-database design principles cover PostgreSQL, MySQL, Oracle, and SQLite, applying portability rules and per-engine guidelines to ensure schema consistency across multiple storage layers.

How do I optimize slow database queries using indexing strategies?▼

Query optimization uses targeted indexing strategies and per-engine guidelines to reduce latency in heavy read workloads, ensuring consistent performance across PostgreSQL, MySQL, Oracle, and SQLite.

When do I need normalized schemas for real-world database projects?▼

Normalized schemas are needed for real-world projects requiring scalable data stores, enforcing universal schema patterns and cross-database design principles to maintain data integrity and consistency.

Related Skills

Explore More Software Engineering Skills→
JuanDiego30JuanDiego30

postgresql-table-design

Automate PostgreSQL schema design covering normalization, indexing, constraints, and performance.

Community
Advanced
ZateZate
9

database-patterns

Provide database-pattern guidance for schema design, indexing, query optimization, and migration practices.

Community
Intermediate
ThejanaJayalathThejanaJayalath

kotlin-exposed-patterns

Standardize database access in Kotlin with Exposed ORM patterns.

Community
Advanced
devCharuzudevCharuzu

database-designer

Design database schemas with normalization checks and ERD generation.

Community
Advanced