إعلان[ For iPhone / iPad ] 🔥 خلفيات تفاعلية مذهلة من Nugget. لم ترَ شيئًا كهذا من قبل!

skills.homescapability registry البحث

home/categories/databases

domain cluster

Databases

SQL, NoSQL, and database management tools.

3963 مهارةall categories

sorting

stars

current ordering strategy

query

all entries

refine the visible subset

sql-databases

4

query-optimization

データベースクエリ最適化を専門とするスキル。N+1問題の回避、フェッチ戦略の選択、実行計画分析、インデックス活用を通じてパフォーマンスを向上させます。 Anchors: • High Performance MySQL (Baron Schwartz) / 適用: クエリ最適化原則 / 目的: パフォーマンス向上の体系的アプローチ • SQL Performance Explained (Markus Winand) / 適用: インデックス設計とアクセスパターン / 目的: 実行計画の最適化 • High-Performance Java Persistence (Vlad Mihalcea) / 適用: ORM最適化とN+1問題解決 / 目的: アプリケーションレベルの最適化 Trigger: Use when optimizing query performance, analyzing execution plans, resolving N+1 problems, designing fetch strategies, improving database performance, or tuning ORM queries. Keywords: query optimization, N+1 problem, execution plan, index design, fetch strategy, database performance, ORM optimization

daishiman

databases

sql-databases

4

vendix-prisma

Prisma ORM patterns for Vendix database operations. Trigger: When editing schema.prisma, creating migrations, or using Prisma client.

Rzyfront

databases

sql-databases

4

connection-pooling

データベース接続プール設計と運用を支援するスキル。サーバーレス環境やTursoの接続制約を踏まえたサイジングと検証手順を整理する。 Anchors: • 『The Pragmatic Programmer』（Andrew Hunt, David Thomas）/ 適用: 実践的改善 / 目的: 接続管理の品質維持 Trigger: Use when designing connection pools, sizing database connections, or troubleshooting serverless connection limits. connection pooling, database connections, pool sizing, serverless connections, Turso

daishiman

databases

sql-databases

4

vendix-prisma-schema

Prisma schema editing.

Rzyfront

databases

sql-databases

4

agentuity-cli-project-auth-generate

Generate SQL schema for Agentuity Auth tables. Use for managing authentication credentials

agentuity

databases

sql-databases

4

debugging-orm-queries

Converts ORM calls to raw SQL and analyzes query performance. Detects N+1 queries, missing indexes, and other anti-patterns. Use when debugging slow queries, tracing ORM-generated SQL, or optimizing database performance for Sequelize, Prisma, TypeORM (Node.js), GORM, sqlc, sqlx, ent (Go), or SQLAlchemy, Django ORM, Peewee (Python).

galihcitta

databases

sql-databases

4

orm-best-practices

ORMベストプラクティスの専門スキル。Drizzle ORMを活用したエンティティ設計、リレーション管理、パフォーマンス最適化を提供します。 Anchors: • Designing Data-Intensive Applications (Martin Kleppmann) / 適用: データモデリング / 目的: 型安全なスキーマ定義とパフォーマンス最適化 • Drizzle ORM Documentation / 適用: TypeScript ORM / 目的: 型推論とクエリビルダーの活用 • High Performance MySQL (Baron Schwartz) / 適用: クエリ最適化 / 目的: N+1問題とインデックス戦略 Trigger: Use when defining Drizzle ORM schemas, mapping entity relationships, optimizing database queries, solving N+1 problems, or implementing type-safe data access patterns. ORM, Drizzle, schema, relation, N+1, query builder, type-safe, entity mapping

daishiman

databases

sql-databases

4

sql-anti-patterns

SQLアンチパターンの検出・分析・改善提案を支援するスキル。スキーマ設計レビュー、クエリ実装レビュー、パフォーマンス問題の診断と改善を行う。 Anchors: • SQL Antipatterns (Bill Karwin) / 適用: アンチパターンカタログ / 目的: 設計問題の体系的検出 • Database Design for Mere Mortals / 適用: 正規化とスキーマ設計 / 目的: 適切なデータモデリング • Use The Index, Luke / 適用: インデックス最適化 / 目的: クエリパフォーマンス改善 Trigger: Use when reviewing database schema, detecting SQL anti-patterns, diagnosing performance issues, or planning schema refactoring. sql anti-pattern, schema review, N+1, EAV, polymorphic associations, jaywalking, database design, query optimization

daishiman

databases

sql-databases

4

repository

Go repository implementation with SQLC integration following hexagonal architecture. Use when implementing data persistence layer, creating repository interfaces, or working with SQLC-generated queries. Focuses on domain model conversion, transaction handling, and error patterns.

nikolayk812

databases

sql-databases

4

sql-params-generate

Generate parameter bindings for SQL files by analyzing database schema and extracting SQL placeholders. Queries the live database for table structures, matches placeholders to column types, and generates appropriate test values based on column patterns (IDs, dates, status enums, etc).

koriym

databases

sql-databases

4

transaction-management

データベーストランザクション管理の専門スキル。 ACID特性、分離レベル、デッドロック回避を提供します。 Anchors: • 『Designing Data-Intensive Applications』（Martin Kleppmann）/ 適用: トランザクション設計 / 目的: データ整合性 Trigger: トランザクション管理、ACID特性実装、データ整合性保証設計、トランザクション分離レベル決定、ロック戦略検討、ロールバック処理実装時に使用

