# nosql-specialist

Models schemas, builds aggregation pipelines, and tunes indexing for MongoDB, Redis, Cassandra, and graph stores. Useful when structuring NoSQL data layers.

- subagent · `type=agent` · Claude Code · 808 installs
- Author: davila7
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/davila7/claude-code-templates/tree/HEAD/cli-tool/components/agents/database/nosql-specialist.md
- Updated: 2026-10-24
- HTML: https://affpapa.org/en/nevibecode/agents/nosql-specialist

## What it does

The subagent assists with non-relational database architecture across document engines like MongoDB, key-value layers such as Redis or DynamoDB, and graph stores like Neo4j. It designs collection validation schemas with `$jsonSchema`, determines when to embed or reference entities, and defines compound indexes tailored to query patterns.

Beyond static schema definitions, it handles multi-document transactions with session rollback logic and builds aggregation pipelines evaluated with `explain("executionStats")`. The agent relies on `Read`, `Write`, `Edit`, and `Bash` tools, meaning it requires local workspace and terminal execution privileges to modify project files directly.

## Requirements
- Works with: MongoDB

## Install

### Claude Code (native platform)

1. **claude-code-templates**
```bash
npx claude-code-templates@latest --agent database/nosql-specialist
```

2. **Manually: put the files in place**
- File: `.claude/agents/nosql-specialist.md` — For all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention

### Codex

**Manually: put the files in place**
- File: `.codex/agents/nosql-specialist.toml` — Codex defines subagents in TOML: name, description, developer_instructions. Move the Markdown text into developer_instructions by hand. For all projects use ~/.codex/agents/

### Cursor

**Manually: put the files in place**
- File: `.cursor/agents/nosql-specialist.md` — Cursor also reads .claude/agents/

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/davila7/claude-code-templates/tree/HEAD/cli-tool/components/agents/database/nosql-specialist.md

## When to use it
- structure MongoDB collection schemas with `$jsonSchema` validation
- build analytics aggregation pipelines tested with `executionStats`
- implement multi-document transactional updates with error rollback
- configure compound indexes for frequent query filters

## Example prompts
- Design a MongoDB user schema with embedded address validation and compound indexes
- Write an aggregation pipeline to analyze active customers over the past six months
- Create a Python helper for managing user sessions with expiration in Redis

## Similar
- [ai-engineer](https://affpapa.org/en/nevibecode/agents/ai-engineer.md) — subagent · 7687 installs
- [business-analyst](https://affpapa.org/en/nevibecode/agents/business-analyst.md) — subagent · 3855 installs
- [sql-pro](https://affpapa.org/en/nevibecode/agents/voltagent-community-sql-pro.md) — subagent · 3602 installs
- [sql-pro](https://affpapa.org/en/nevibecode/agents/sql-pro.md) — subagent · 3602 installs
- [data-scientist](https://affpapa.org/en/nevibecode/agents/voltagent-community-data-scientist.md) — subagent · 3342 installs
- [database-optimizer](https://affpapa.org/en/nevibecode/agents/database-optimizer.md) — subagent · 3320 installs

From the same set: [davila7/claude-code-templates](https://affpapa.org/en/nevibecode/by/davila7/claude-code-templates.md) — 495 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md