Databases Agent Skills

Navigation hub linking sub-skills for proactive Qdrant tuning: search speed, indexing performance, and memory usage optimization.

Covers upgrading Qdrant server and SDKs without interrupting availability or losing data integrity.

Analyzes PHP code for query efficiency issues.

Checks redundant fetches, N+1 loops, over-fetching, missing bulk operations, wrong caching scope.

Write, execute, or optimize analytical DuckDB SQL against MotherDuck data.

Prevents N+1 queries, inefficient batch processing, and memory-intensive recursion in database and service calls.

Use this agent when a PR touches production data, migrations, or behavior that could silently discard or duplicate records.

Redis client and connection guidance covering connection pooling, multiplexing, pipelining, client-side caching with RESP3, avoiding slow…

Redis backend for conversation state persistence and caching

Enforces safe Redis operation patterns and performance best practices across multiple programming languages to prevent production outages.

Redis Search guidance covering FT.CREATE schema design, field type selection (TEXT, TAG, NUMERIC, GEO, GEOSHAPE, VECTOR, JSON path)…

Design and manage reference data systems — security master, client master, account master, identifier mapping, pricing data sources…

Provisions and configures Render Key Value (Redis-compatible Valkey 8) instances for caching, session storage, and job queues.

Sets up and optimizes Managed PostgreSQL on Render—connection strings (internal vs external), creation constraints, storage autoscaling…

Replication and Sharding knowledge base.

High availability and replication topologies across all database engines.

Generates DDD Repository interfaces and implementation stubs for PHP 8.4.

Enforce roadmap data authority — Odoo is canonical write model, Plane is projection, Supabase is read-only mirror, Fabric is analytics…

Redis patterns including caching strategies, pub/sub, streams for event processing, Lua scripts, and data structures

Deep operational guide for 12 columnar/wide-column databases.

Deep operational guide for 14 data warehouse/OLAP databases.