What is Database Design?

Database Design is a free, open-source AI agent skill. Database best practices focusing on Prisma and Supabase integration

How do I install Database Design?

Install Database Design with a single command: npx mdskills install PatrickJS/cursor-database. This downloads the skill files into your project and your AI agent picks them up automatically.

What platforms support Database Design?

Database Design works with Cursor. Skills use the open SKILL.md format which is compatible with any AI coding agent that reads markdown instructions.

← Back to rules

Database Design

Name: Database Design: AI Agent Skill
Rating: 3 (1 reviews)
Author: PatrickJS

RulesDatabase DesignIntermediate

Database best practices focusing on Prisma and Supabase integration

by @PatrickJS0Updated 2 weeks ago

Add this skill

npx mdskills install PatrickJS/cursor-database

Fork & Edit

Skill Advisor3.0

Extremely generic checklist lacking actionable instructions or specific implementation guidance

+Covers comprehensive database topics across Prisma and Supabase
+Appropriate file glob patterns for database-related files
-Contains only vague bullet points like 'use proper' without concrete instructions
-Lacks trigger conditions, step-by-step workflows, or examples

SKILL.md

Edit in Browser

1---
2description: Database best practices focusing on Prisma and Supabase integration
3globs: prisma/**/*, src/db/**/*, **/*.prisma, supabase/**/*
4---
5 
6# Database Best Practices
7 
8## Prisma Setup
9- Use proper schema design
10- Implement proper migrations
11- Use proper relation definitions
12- Configure proper connection
13- Implement proper seeding
14- Use proper client setup
15 
16## Prisma Models
17- Use proper model naming
18- Implement proper relations
19- Use proper field types
20- Define proper indexes
21- Implement proper constraints
22- Use proper enums
23 
24## Prisma Queries
25- Use proper query optimization
26- Implement proper filtering
27- Use proper relations loading
28- Handle transactions properly
29- Implement proper pagination
30- Use proper aggregations
31 
32## Supabase Setup
33- Configure proper project setup
34- Implement proper authentication
35- Use proper database setup
36- Configure proper storage
37- Implement proper policies
38- Use proper client setup
39 
40## Supabase Security
41- Implement proper RLS policies
42- Use proper authentication
43- Configure proper permissions
44- Handle sensitive data properly
45- Implement proper backups
46- Use proper encryption
47 
48## Supabase Queries
49- Use proper query optimization
50- Implement proper filtering
51- Use proper joins
52- Handle real-time properly
53- Implement proper pagination
54- Use proper functions
55 
56## Database Design
57- Use proper normalization
58- Implement proper indexing
59- Use proper constraints
60- Define proper relations
61- Implement proper cascades
62- Use proper data types
63 
64## Performance
65- Use proper connection pooling
66- Implement proper caching
67- Use proper query optimization
68- Handle N+1 queries properly
69- Implement proper batching
70- Monitor performance metrics
71 
72## Security
73- Use proper authentication
74- Implement proper authorization
75- Handle sensitive data properly
76- Use proper encryption
77- Implement proper backups
78- Monitor security issues
79 
80## Best Practices
81- Follow database conventions
82- Use proper migrations
83- Implement proper versioning
84- Handle errors properly
85- Document schema properly
86- Monitor database health

Full transparency — inspect the skill content before installing.