Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.
Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques.
Use when the user needs to filter data — whether in a structured query, a metric aggregation, or an attribute expression.
Guides Qdrant search strategy selection.
Use this skill to implement hybrid search combining BM25 keyword search with semantic vector search using Reciprocal Rank Fusion (RRF)…
PostgreSQL schema design, query optimization, indexing, and administration.
Database schema patterns for InsForge including social graphs, e-commerce, content publishing, and multi-tenancy with RLS policies.
Use when targeting International Conference on Very Large Data Bases (VLDB) or deciding whether a computer-science manuscript fits this…
This skill uses the database-index-advisor plugin to analyze query patterns and recommend optimal database indexes.
This skill leverages the database-diff-tool plugin to compare database schemas, generate migration scripts, and provide rollback procedures.
This skill enables Claude to design and visualize database schemas.
This skill enables Claude to automatically generate comprehensive documentation for existing database schemas using the…
Use when performing database schema changes, data migrations, large table modifications, or when zero-downtime deployment is required…
Execute major Palantir Foundry migration strategies including data migration,
JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in…
Database schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases.
Expert knowledge of Kafka CLI tools (kcat, kcli, kaf, kafkactl).
MCP server integration for Kafka operations.
Review Kafka schema changes (Avro, Protobuf, JSON Schema) for compatibility and evolution best practices using the Lenses MCP server.
Pathfinder traversal of the knowledge graph starting from a seed entity
Use when implementing semantic/vector search in Laravel 13 with PostgreSQL + pgvector.