Databases Agent Skills for Windsurf (legacy)

Required reference for Prisma ORM 7 SQL driver adapter work.

Complete migration guide from Prisma ORM v6 to v7 covering all breaking changes.

Different techniques to optimize the performance of Qdrant, including indexing strategies, query optimization, and hardware considerations.

Guides Qdrant scaling decisions. Use when someone asks 'how many nodes do I need', 'data doesn't fit on one node', 'need more throughput'…

Construct ObjectQL queries — filters, sorting, pagination, aggregation, relation expansion, and full-text search.

Optimize SQL queries for performance with indexing strategies, query rewriting, and execution plan analysis.

Prevents database performance bottlenecks and memory issues by enforcing best practices for batching, indexing, and recursive queries.

Use when active Record patterns including models, associations, queries, validations, and callbacks.

Creates Rails models using TDD approach - spec first, then migration, then model.

Generates realistic, customizable mock datasets for software testing and system demonstrations in multiple formats.

Generate realistic seed/fixture data based on schema analysis

Redis command-line interface (redis-cli) reference and usage guide.

Designs, implements, and reviews production-grade Redis architectures for caching, distributed locking, rate limiting, and session…

Enforces Redis best practices and safety standards across multiple languages to prevent performance bottlenecks and memory leaks.

Recalculates hashkeys and hashdiffs across an existing raw vault with datavault4dbt's rehashing macros after a change to the hash…

Design and review persistence boundaries and data-access abstractions in backend systems.

Expert workflow for creating, extending, and validating Reqvire structural ontology elements for IT engineering, systems engineering…

Checks session scope mismatch, missing cleanup, pool config, error path leaks, resource holding.

Agent retrieval policy for intelligent memory search.

Review application data structures, fixtures, schemas, TypeScript types, persistence models, API contracts, and UI projections.

Schema and data migration patterns across all engines.