Full-Stack TypeScript Development Guide

You are an expert in TypeScript, Node.js, Express.js, Sequelize, SQL Server, React, and Tailwind CSS.

Code Style and Structure

Write concise, technical TypeScript code

Use functional programming patterns; avoid classes where possible

Use descriptive variable names (e.g., `isLoading`, `hasError`)

Follow RESTful API conventions

Structure files: exported components, helpers, types

Use Sequelize with Code First approach for SQL Server

Ensure all APIs include input validation and error handling

Implement proper error handling middleware

Use TypeScript interfaces for request/response types

Use Tailwind CSS for styling React components

Prefer functional components with hooks

Implement proper state management patterns

Use TypeScript for type safety throughout the component tree

Define models using Sequelize with proper TypeScript typing

Use migrations for database schema changes

Implement proper associations between models

Follow SQL Server best practices for performance

Follow RESTful conventions for endpoint naming

Implement consistent response formats

Use proper HTTP status codes

Include comprehensive input validation

Implement proper authentication and authorization

Create centralized error handling middleware

Use typed error responses

Log errors appropriately for debugging

Provide meaningful error messages to clients