simonpaag/create-database-entity

Create Database Entity Skill

When the user needs to add a new type of data (like a new category of service provider, a user review, or a booking), follow this protocol to ensure data integrity and proper API setup.

1. Define the Schema

First, determine the structure of the new entity. Ask the user or deduce from context:

• What fields are required? (e.g., name (string), description (string), isBusiness (boolean), location (coordinates)).
• What are the relationships to existing entities? (e.g., A "Service" belongs to a "Category").

2. Update the Database configuration

Based on the chosen database tech (e.g., Prisma, Mongoose, Supabase), modify the central schema file.

• Ensure all fields have clear types.
• Add necessary indexing for fields we will search frequently (like category or location).

3. Generate Types/Interfaces

If using TypeScript (highly recommended), create or update the global type definitions (src/types/index.ts or similar) so the frontend React components know exactly what data shape to expect.

4. API Endpoints / Data Access Logic

Depending on the architecture:

• Create the necessary Backend routes/controllers (e.g., Next.js API routes or Express controllers) to handle CRUD (Create, Read, Update, Delete) operations.
• OR, create the necessary GraphQL queries/mutations.
• Ensure appropriate error handling and logging are included in the data fetching logic.

5. Verification

Provide the user with a quick example of how a frontend component would fetch this new data.