Stats
Actions
Tags
From lang
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.
How this skill is triggered — by the user, by Claude, or both
Slash command
/lang:developing-databasesWhen to use
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. For app-layer ORM workflows (Drizzle in Express), use developing-fullstack-javascript.
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
詳細な手順・ガイドラインは `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.md詳細な手順・ガイドラインは INSTRUCTIONS.md を参照してください。
Searches MemPalace before answering questions about past work, people, projects, or prior decisions. Returns verbatim stored content instead of guessing from model memory.
Guides Payload CMS config (payload.config.ts), collections, fields, hooks, access control, APIs. Debugs validation errors, security, relationships, queries, transactions, hook behavior.
Implements vector databases with Pinecone, Weaviate, Qdrant, Milvus, pgvector for semantic search, RAG, recommendations, and similarity systems. Optimizes embeddings, indexing, and hybrid search.
npx claudepluginhub sumik5/sumik-llm-plugin --plugin lang