Databases

445 skills.

Browse

qdrant-version-upgradeqdrant1.3KCovers upgrading Qdrant server and SDKs without interrupting availability or losing data integrity. Use when someone asks 'how do I upgrade Qdrant', 'can I jump from 1.15 to 1.18', 'rolling upgrade without downtime', 'do I upgrade the client or the server first', 'which SDK version matches my server', 'what should I check before upgrading', or 'something changed after we upgraded'.planetscale-traffic-control-recommendationsplanetscale1.3KBuild a safe recommendation plan for PlanetScale Postgres Database Traffic Control budgets and rules without applying them.planetscale-webhook-automation-recommendationsplanetscale1.3KRecommend webhook subscriptions and safe automation patterns for PlanetScale alerts, anomalies, schema recommendations, deploy requests, and agent workflows.planetscale-vitess-safety-reviewplanetscale1.3KReview a PlanetScale Vitess database for safe migrations, deploy requests, schema recommendations, Insights, webhooks, and operational safety.kotlin-backend-jpa-entity-mappingkotlin1.3KModel Kotlin persistence code correctly for Spring Data JPA and Hibernate. Covers entity design, identity and equality, uniqueness constraints, relationships, fetch plans, and common ORM (Object-Relational Mapping) traps specific to Kotlin. Use when creating or reviewing JPA (Java Persistence API) entities, diagnosing N+1 or LazyInitializationException, placing indexes and uniqueness rules, or preventing Kotlin-specific bugs such as data class entities and broken equals/hashCode.neo4j-cypher-skillneo4j-contrib1.3KGenerates, optimizes, and validates Cypher 25 queries for Neo4j 2025.x and 2026.x. Use when writing new Cypher queries, optimizing slow queries, graph pattern matching, vector or fulltext search, subqueries, or batch writes. Covers MATCH, MERGE, CREATE, WITH, RETURN, CALL, UNWIND, FOREACH, LOAD CSV, SEARCH, expressions, functions, indexes, and subqueries. Does NOT handle driver migration or API changes — use neo4j-migration-skill. Does NOT cover DB administration or server ops — use neo4j-cli-to debuggingtursodatabase1.3KHow to debug tursodb using Bytecode comparison, logging, ThreadSanitizer, deterministic simulation, and corruption analysis tools redis-searchredis1.3KRedis Search guidance covering FT.CREATE schema design, field type selection (TEXT, TAG, NUMERIC, GEO, GEOSHAPE, VECTOR, JSON path), DIALECT 2 query syntax, FT.SEARCH / FT.AGGREGATE / FT.HYBRID command selection, vector similarity with HNSW or FLAT, hybrid retrieval combining lexical and vector ranking, RAG pipelines, zero-downtime index updates via aliases, and debugging with FT.PROFILE and FT.EXPLAIN. Use when defining a search index on Hash or JSON documents, writing FT.SEARCH queries with fi query-writinglangchain-ai1.3KWrites and executes SQL queries from simple SELECTs to complex multi-table JOINs, aggregations, and subqueries. Use when the user asks to query a database, write SQL, run a SELECT statement, retrieve data, filter records, or generate reports from database tables.schema-explorationlangchain-ai1.3KLists tables, describes columns and data types, identifies foreign key relationships, and maps entity relationships in a database. Use when the user asks about database schema, table structure, column types, what tables exist, ERD, foreign keys, or how entities relate.async-io-modeltursodatabase1.3KExplanations of common asynchronous patterns used in tursodb. Involves IOResult, state machines, re-entrancy pitfalls, CompletionGroup. Always use these patterns in `core` when doing anything IO eloquent-best-practicesiserter1.3KBest practices for Laravel Eloquent ORM including query optimization, relationship management, and avoiding common pitfalls like N+1 queries.storage-formattursodatabase1.3KSQLite file format, B-trees, pages, cells, overflow, freelist that is used in tursodb drizzle-migrationsbobmatnyc1.2KMigration-first database development workflow using Drizzle ORM for TypeScript/J...queryduckdb1.2KRun SQL queries against the attached DuckDB database or ad-hoc against files. Accepts raw SQL or natural language questions. Uses DuckDB Friendly SQL idioms.postgrestimescale1.2KUse this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations. **Trigger when user asks to:** - Explore an existing PostgreSQL database to understand its objects and relationships - Design or modify PostgreSQL tables, schemas, or data models - Choose data types, constraints, indexes, or partitioning strategies - Work with pgvector embeddings, semantic search, or RAG - Set up full-text search,transaction-correctnesstursodatabase1.2KHow WAL mechanics, checkpointing, concurrency rules, recovery work in tursodb database-performanceaarononthewebDatabase access patterns for performance. Separate read/write models, avoid N+1 queries, use AsNoTracking, apply row limits, and never do application-side joins. Works with EF Core and Dapper.clickhouse-ioaffaan-mClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.content-hash-cache-patternaffaan-mCache expensive file processing results using SHA-256 content hashes — path-independent, auto-invalidating, with service layer separation.data-throughput-acceleratoraffaan-mDiagnose and accelerate large data movement — ingestion, backfill, export, ETL, warehouse loading, manifest catch-up, and table synchronization — by isolating the true bottleneck, benchmarking variants, and codifying the fastest path with a hard accounting block proving rows and timestamps cohere. Use when a pipeline or backfill is too slow and must get faster without losing data correctness.database-migrationsaffaan-mDatabase migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate). Use when planning or implementing database schema changes.hermes-importsaffaan-mHermesデータインポート、マッピング、変換、およびデータインテグリティ検証。jpa-patternsaffaan-mJPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.kotlin-exposed-patternsaffaan-mJetBrains Exposed ORM パターン（DSL クエリ、DAO パターン、トランザクション、HikariCP 接続プーリング、Flyway マイグレーション、リポジトリパターンを含む）。mysql-patternsaffaan-m日本語翻訳：このファイルは mysql-patterns 用の日本語翻訳が必要です postgres-patternsaffaan-mPostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, index types, data types, and anti-pattern detection. Based on Supabase best practices.prisma-patternsaffaan-mPrisma ORM patterns for TypeScript backends — schema design, query optimization, transactions, pagination, and critical traps like updateMany returning count not records, $transaction timeouts, migrate dev resetting the DB, @updatedAt skipped on bulk writes, and serverless connection exhaustion. Use when writing a Prisma schema or query, or debugging transactions, migrations, or serverless connection limits.redis-patternsaffaan-mRedisデータ構造パターン、キャッシング戦略、分散ロック、レート制限、Pub/Sub、本番アプリケーション用コネクション管理。aws-rds-databaseaj-geddesDeploy and manage relational databases using RDS with Multi-AZ, read replicas, backups, and encryption. Use for PostgreSQL, MySQL, MariaDB, and Oracle.caching-strategyaj-geddesImplement efficient caching strategies using Redis, Memcached, CDN, and cache invalidation patterns. Use when optimizing application performance, reducing database load, or improving response times.data-migration-scriptsaj-geddesCreate safe, reversible database migration scripts with rollback capabilities, data validation, and zero-downtime deployments. Use when changing database schemas, migrating data between systems, or performing large-scale data transformations.data-replication-setupaj-geddesSet up database replication for high availability and disaster recovery. Use when configuring master-slave replication, multi-master setups, or replication monitoring.database-backup-restoreaj-geddesImplement backup and restore strategies for disaster recovery. Use when creating backup plans, testing restore procedures, or setting up automated backups.database-indexing-strategyaj-geddesDesign and implement database indexing strategies. Use when creating indexes, choosing index types, or optimizing index performance in PostgreSQL and MySQL.database-migration-managementaj-geddesManage database migrations and schema versioning. Use when planning migrations, version control, rollback strategies, or data transformations in PostgreSQL and MySQL.database-monitoringaj-geddesMonitor database performance and health. Use when setting up monitoring, analyzing metrics, or troubleshooting database issues.database-performance-debuggingaj-geddesDebug database performance issues through query analysis, index optimization, and execution plan review. Identify and fix slow queries.database-query-optimizationaj-geddesImprove database query performance through indexing, query optimization, and execution plan analysis. Reduce response times and database load.database-schema-designaj-geddesDesign database schemas with normalization, relationships, and constraints. Use when creating new database schemas, designing tables, or planning data models for PostgreSQL and MySQL.database-shardingaj-geddesImplement database sharding for horizontal scalability. Use when scaling large databases, distributing data across multiple servers, or designing sharded architectures.nosql-database-designaj-geddesDesign NoSQL database schemas for MongoDB and DynamoDB. Use when modeling document structures, designing collections, or planning NoSQL data architectures.query-caching-strategiesaj-geddesImplement query caching strategies to improve performance. Use when setting up caching layers, configuring Redis, or optimizing database query response times.sql-query-optimizationaj-geddesAnalyze and optimize SQL queries for performance. Use when improving slow queries, reducing execution time, or analyzing query performance in PostgreSQL and MySQL.stored-proceduresaj-geddesImplement stored procedures and functions for database logic. Use when creating reusable database routines, complex queries, or server-side calculations.transaction-managementaj-geddesManage database transactions for data consistency. Use when implementing ACID compliance, handling concurrency, or managing transaction isolation levels.feishu-bitablealextangson飞书多维表格操作。记录 CRUD、字段管理、视图、权限、公式、关联。aws-dynamodbalinaqiAWS DynamoDB single-table design, GSI patterns, SDK v3 TypeScript/Python supabasealinaqiCore Supabase CLI, migrations, RLS, Edge Functions dingtalk-ai-tablealiramw钉钉 AI 表格（多维表）操作技能。使用 mcporter CLI 连接钉钉官方新版 AI 表格 MCP server，基于 baseId / tableId / fieldId / recordId 体系执行 Base、Table、Field、Record 的查询与增删改。适用于创建 AI 表格、搜索表格、读取表结构、批量增删改记录、批量建字段、更新字段配置、按模板建表等场景。需要配置 DINGTALK_MCP_URL 或直接使用 Streamable HTTP URL。