skills.rest
MinhHoangDono
MinhHoangDonoCOMMUNITY
Explore all skills by this author →
GitHub

databases

Design database schemas, optimize queries, and manage safe migrations across SQL and NoSQL systems.

Updated Mar 7, 2026
Search Tags:#query optimization#indexing#migrations#PostgreSQL#database schema#Redis caching
One-click install
npx skills add https://github.com/MinhHoangDono/antigravity-kit --skill databases-minhhoangdono
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/MinhHoangDono/antigravity-kit/tree/main/.agent/skills/databases
Command: npx skills add https://github.com/MinhHoangDono/antigravity-kit --skill databases-minhhoangdono

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you design database schemas, write and optimize queries, and manage safe migrations so your application stays fast, correct, and maintainable as data grows.

Core Features & Use Cases

  • Schema design and normalization: Choose appropriate key strategies, normalization levels, and column types, including when to denormalize based on evidence.
  • Query optimization and indexing: Use EXPLAIN ANALYZE, avoid inefficient patterns like SELECT *, and design single/composite/partial indexes that match real query filters and sort orders.
  • Migration management: Apply reversible migrations, test changes against production-like data, and use concurrency-safe index changes (e.g., PostgreSQL CREATE INDEX CONCURRENTLY).
  • Cross-store data practices: Apply SQL and NoSQL considerations, including Redis caching patterns (TTL, invalidation, rate limiting, session storage).

Quick Start

Ask the AI: "Design a PostgreSQL schema for users and orders, propose the right indexes for my main queries, and generate a reversible migration plan to add soft-delete with deleted_at."

Frequently Asked Questions about databases

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

FAQPage Schema
How do I optimize slow PostgreSQL queries using EXPLAIN ANALYZE?▼

To fix N+1 query patterns, analyze your ORM's execution plan using EXPLAIN ANALYZE, implement eager loading, and apply proper indexing strategies on foreign keys to batch fetch related records instead of querying them individually.

What is the safest way to create indexes concurrently in PostgreSQL migrations?▼

Safe PostgreSQL migrations require reversible changes, testing against production-like data, and using concurrency-safe index creation like CREATE INDEX CONCURRENTLY to avoid locking tables and maintain availability during schema evolution.

How do I design a database schema with the right normalization and denormalization strategy?▼

Database schema design involves choosing appropriate key strategies, normalization levels, and column types, including when to denormalize based on query performance evidence rather than premature optimization.

When should I use Redis caching patterns like TTL and invalidation for my database?▼

Redis caching is ideal for reducing database load on read-heavy workloads, using TTL for automatic expiration and invalidation strategies to maintain consistency for session storage and rate limiting.

Does this database Skill support both SQL and NoSQL systems like MongoDB and Redis?▼

Yes, this Skill handles cross-store data practices for SQL databases like PostgreSQL, MySQL, and SQLite, as well as NoSQL systems like MongoDB and Redis, covering schema evolution, indexing, and caching patterns.

Related Skills

Explore More Software Engineering Skills→
CJ-1981CJ-1981

moai-domain-database

Design and optimize PostgreSQL, MongoDB, Redis, and Oracle database schemas and queries.

Community
Advanced
ricardorochericardoroche
2

database-migrations

Automate Alembic database migrations with reversible upgrade and downgrade scripts.

Community
Intermediate
allthriveaiallthriveai

database-query-optimizer

Optimize Django ORM queries for PostgreSQL to resolve slow API responses.

Official
Advanced
rajyeole6rajyeole6

agency-database-optimizer

Analyze EXPLAIN ANALYZE plans and optimize PostgreSQL indexing strategies.

Community
Advanced