IDE Rule: Database
IDE Rule: Database is a verified IDE_RULE blueprint on Promptally in Framework IDE Rules optimized for leading AI models. Cursorrules_Mdc specification for IDE Rule: Database. Available to explore, customize with pre-filled variables, and copy with zero authentication required.
Created by @promptallyTechnical Specifications
| Specification | Value |
|---|---|
| Artifact type | IDE RULE (Framework IDE Rules) |
| Compatible engines | Universal / Model Agnostic |
| Input variables | None (pre-filled) |
| Approximate tokens | 517 |
| Source file | .cursorrules |
| Access tier | Free public (MIT) |
Pre-Filled Template
--- description: "Database best practices focusing on Prisma and Supabase integration" globs: prisma/**/*, src/db/**/*, **/*.prisma, supabase/**/* alwaysApply: false --- # Database Best Practices ## Prisma Setup - Use proper schema design - Implement proper migrations - Use proper relation definitions - Configure proper connection - Implement proper seeding - Use proper client setup ## Prisma Models - Use proper model naming - Implement proper relations - Use proper field types - Define proper indexes - Implement proper constraints - Use proper enums ## Prisma Queries - Use proper query optimization - Implement proper filtering - Use proper relations loading - Handle transactions properly - Implement proper pagination - Use proper aggregations ## Supabase Setup - Configure proper project setup - Implement proper authentication - Use proper database setup - Configure proper storage - Implement proper policies - Use proper client setup ## Supabase Security - Implement proper RLS policies - Use proper authentication - Configure proper permissions - Handle sensitive data properly - Implement proper backups - Use proper encryption ## Supabase Queries - Use proper query optimization - Implement proper filtering - Use proper joins - Handle real-time properly - Implement proper pagination - Use proper functions ## Database Design - Use proper normalization - Implement proper indexing - Use proper constraints - Define proper relations - Implement proper cascades - Use proper data types ## Performance - Use proper connection pooling - Implement proper caching - Use proper query optimization - Handle N+1 queries properly - Implement proper batching - Monitor performance metrics ## Security - Use proper authentication - Implement proper authorization - Handle sensitive data properly - Use proper encryption - Implement proper backups - Monitor security issues ## Best Practices - Follow database conventions - Use proper migrations - Implement proper versioning - Handle errors properly - Document schema properly - Monitor database health
How to use this ide rule
- Review the pre-filled example and source files above.
- Copy the template or download
.cursorrules, then use it in your model, IDE, or workflow tool. - Compare your result with the sample output when one is provided.
Frequently Asked Questions
How do I use IDE Rule: Database?
Open the ide rule on Promptally, review the pre-filled example, then copy the template or download .cursorrules and paste it into your model, IDE or workflow tool. IDE Rule: Database is a static blueprint with no dynamic variables. Copy it and use it as-is.
Is IDE Rule: Database free?
Yes. IDE Rule: Database is free to view, copy and download on Promptally without creating an account. It is published under the MIT license.
What variables does IDE Rule: Database need?
IDE Rule: Database is a static blueprint with no dynamic variables. Copy it and use it as-is.