backend-patterns
starsforks
How to install backend-patterns?
affaan-m/ecc/backend-patterns
$npx -y skills add affaan-m/ECC --skill backend-patternsBackend architecture patterns, API design, database optimization, and server-side best practices for Node.js, Express, and Next.js API routes.
SKILL.md
| 1 | # Backend Development Patterns |
| 2 | |
| 3 | Backend architecture patterns and best practices for scalable server-side applications. |
| 4 | |
| 5 | ## When to Activate |
| 6 | |
| 7 | - Designing REST or GraphQL API endpoints |
| 8 | - Implementing repository, service, or controller layers |
| 9 | - Optimizing database queries (N+1, indexing, connection pooling) |
| 10 | - Adding caching (Redis, in-memory, HTTP cache headers) |
| 11 | - Setting up background jobs or async processing |
| 12 | - Structuring error handling and validation for APIs |
| 13 | - Building middleware (auth, logging, rate limiting) |
| 14 | |
| 15 | ## API Design Patterns |
| 16 | |
| 17 | ### RESTful API Structure |
| 18 | |
| 19 | ```typescript |
| 20 | // PASS: Resource-based URLs |
| 21 | GET /api/markets # List resources |
| 22 | GET /api/markets/:id # Get single resource |
| 23 | POST /api/markets # Create resource |
| 24 | PUT /api/markets/:id # Replace resource |
| 25 | PATCH /api/markets/:id # Update resource |
| 26 | DELETE /api/markets/:id # Delete resource |
| 27 | |
| 28 | // PASS: Query parameters for filtering, sorting, pagination |
| 29 | GET /api/markets?status=active&sort=volume&limit=20&offset=0 |
| 30 | ``` |
| 31 | |
| 32 | ### Repository Pattern |
| 33 | |
| 34 | ```typescript |
| 35 | // Abstract data access logic |
| 36 | interface MarketRepository { |
| 37 | findAll(filters?: MarketFilters): Promise<Market[]> |
| 38 | findById(id: string): Promise<Market | null> |
| 39 | create(data: CreateMarketDto): Promise<Market> |
| 40 | update(id: string, data: UpdateMarketDto): Promise<Market> |
| 41 | delete(id: string): Promise<void> |
| 42 | } |
| 43 | |
| 44 | class SupabaseMarketRepository implements MarketRepository { |
| 45 | async findAll(filters?: MarketFilters): Promise<Market[]> { |
| 46 | let query = supabase.from('markets').select('*') |
| 47 | |
| 48 | if (filters?.status) { |
| 49 | query = query.eq('status', filters.status) |
| 50 | } |
| 51 | |
| 52 | if (filters?.limit) { |
| 53 | query = query.limit(filters.limit) |
| 54 | } |
| 55 | |
| 56 | const { data, error } = await query |
| 57 | |
| 58 | if (error) throw new Error(error.message) |
| 59 | return data |
| 60 | } |
| 61 | |
| 62 | // Other methods... |
| 63 | } |
| 64 | ``` |
| 65 | |
| 66 | ### Service Layer Pattern |
| 67 | |
| 68 | ```typescript |
| 69 | // Business logic separated from data access |
| 70 | class MarketService { |
| 71 | constructor(private marketRepo: MarketRepository) {} |
| 72 | |
| 73 | async searchMarkets(query: string, limit: number = 10): Promise<Market[]> { |
| 74 | // Business logic |
| 75 | const embedding = await generateEmbedding(query) |
| 76 | const results = await this.vectorSearch(embedding, limit) |
| 77 | |
| 78 | // Fetch full data |
| 79 | const markets = await this.marketRepo.findByIds(results.map(r => r.id)) |
| 80 | |
| 81 | // Sort by similarity |
| 82 | return markets.sort((a, b) => { |
| 83 | const scoreA = results.find(r => r.id === a.id)?.score || 0 |
| 84 | const scoreB = results.find(r => r.id === b.id)?.score || 0 |
| 85 | return scoreA - scoreB |
| 86 | }) |
| 87 | } |
| 88 | |
| 89 | private async vectorSearch(embedding: number[], limit: number) { |
| 90 | // Vector search implementation |
| 91 | } |
| 92 | } |
| 93 | ``` |
| 94 | |
| 95 | ### Middleware Pattern |
| 96 | |
| 97 | ```typescript |
| 98 | // Request/response processing pipeline |
| 99 | export function withAuth(handler: NextApiHandler): NextApiHandler { |
| 100 | return async (req, res) => { |
| 101 | const token = req.headers.authorization?.replace('Bearer ', '') |
| 102 | |
| 103 | if (!token) { |
| 104 | return res.status(401).json({ error: 'Unauthorized' }) |
| 105 | } |
| 106 | |
| 107 | try { |
| 108 | const user = await verifyToken(token) |
| 109 | req.user = user |
| 110 | return handler(req, res) |
| 111 | } catch (error) { |
| 112 | return res.status(401).json({ error: 'Invalid token' }) |
| 113 | } |
| 114 | } |
| 115 | } |
| 116 | |
| 117 | // Usage |
| 118 | export default withAuth(async (req, res) => { |
| 119 | // Handler has access to req.user |
| 120 | }) |
| 121 | ``` |
| 122 | |
| 123 | ## Database Patterns |
| 124 | |
| 125 | ### Query Optimization |
| 126 | |
| 127 | ```typescript |
| 128 | // PASS: GOOD: Select only needed columns |
| 129 | const { data } = await supabase |
| 130 | .from('markets') |
| 131 | .select('id, name, status, volume') |
| 132 | .eq('status', 'active') |
| 133 | .order('volume', { ascending: false }) |
| 134 | .limit(10) |
| 135 | |
| 136 | // FAIL: BAD: Select everything |
| 137 | const { data } = await supabase |
| 138 | .from('markets') |
| 139 | .select('*') |
| 140 | ``` |
| 141 | |
| 142 | ### N+1 Query Prevention |
| 143 | |
| 144 | ```typescript |
| 145 | // FAIL: BAD: N+1 query problem |
| 146 | const markets = await getMarkets() |
| 147 | for (const market of markets) { |
| 148 | market.creator = await getUser(market.creator_id) // N queries |
| 149 | } |
| 150 | |
| 151 | // PASS: GOOD: Batch fetch |
| 152 | const markets = await getMarkets() |
| 153 | const creatorIds = markets.map(m => m.creator_id) |
| 154 | const creators = await getUsers(creatorIds) // 1 query |
| 155 | const creatorMap = new Map(creators.map(c => [c.id, c])) |
| 156 | |
| 157 | markets.forEach(market => { |
| 158 | market.creator = creatorMap.get(market.creator_id) |
| 159 | }) |
| 160 | ``` |
| 161 | |
| 162 | ### Transaction Pattern |
| 163 | |
| 164 | ```typescript |
| 165 | async function createMarketWithPosition( |
| 166 | marketData: CreateMarketDto, |
| 167 | positionData: CreatePositionDto |
| 168 | ) { |
| 169 | // Use Supabase transaction |
| 170 | const { data, error } = await supabase.rpc('create_market_with_position', { |
| 171 | market_data: marketData, |
| 172 | position_data: positionData |
| 173 | }) |
| 174 | |
| 175 | if (error) throw new Error('Transaction failed') |
| 176 | return data |
| 177 | } |
| 178 | |
| 179 | // SQL function in Supabase |
| 180 | CREATE OR REPLACE FUNCTION create_market_with_position( |
| 181 | market_data jsonb, |
| 182 | position_data jsonb |
| 183 | ) |
| 184 | RETURNS jsonb |
| 185 | LANGUAGE plpgsql |
| 186 | AS $$ |
| 187 | BEGIN |
People who liked this also viewed
6 picksType
- find-skillsHelps users discover and install agent skills when they ask questions like "how do I do X", "find a skill for X", "is there a skill that can...", or express interest in extending capabilities. This skSkillsJul 2026
- grill-meA relentless interview to sharpen a plan or design.SkillsJul 2026
- vercel-react-best-practicesVercel's official collection of agent skillsSkillsJul 2026
- improve-codebase-architectureScan a codebase for deepening opportunities, present them as a visual HTML report, then grill through whichever one you pick.SkillsJul 2026
- setup-matt-pocock-skillsConfigure this repo for the engineering skills — set up its issue tracker, triage label vocabulary, and domain doc layout. Run once before first use of the other engineering skills.SkillsJul 2026
- triageMove issues and external PRs through a state machine of triage roles — categorise, verify, grill if needed, and write agent-ready briefs.SkillsJul 2026
