Databases

Database, auth, and backend expertise for Supabase operations in [PROJECT_NAME]

Cache management, configuration best practices, and progressive disclosure patterns for efficient context window usage. Use when working with large responses, optimizing token costs, or managing plugin state across operations.

Consults GPT-5.2 with high reasoning for deep analysis. Triggers: "ask the oracle", "consult oracle", "get a second opinion", "ask GPT", "check with GPT", "what would GPT think", "cross-check my reasoning", "external AI". Use for complex debugging, architectural decisions, security audits, or code review requiring deep reasoning. Not for routine tasks.

Use sgrep for semantic code search. Use when you need to find code by meaning rather than exact text matching. Perfect for finding concepts like "authentication logic", "error handling patterns", or "database connection pooling".

Accessibility-first UI automation using IDB. Query accessibility tree (fast, 50 tokens) before screenshots (slow, 170 tokens). Use when automating simulator interactions, tapping UI elements, finding buttons, or testing user flows. Covers idb-ui-describe, idb-ui-tap, idb-ui-find-element patterns.

Use sgrep for semantic code search. Use when you need to find code by meaning rather than exact text matching. Perfect for finding concepts like "authentication logic", "error handling patterns", or "database connection pooling".

Student database processing tools. Includes grade calculation, duplicate name detection, recommendation letter filtering, and TOEFL score filtering.

Optimize Doctrine queries with fetch modes, lazy loading, extra lazy collections, and query hints for performance

Async message handling with Symfony Messenger; configure transports (RabbitMQ, Redis, Doctrine); implement handlers, middleware, and retry strategies

Implement caching with Symfony Cache component; configure pools, use cache tags for invalidation, and optimize performance

Query and analyze Claude Code history joined with Git data using SQL. Use when user asks about their Claude conversations, productivity patterns, commit history correlation, session analytics, or wants to explore their coding history with SQL queries.

Use when working with Nuxt Content v3 - provides collections (local/remote/API sources), queryCollection API, MDC rendering, database configuration, NuxtStudio integration, hooks, i18n patterns, and LLMs integration

Handle database transactions with Doctrine UnitOfWork; implement optimistic locking, flush strategies, and transaction boundaries

Create API Platform resources using pure DTOs without Doctrine entities, enabling clean API design decoupled from database schema

Use when building NuxtHub v0.10 applications - provides database (Drizzle ORM with sqlite/postgresql/mysql), KV storage, blob storage, and cache APIs. Covers configuration, schema definition, migrations, multi-cloud deployment (Cloudflare, Vercel), and the new hub:db, hub:kv, hub:blob virtual module imports.

Implement CQRS pattern in Symfony with separate Command and Query handlers using Messenger component

Use when investigating or improving WordPress performance (backend-only agent): profiling and measurement (WP-CLI profile/doctor, Server-Timing, Query Monitor via REST headers), database/query optimization, autoloaded options, object caching, cron, HTTP API calls, and safe verification.

Use when working with WP-CLI (wp) for WordPress operations: safe search-replace, db export/import, plugin/theme/user/content management, cron, cache flushing, multisite, and scripting/automation with wp-cli.yml.

Implement API versioning strategies in API Platform including URI, header, and query parameter approaches

Implement query caching strategies to improve performance. Use when setting up caching layers, configuring Redis, or optimizing database query response times.