From sumik
Comprehensive database development guide covering relational design (ER modeling, normalization, PostgreSQL implementation), SQL antipatterns (25 patterns with detection signals and solutions), database internals (storage engines B-tree/LSM, distributed systems, consensus algorithms), and PostgreSQL operations (server config, extensions, query tuning, MVCC/VACUUM, backup/PITR, replication/HA, monitoring). Use when designing database schemas, writing SQL queries, reviewing data models, choosing storage engines, tuning PostgreSQL performance, managing backup/replication, or debugging distributed system behavior. Replaces: designing-relational-databases, avoiding-sql-antipatterns, understanding-database-internals. For data architecture patterns (CQRS, event sourcing), use architecting-data instead. For GCP managed databases (Cloud SQL, Spanner, Firestore, Bigtable) and BigQuery analytics, use developing-google-cloud instead.
npx claudepluginhub sumik5/sumik-claude-plugin --plugin sumikThis skill uses the workspace's default tool permissions.
詳細な手順・ガイドラインは `INSTRUCTIONS.md` を参照してください。
INSTRUCTIONS.mdreferences/ANTIPATTERN-APPLICATION-DEV.mdreferences/ANTIPATTERN-FOREIGN-KEYS.mdreferences/ANTIPATTERN-LOGICAL-DESIGN.mdreferences/ANTIPATTERN-NORMALIZATION.mdreferences/ANTIPATTERN-PHYSICAL-DESIGN.mdreferences/ANTIPATTERN-QUERY-PATTERNS.mdreferences/DESIGN-ENTITIES-AND-KEYS.mdreferences/DESIGN-NORMALIZATION.mdreferences/DESIGN-POSTGRESQL-ARCHITECTURE.mdreferences/DESIGN-POSTGRESQL-FUNCTIONS.mdreferences/DESIGN-POSTGRESQL-SECURITY.mdreferences/DESIGN-POSTGRESQL-TRANSACTIONS.mdreferences/DESIGN-RELATIONSHIPS.mdreferences/DESIGN-SECURITY-OPTIMIZATION.mdreferences/INTERNALS-ANTI-ENTROPY-GOSSIP.mdreferences/INTERNALS-BTREE-FUNDAMENTALS.mdreferences/INTERNALS-BTREE-IMPLEMENTATION.mdreferences/INTERNALS-BTREE-VARIANTS.mdreferences/INTERNALS-CONSENSUS-ALGORITHMS.mdGuides Next.js Cache Components and Partial Prerendering (PPR) with cacheComponents enabled. Implements 'use cache', cacheLife(), cacheTag(), revalidateTag(), static/dynamic optimization, and cache debugging.
Guides building MCP servers enabling LLMs to interact with external services via tools. Covers best practices, TypeScript/Node (MCP SDK), Python (FastMCP).
Generates original PNG/PDF visual art via design philosophy manifestos for posters, graphics, and static designs on user request.
詳細な手順・ガイドラインは INSTRUCTIONS.md を参照してください。