understanding-database-internals

Description

Comprehensive database internals reference covering storage engines (B-trees, LSM-trees, file formats, transactions, recovery) and distributed systems (failure detection, leader election, replication, consistency models, consensus algorithms). Use when designing database-backed systems, choosing storage engines, understanding consistency guarantees, or debugging distributed system behavior. For SQL-level antipatterns and query optimization, use avoiding-sql-antipatterns instead. For relational database design process (entity modeling, ER diagrams, normalization), use designing-relational-databases instead. For data architecture patterns (CQRS, event sourcing, caching strategies), use architecting-data instead. For GCP-specific data services (BigQuery, Dataflow, Dataproc), use developing-google-cloud instead.

AI Summary

Provides comprehensive reference material on database storage engines and distributed systems internals for system design and debugging.

Install

Run in your terminal

npx claudepluginhub sumik5/sumik-claude-plugin

Tool Access

This skill inherits all available tools. When active, it can use any tool Claude has access to.

Supporting Assets

View in Repository

INSTRUCTIONS.md

references/ANTI-ENTROPY-GOSSIP.md

references/BTREE-FUNDAMENTALS.md

references/BTREE-IMPLEMENTATION.md

references/BTREE-VARIANTS.md

references/CONSENSUS-ALGORITHMS.md

references/DBMS-ARCHITECTURE.md

references/DISTRIBUTED-FUNDAMENTALS.md

references/DISTRIBUTED-TRANSACTIONS.md

references/FAILURE-DETECTION-LEADER-ELECTION.md

references/LOG-STRUCTURED-STORAGE.md

references/MODELS.md

references/NOSQL-MODELS.md

references/REPLICATION-CONSISTENCY.md

references/STORAGE-AND-PROCESSING.md

references/TRANSACTIONS-RECOVERY.md

Skill Content

詳細な手順・ガイドラインは INSTRUCTIONS.md を参照してください。

Links

GitHub Stats

0 forks

Updated 15 days ago

Actions

Similar Skills

cache-components

Expert guidance for Next.js Cache Components and Partial Prerendering (PPR). **PROACTIVE ACTIVATION**: Use this skill automatically when working in Next.js projects that have `cacheComponents: true` in their next.config.ts/next.config.js. When this config is detected, proactively apply Cache Components patterns and best practices to all React Server Component implementations. **DETECTION**: At the start of a session in a Next.js project, check for `cacheComponents: true` in next.config. If enabled, this skill's patterns should guide all component authoring, data fetching, and caching decisions. **USE CASES**: Implementing 'use cache' directive, configuring cache lifetimes with cacheLife(), tagging cached data with cacheTag(), invalidating caches with updateTag()/revalidateTag(), optimizing static vs dynamic content boundaries, debugging cache issues, and reviewing Cache Component implementations.

cache-components

138.2k

algorithmic-art

3 files

Creating algorithmic art using p5.js with seeded randomness and interactive parameter exploration. Use this when users request creating art using code, generative art, algorithmic art, flow fields, or particle systems. Create original algorithmic art rather than copying existing artists' work to avoid copyright violations.

anthropic-skills

87.2k

brand-guidelines

1 file

Applies Anthropic's official brand colors and typography to any sort of artifact that may benefit from having Anthropic's look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply.

anthropic-skills

87.2k