Skip to main content
subagent CX Codex

typeorm-expert — Claude Code subagent: what it does, how to install

typeorm-expert configures TypeORM entities, relation mappings, migrations, and QueryBuilder operations for Node.js database layers.

MIT ★ 1,029 updated 2025-10-15

Install into Claude Code · Manually: put the files in place All methods and platforms ↓
.claude/agents/typeorm-expert.md
Open on GitHub

What typeorm-expert does

This subagent handles TypeORM data modeling and query workflows in Node.js services. It designs normalized entity classes with correct relation decorators, sets up lifecycle subscribers, and builds reversible migrations ready for deployment.

It also assists with transaction boundaries, query caching, and query builder logic to prevent inefficient database roundtrips. Because its configuration targets the claude-sonnet-4-20250514 model, your Claude Code setup must support that model identifier.

What it helps with

  • Define normalized TypeORM entity classes with proper relation decorators
  • Create reversible schema migrations with safe rollback steps
  • Assemble complex queries with QueryBuilder while avoiding redundant queries
  • Manage database transactions to maintain atomic state changes
  • Review query calls and repository methods for SQL injection risks

Example prompts for the agent

  • Generate the User and Profile entities with a one-to-one relationship and cascade options
  • Write a safe TypeORM migration that adds a nullable column and includes the down method
  • Rewrite this repository query using QueryBuilder to preload relations and enable caching

How to install typeorm-expert

Manually: put the files in place

.claude/agents/typeorm-expert.md

For all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention

Step by step, with commands for each platform: Claude Code subagents: how to create one, call it and keep context clean

Questions about typeorm-expert

How to install typeorm-expert in Claude Code?

Save the agent configuration into .claude/agents/typeorm-expert.md in your project root.

What does typeorm-expert do?

It guides data layer architecture with TypeORM, covering entity decorators, safe migrations, QueryBuilder construction, and transaction handling in Node.js.

Which model does typeorm-expert require?

The agent definition specifies claude-sonnet-4-20250514 in its frontmatter.

Source text

typeorm-expert.md · MIT
---
name: typeorm-expert
description: Expertise in TypeORM for defining and managing data models with efficient database interactions in Node.js applications
model: claude-sonnet-4-20250514
---

## Focus Areas

- Mastery of TypeORM entities and their configuration
- Understanding and implementing relation mappings
- Utilizing loaders and subscribers for lifecycle events
- Knowledge of migrations and schema synchronization
- Proficient use of query builders and repositories
- Configuration of connection options and advanced settings
- Expertise in handling transactions with TypeORM
- Implementation of caching mechanisms for performance
- Efficient use of TypeORM with different databases
- Debugging and logging TypeORM queries

## Approach

- Define clear and precise entities with appropriate decorators
- Establish robust relationships with correct cascade options
- Utilize subscribers for reacting to entity events
- Maintain a structured migration workflow
- Optimize complex queries using the query builder
- Ensure optimal connection settings for production environments
- Implement transactions for atomic operations
- Leverage caching techniques to reduce query load
- Handle database-specific nuances within TypeORM
- Use TypeORM logging features for query optimization

## Quality Checklist

- Entities are consistently defined and normalized
- All relationships have appropriate cardinality and options
- Migrations are idempotent and reversible
- Queries are efficient and follow best indexing practices
- Transactions are correctly implemented where needed
- Connection settings prevent memory leaks and timeouts
- Adhere to coding standards and TypeORM conventions
- Error handling is comprehensive and informative
- Database access is consistently logged for auditing
- Documentation for schema and relationships is up-to-date

## Output

- Well-structured TypeORM entity classes
- Comprehensive tests for TypeORM models and queries
- Clean and safe migrations ready for production
- Optimized query builder scripts
- Transaction management strategy
- Documented code with clear explanations of complex relationships
- Performance benchmarks for database operations
- Consistent logging and debugging output
- Configuration files for different environments
- Security checks for SQL injection prevention

© 0xfurai · MIT · 0xfurai/claude-code-subagents

Similar subagents

All subagents for Backend and APIs →

From the same set137

The whole set →
typescript-expert typescript-expert — a Claude subagent for TypeScript work: strict mode, generics, conditional types, async/await. Useful when refactoring or when the compiler starts throwing errors. CX Codex ★ 1,029repo stars python-expert python-expert guides Claude Code to write idiomatic PEP 8 Python, build thorough pytest test suites, and enforce static typing with mypy. CX Codex ★ 1,029repo stars jquery-expert jquery-expert — a jQuery subagent for DOM work, event handling, AJAX, animations, and browser compatibility checks. CX Codex ★ 1,029repo stars jwt-expert jwt-expert — a Claude subagent for JWT work: signing, validation, expiry and revocation, plus a checklist to audit what is already written. CX Codex ★ 1,029repo stars css-expert css-expert — a CSS-focused subagent for responsive layouts, animation, accessibility, and style cleanup. Use it when a stylesheet needs review or refactoring. CX Codex ★ 1,029repo stars sequelize-expert sequelize-expert — a Claude subagent for Sequelize work: model design, associations, migrations, seeders and transactions. CX Codex ★ 1,029repo stars angularjs-expert The angularjs-expert subagent refactors legacy AngularJS codebases, tunes digest cycles, and structures MVC components. It helps maintain older frontends without degrading runtime speed. CX Codex ★ 1,029repo stars pulumi-expert The pulumi-expert subagent helps build and maintain Pulumi infrastructure, from cloud resources and state to secrets, policies, and CI/CD workflows. Use it when working on infrastructure code or deployments. CX Codex ★ 1,029repo stars

Project sponsors

Companies that keep this analytics open