daishiman

databases

sql-databases

4

query-performance-tuning

SQLiteクエリパフォーマンス最適化を専門とするスキル。EXPLAIN QUERY PLAN分析、インデックス戦略、クエリリライトを通じて、遅いクエリを診断し実行計画を改善します。 Anchors: • High Performance MySQL (Baron Schwartz) / 適用: クエリ分析と診断手法 / 目的: 体系的なパフォーマンス診断 • Use The Index, Luke (Markus Winand) / 適用: インデックス設計原則 / 目的: 効果的なインデックス活用 • Systems Performance (Brendan Gregg) / 適用: 測定駆動のアプローチ / 目的: 定量的な効果検証 Trigger: Use when optimizing slow queries, analyzing execution plans, designing indexes, resolving N+1 problems, or improving database performance systematically. Keywords: slow query, EXPLAIN QUERY PLAN, index optimization, query rewriting, N+1 problem, database performance, SQLite performance

daishiman

databases

sql-databases

4

drizzle-orm

DrizzleORMを使用したデータベーススキーマ設計、マイグレーション、型安全なクエリ構築を専門とするスキル。 SQLite、PostgreSQL、MySQLに対応し、TypeScriptの型システムを最大限活用した堅牢なDB層を構築する。 Anchors: • Drizzle ORM公式ドキュメント / 適用: スキーマ定義とマイグレーション / 目的: 型安全なDB設計の基盤 • TypeScript型システム / 適用: クエリビルダーとスキーマ定義 / 目的: エンドツーエンドの型安全性 • Database Design for Mere Mortals (Hernandez) / 適用: リレーション設計 / 目的: 正規化と参照整合性 Trigger: Use when defining Drizzle schemas, creating migrations, building type-safe queries, designing relations, or optimizing database performance. drizzle, orm, schema, migration, sqlite, postgresql, type-safe query

daishiman

databases

sql-databases

4

database-patterns

This skill should be used for database schema design, indexes, query optimization, migrations, SQL, PostgreSQL, MySQL, ORM patterns, data modeling, database relationships

Zate

databases

nosql-databases

4

database-design

Use when designing database schemas, reviewing data models, planning migrations, optimizing slow queries, or establishing database patterns. Covers relational (PostgreSQL, MySQL, SQLite), document (MongoDB), and ORM-integrated (Prisma, Drizzle, TypeORM) projects.

srstomp

databases

nosql-databases

4

vector-db-ingest

Ingests repository files into the ChromaDB vector store. Builds or updates the vector index from a manifest or directory scan using ingest.py. Use when new files need to be indexed or the vector store is out of date. <example> user: "Index these new plugin files into the vector database" assistant: "I'll use vector-db-ingest to add them to the vector store." </example> <example> user: "The vector store is missing recent files -- update it" assistant: "I'll use vector-db-ingest to re-index the changes." </example>

richfrem

databases

nosql-databases

4

vercel-kv

Integrate Redis-compatible Vercel KV for caching, session management, and rate limiting in Next.js. Powered by Upstash with strong consistency and TTL support. Use when implementing cache strategies, rate limiters, or troubleshooting environment variables, serialization errors, rate limit issues, scanIterator hangs, or Next.js cache stale reads.

dennislee928

databases

nosql-databases

4

cloudflare-kv

Store key-value data globally with Cloudflare KV's edge network. Use when: caching API responses, storing configuration, managing user preferences, handling TTL expiration, or troubleshooting KV_ERROR, 429 rate limits, eventual consistency, cacheTtl errors, wrangler types issues, or remote binding configuration.

dennislee928

databases

nosql-databases

4

vercel-kv

Integrate Redis-compatible Vercel KV for caching, session management, and rate limiting in Next.js. Powered by Upstash with strong consistency and TTL support. Use when implementing cache strategies, rate limiters, or troubleshooting environment variables, serialization errors, rate limit issues, scanIterator hangs, or Next.js cache stale reads.

dennislee928

databases

nosql-databases

4

firebase-firestore

Build with Firestore NoSQL database - real-time sync, offline support, and scalable document storage. Use when: creating collections, querying documents, setting up security rules, handling real-time listeners, or troubleshooting permission-denied, quota exceeded, invalid query, or offline persistence errors. Prevents 10 documented errors.

dennislee928

databases

nosql-databases

4

cloudflare-kv

Store key-value data globally with Cloudflare KV's edge network. Use when: caching API responses, storing configuration, managing user preferences, handling TTL expiration, or troubleshooting KV_ERROR, 429 rate limits, eventual consistency, cacheTtl errors, wrangler types issues, or remote binding configuration.

dennislee928

databases

nosql-databases

4

redis-state-management

Comprehensive guide for Redis state management including caching strategies, session management, pub/sub patterns, distributed locks, and data structures

DebVisor

databases

nosql-databases

4

caching

Expert guidance for Rails caching — fragment caching, Russian doll caching, cache keys/versioning, low-level caching (Rails.cache), conditional GET (stale?/fresh_when), and cache stores (Solid Cache, Redis, Memcached). Use when implementing cache, caching, fragment cache, Russian doll, Rails.cache, Solid Cache, cache key, HTTP caching, stale?, fresh_when, cache store, or optimizing performance.

ThinkOodle

databases

nosql-databases

4

tables

Nim's hash table module for key-value storage

mratsim

databases

Page 116 / 166