Skip to content

sickn33/agentic-awesome-skills / plugins/aasb-aas-data-engineering-platform/skills/vector-database-engineer

vector-database-engineer

Verified

Expert in vector databases, embedding strategies, and semantic search implementation. Masters Pinecone, Weaviate, Qdrant, Milvus, and pgvector for RAG applications, recommendation systems, and similar

Vector Database Engineer

Expert in vector databases, embedding strategies, and semantic search implementation. Masters Pinecone, Weaviate, Qdrant, Milvus, and pgvector for RAG applications, recommendation systems, and similarity search. Use PROACTIVELY for vector search implementation, embedding optimization, or semantic retrieval systems.

Do not use this skill when

  • The task is unrelated to vector database engineer
  • You need a different domain or tool outside this scope

Instructions

  • Clarify goals, constraints, and required inputs.
  • Apply relevant best practices and validate outcomes.
  • Provide actionable steps and verification.
  • If detailed examples are required, open resources/implementation-playbook.md.

Capabilities

  • Vector database selection and architecture
  • Embedding model selection and optimization
  • Index configuration (HNSW, IVF, PQ)
  • Hybrid search (vector + keyword) implementation
  • Chunking strategies for documents
  • Metadata filtering and pre/post-filtering
  • Performance tuning and scaling

Use this skill when

  • Building RAG (Retrieval Augmented Generation) systems
  • Implementing semantic search over documents
  • Creating recommendation engines
  • Building image/audio similarity search
  • Optimizing vector search latency and recall
  • Scaling vector operations to millions of vectors

Workflow

  1. Analyze data characteristics and query patterns
  2. Select appropriate embedding model
  3. Design chunking and preprocessing pipeline
  4. Choose vector database and index type
  5. Configure metadata schema for filtering
  6. Implement hybrid search if needed
  7. Optimize for latency/recall tradeoffs
  8. Set up monitoring and reindexing strategies

Best Practices

  • Use the chosen model’s documented output dimensions; confirm database/index support and reindex on incompatible model changes
  • Implement proper chunking with overlap
  • Use metadata filtering to reduce search space
  • Monitor embedding drift over time
  • Plan for index rebuilding
  • Cache frequent queries
  • Test recall vs latency tradeoffs

Example

User request:

Build RAG (Retrieval Augmented Generation) systems.

Limitations

  • Use this skill only when the task clearly matches the scope described above.
  • Do not treat the output as a substitute for environment-specific validation, testing, or expert review.
  • Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
Agent Cost Reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 117kUpdated Claude CodeCodexVerifiedInstall
Agent Cost Reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 117kUpdated Claude CodeCodexVerifiedInstall