Rui Keiba Project Assistant

Development assistant for the `rui-keiba` horse racing data analysis platform. This skill provides context-aware guidance for working with the PostgreSQL/Express/Next.js stack while enforcing project-specific conventions.

Communication Style

**CRITICAL: Always communicate in casual Japanese (タメ口). Do not use polite/formal Japanese (敬語).**

Development Constraints

**CRITICAL: Do NOT run npm commands (install, build, test, etc.) unless explicitly instructed by the user. Only execute npm commands when the user specifically requests them.**

Code Style Enforcement

**CRITICAL: Always use double quotes (") for strings in TypeScript/JavaScript code. Never use single quotes (').**

Good examples:

```typescript

const message = "Hello";

import { Router } from "express";

```

Bad examples:

```typescript

const message = 'Hello';

import { Router } from 'express';

```

Project Overview

`rui-keiba` is a horse racing data analysis platform that:

**Technology Stack:**

Key Development Commands

Docker Environment

```bash

Start containers

docker-compose up -d

View logs

docker-compose logs -f

Stop containers

docker-compose down

Restart after schema changes

docker-compose restart postgres

Destroy all data and reload schema

docker-compose down -v

```

Database Access

**PostgreSQL (localhost:5432):**

**pgAdmin (http://localhost:5050):**

Backend Development

```bash

cd backend

npm run dev # Development server (port 3001)

npm run build # Production build

npm start # Run production

```

**API Endpoints:**

Frontend Development

```bash

cd frontend

npm run dev # Development server (port 3000)

npm run build # Production build

npm start # Run production

```

Database Architecture

Schema location: `database/schema.sql` (auto-initialized on first container start)

**Core Entities:**

**Race Data:**

**Key Features:**

Project Structure

```

rui-keiba/

├── docker-compose.yml

├── database/schema.sql

├── backend/ # Express API

│ ├── src/

│ │ ├── index.ts # Main entry

│ │ ├── config/database.ts

│ │ ├── routes/

│ │ ├── controllers/

│ │ └── services/

│ └── .env

└── frontend/ # Next.js (bulletproof-react)

├── app/ # App Router

│ ├── page.tsx # Dashboard

│ └── races/[id]/

└── src/

├── components/ui/ # Shared UI

├── features/ # Feature modules

│ ├── races/

│ │ ├── api/

│ │ ├── components/

│ │ └── types/

│ └── health/

├── lib/ # Config (api-client, providers, theme)

└── utils/

```

**Frontend Architecture:**

Standard Development Workflow

1. Start Docker containers: `docker-compose up -d`

2. Start backend: `cd backend && npm run dev`

3. Start frontend: `cd frontend && npm run dev`

4. Access frontend at http://localhost:3000

Important Notes