Databases Agent Skills

When to activate: Elasticsearch, ES, OpenSearch, full-text search, mappings, analyzers, aggregations, Kibana

When to activate: JPA, Hibernate, entity, relationship, JPQL, Criteria API, N+1 problem, caching, transaction, fetch type, lazy loading

When to activate: MongoDB, mongoose, aggregation pipeline, mongo, NoSQL, document database, Atlas

Self-hosted semantic memory for AI agents via MCP.

Use when a change affects persisted data, schemas, storage formats, metadata, checkpoints, indexes, config formats, irreversible…

Provision instant temporary Postgres databases via Claimable Postgres by Neon (neon.new) with no login, signup, or credit card.

Use when building a NestJS application with Prisma — covers PrismaService setup as an injectable singleton, repository pattern…

Use when working on a Next.js App Router project that uses Prisma as the ORM — covers server component data fetching, singleton client…

Query PXW_Xref.Data in InterSystems IRIS to find which ObjectScript classes, methods, and properties use or reference another class member.

How dualdb validates that converted code still builds, and how it reports what was actually validated.

Build applications and features on the OpenSaaS Stack.

Workflow for optimizing ClickHouse and HogQL queries.

Build data ingestion pipelines for batch and streaming data from multiple sources.

Designs ETL/ELT data pipelines with proper extraction, transformation, and loading patterns, including orchestration, error handling, and…

Manage database schema changes safely with migration tools, zero-downtime strategies, and rollback procedures.

Designs and builds knowledge graphs to represent entities, relationships, and semantic connections, with query patterns for Neo4j, RDF…

Advanced PostgreSQL patterns for performance optimization, complex queries, indexing strategies, and database design

Use Redis effectively for caching, pub/sub messaging, rate limiting, distributed locks, and session storage.

Analyzes complex SQL queries to improve performance, suggesting indexing strategies, schema refactoring, and query rewrites.

Keep apps and templates loading fast. Read when adding a data model, a list/read action, a page or sidebar that loads data, or when…

Governs the on-device Drift/SQLite data layer: package:drift and package:sqlite3 confined to lib/data/ behind DAOs that map rows to…