database

Name: database
Availability: InStock
Author: xiaobei

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

Ready to run

npx skills add https://github.com/xiaobei930/claude-code-best-practices --skill database-xiaobei930

💬 Prompt for ChatGPT / Claude Chat▼

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.