Database Expert

What it does

This skill, Database Expert, assists with database design and management tasks using TypeORM. It enables an AI agent to design database schemas adhering to third normal form, generate standard TypeORM entity classes (including correct use of decorators like @Entity, @Column, and @PrimaryGeneratedColumn), manage relationships between entities, optimize performance through indexing, and maintain data migrations for smooth upgrades. This is specifically designed for backend API development involving databases.

When to use it

• Before developing a backend API, to check or update database entities.
• When designing new database schemas that need to adhere to third normal form principles.
• To generate TypeORM entity classes and configure relationships between them.
• For optimizing existing database queries by identifying and adding necessary indexes.
• During database structure changes requiring data migrations.

Key capabilities

• Schema Design: Designing databases following the third normal form.
• TypeORM Entity Generation: Creating standard TypeORM entity classes with appropriate decorators.
• Relationship Mapping: Handling OneToOne, OneToMany, and ManyToMany relationships, including Cascade and JoinColumn configuration.
• Performance Optimization: Identifying and adding indexes to improve query performance.
• Data Migration Management: Maintaining database structure changes for seamless upgrades.

Example prompts

• "Design a database schema for a blog with posts and categories."
• "Generate a TypeORM entity class for a 'Product' with properties like name, price, and description."
• "Optimize the performance of this slow query: [insert SQL query here]."

Tips & gotchas

• Naming Conventions: Database fields must use snake_case, entity attributes camelCase, and table names should follow project-specific pluralization rules.
• Data Integrity: Key fields require constraints like nullable: false or unique: true.
• SQL Injection Prevention: Avoid directly concatenating strings to build SQL queries; always use TypeORM's QueryBuilder or Repository API.