backend-patterns

Name: backend-patterns
Author: vibeeval

519stars44forks

How to install backend-patterns?

vibeeval/vibecosystem/backend-patterns

$npx -y skills add vibeeval/vibecosystem --skill backend-patterns

Installs into the current project.

Summary

--- name: backend-patterns description: Backend architecture patterns, API design, database optimization, and server-side best practices for Node.js, Express, and Next.js API routes. ---

Files · 1

View on GitHub

SKILL.md

1	# Backend Development Patterns
2
3	Backend architecture patterns and best practices for scalable server-side applications.
4
5	## API Design Patterns
6
7	### RESTful API Structure
8
9	```typescript
10	// ✅ Resource-based URLs
11	GET /api/markets # List resources
12	GET /api/markets/:id # Get single resource
13	POST /api/markets # Create resource
14	PUT /api/markets/:id # Replace resource
15	PATCH /api/markets/:id # Update resource
16	DELETE /api/markets/:id # Delete resource
17
18	// ✅ Query parameters for filtering, sorting, pagination
19	GET /api/markets?status=active&sort=volume&limit=20&offset=0
20	```
21
22	### Repository Pattern
23
24	```typescript
25	// Abstract data access logic
26	interface MarketRepository {
27	findAll(filters?: MarketFilters): Promise<Market[]>
28	findById(id: string): Promise<Market \| null>
29	create(data: CreateMarketDto): Promise<Market>
30	update(id: string, data: UpdateMarketDto): Promise<Market>
31	delete(id: string): Promise<void>
32	}
33
34	class SupabaseMarketRepository implements MarketRepository {
35	async findAll(filters?: MarketFilters): Promise<Market[]> {
36	let query = supabase.from('markets').select('*')
37
38	if (filters?.status) {
39	query = query.eq('status', filters.status)
40	}
41
42	if (filters?.limit) {
43	query = query.limit(filters.limit)
44	}
45
46	const { data, error } = await query
47
48	if (error) throw new Error(error.message)
49	return data
50	}
51
52	// Other methods...
53	}
54	```
55
56	### Service Layer Pattern
57
58	```typescript
59	// Business logic separated from data access
60	class MarketService {
61	constructor(private marketRepo: MarketRepository) {}
62
63	async searchMarkets(query: string, limit: number = 10): Promise<Market[]> {
64	// Business logic
65	const embedding = await generateEmbedding(query)
66	const results = await this.vectorSearch(embedding, limit)
67
68	// Fetch full data
69	const markets = await this.marketRepo.findByIds(results.map(r => r.id))
70
71	// Sort by similarity
72	return markets.sort((a, b) => {
73	const scoreA = results.find(r => r.id === a.id)?.score \|\| 0
74	const scoreB = results.find(r => r.id === b.id)?.score \|\| 0
75	return scoreA - scoreB
76	})
77	}
78
79	private async vectorSearch(embedding: number[], limit: number) {
80	// Vector search implementation
81	}
82	}
83	```
84
85	### Middleware Pattern
86
87	```typescript
88	// Request/response processing pipeline
89	export function withAuth(handler: NextApiHandler): NextApiHandler {
90	return async (req, res) => {
91	const token = req.headers.authorization?.replace('Bearer ', '')
92
93	if (!token) {
94	return res.status(401).json({ error: 'Unauthorized' })
95	}
96
97	try {
98	const user = await verifyToken(token)
99	req.user = user
100	return handler(req, res)
101	} catch (error) {
102	return res.status(401).json({ error: 'Invalid token' })
103	}
104	}
105	}
106
107	// Usage
108	export default withAuth(async (req, res) => {
109	// Handler has access to req.user
110	})
111	```
112
113	## Database Patterns
114
115	### Query Optimization
116
117	```typescript
118	// ✅ GOOD: Select only needed columns
119	const { data } = await supabase
120	.from('markets')
121	.select('id, name, status, volume')
122	.eq('status', 'active')
123	.order('volume', { ascending: false })
124	.limit(10)
125
126	// ❌ BAD: Select everything
127	const { data } = await supabase
128	.from('markets')
129	.select('*')
130	```
131
132	### N+1 Query Prevention
133
134	```typescript
135	// ❌ BAD: N+1 query problem
136	const markets = await getMarkets()
137	for (const market of markets) {
138	market.creator = await getUser(market.creator_id) // N queries
139	}
140
141	// ✅ GOOD: Batch fetch
142	const markets = await getMarkets()
143	const creatorIds = markets.map(m => m.creator_id)
144	const creators = await getUsers(creatorIds) // 1 query
145	const creatorMap = new Map(creators.map(c => [c.id, c]))
146
147	markets.forEach(market => {
148	market.creator = creatorMap.get(market.creator_id)
149	})
150	```
151
152	### Transaction Pattern
153
154	```typescript
155	async function createMarketWithPosition(
156	marketData: CreateMarketDto,
157	positionData: CreatePositionDto
158	) {
159	// Use Supabase transaction
160	const { data, error } = await supabase.rpc('create_market_with_position', {
161	market_data: marketData,
162	position_data: positionData
163	})
164
165	if (error) throw new Error('Transaction failed')
166	return data
167	}
168
169	// SQL function in Supabase
170	CREATE OR REPLACE FUNCTION create_market_with_position(
171	market_data jsonb,
172	position_data jsonb
173	)
174	RETURNS jsonb
175	LANGUAGE plpgsql
176	AS $$
177	BEGIN
178	-- Start transaction automatically
179	INSERT INTO markets VALUES (market_data);
180	INSERT INTO positions VALUES (position_data);
181	RETURN jsonb_build_object('success', true);
182	EXCEPTION
183	WHEN OTHERS THEN
184	-- Rollback happens autom

People who liked this also viewed

6 picks

Type

hyperframes-cliUse the HyperFrames CLI development loop: init, add, catalog, capture, lint, check, snapshot, compare, grade-compare, preview, play, present, beats, keyframes, single or batch render, publish, cloud, SkillsJul 2026262k37k
request-refactor-planSkills for Real Engineers. Straight from my .agents directory.SkillsJul 2026165k181k
analyze-projectRigor Analyze / Rigor Audit read-only skill for deep learning research repositories. Use when the user wants to read and understand a repository, inspect model structure and training or inference entrSkillsMay 2026161k507
explore-codeRigor Improve implementation leaf skill for auditable candidate implementation in deep learning research repositories. Use when the researcher explicitly authorizes exploratory work on an isolated braSkillsMay 2026161k507
ubiquitous-languageSkills for Real Engineers. Straight from my .agents directory.SkillsJul 2026160k181k
scaffold-exercisesSkills for Real Engineers. Straight from my .agents directory.SkillsJul 2026149k181k

backend-patterns

519stars44forks

View on GitHub

How to install backend-patterns?

vibeeval/vibecosystem/backend-patterns

$npx -y skills add vibeeval/vibecosystem --skill backend-patterns

Installs into the current project.

Summary

--- name: backend-patterns description: Backend architecture patterns, API design, database optimization, and server-side best practices for Node.js, Express, and Next.js API routes. ---

Files · 1

View on GitHub

SKILL.md

1	# Backend Development Patterns
2
3	Backend architecture patterns and best practices for scalable server-side applications.
4
5	## API Design Patterns
6
7	### RESTful API Structure
8
9	```typescript
10	// ✅ Resource-based URLs
11	GET /api/markets # List resources
12	GET /api/markets/:id # Get single resource
13	POST /api/markets # Create resource
14	PUT /api/markets/:id # Replace resource
15	PATCH /api/markets/:id # Update resource
16	DELETE /api/markets/:id # Delete resource
17
18	// ✅ Query parameters for filtering, sorting, pagination
19	GET /api/markets?status=active&sort=volume&limit=20&offset=0
20	```
21
22	### Repository Pattern
23
24	```typescript
25	// Abstract data access logic
26	interface MarketRepository {
27	findAll(filters?: MarketFilters): Promise<Market[]>
28	findById(id: string): Promise<Market \| null>
29	create(data: CreateMarketDto): Promise<Market>
30	update(id: string, data: UpdateMarketDto): Promise<Market>
31	delete(id: string): Promise<void>
32	}
33
34	class SupabaseMarketRepository implements MarketRepository {
35	async findAll(filters?: MarketFilters): Promise<Market[]> {
36	let query = supabase.from('markets').select('*')
37
38	if (filters?.status) {
39	query = query.eq('status', filters.status)
40	}
41
42	if (filters?.limit) {
43	query = query.limit(filters.limit)
44	}
45
46	const { data, error } = await query
47
48	if (error) throw new Error(error.message)
49	return data
50	}
51
52	// Other methods...
53	}
54	```
55
56	### Service Layer Pattern
57
58	```typescript
59	// Business logic separated from data access
60	class MarketService {
61	constructor(private marketRepo: MarketRepository) {}
62
63	async searchMarkets(query: string, limit: number = 10): Promise<Market[]> {
64	// Business logic
65	const embedding = await generateEmbedding(query)
66	const results = await this.vectorSearch(embedding, limit)
67
68	// Fetch full data
69	const markets = await this.marketRepo.findByIds(results.map(r => r.id))
70
71	// Sort by similarity
72	return markets.sort((a, b) => {
73	const scoreA = results.find(r => r.id === a.id)?.score \|\| 0
74	const scoreB = results.find(r => r.id === b.id)?.score \|\| 0
75	return scoreA - scoreB
76	})
77	}
78
79	private async vectorSearch(embedding: number[], limit: number) {
80	// Vector search implementation
81	}
82	}
83	```
84
85	### Middleware Pattern
86
87	```typescript
88	// Request/response processing pipeline
89	export function withAuth(handler: NextApiHandler): NextApiHandler {
90	return async (req, res) => {
91	const token = req.headers.authorization?.replace('Bearer ', '')
92
93	if (!token) {
94	return res.status(401).json({ error: 'Unauthorized' })
95	}
96
97	try {
98	const user = await verifyToken(token)
99	req.user = user
100	return handler(req, res)
101	} catch (error) {
102	return res.status(401).json({ error: 'Invalid token' })
103	}
104	}
105	}
106
107	// Usage
108	export default withAuth(async (req, res) => {
109	// Handler has access to req.user
110	})
111	```
112
113	## Database Patterns
114
115	### Query Optimization
116
117	```typescript
118	// ✅ GOOD: Select only needed columns
119	const { data } = await supabase
120	.from('markets')
121	.select('id, name, status, volume')
122	.eq('status', 'active')
123	.order('volume', { ascending: false })
124	.limit(10)
125
126	// ❌ BAD: Select everything
127	const { data } = await supabase
128	.from('markets')
129	.select('*')
130	```
131
132	### N+1 Query Prevention
133
134	```typescript
135	// ❌ BAD: N+1 query problem
136	const markets = await getMarkets()
137	for (const market of markets) {
138	market.creator = await getUser(market.creator_id) // N queries
139	}
140
141	// ✅ GOOD: Batch fetch
142	const markets = await getMarkets()
143	const creatorIds = markets.map(m => m.creator_id)
144	const creators = await getUsers(creatorIds) // 1 query
145	const creatorMap = new Map(creators.map(c => [c.id, c]))
146
147	markets.forEach(market => {
148	market.creator = creatorMap.get(market.creator_id)
149	})
150	```
151
152	### Transaction Pattern
153
154	```typescript
155	async function createMarketWithPosition(
156	marketData: CreateMarketDto,
157	positionData: CreatePositionDto
158	) {
159	// Use Supabase transaction
160	const { data, error } = await supabase.rpc('create_market_with_position', {
161	market_data: marketData,
162	position_data: positionData
163	})
164
165	if (error) throw new Error('Transaction failed')
166	return data
167	}
168
169	// SQL function in Supabase
170	CREATE OR REPLACE FUNCTION create_market_with_position(
171	market_data jsonb,
172	position_data jsonb
173	)
174	RETURNS jsonb
175	LANGUAGE plpgsql
176	AS $$
177	BEGIN
178	-- Start transaction automatically
179	INSERT INTO markets VALUES (market_data);
180	INSERT INTO positions VALUES (position_data);
181	RETURN jsonb_build_object('success', true);
182	EXCEPTION
183	WHEN OTHERS THEN
184	-- Rollback happens autom

People who liked this also viewed

6 picks

Type