Database Agent Rule

{
    "system_prompt": "# Database Best Practices\n\n## Prisma Setup\n- Use proper schema design\n- Implement proper migrations\n- Use proper relation definitions\n- Configure proper connection\n- Implement proper seeding\n- Use proper client setup\n\n## Prisma Models\n- Use proper model naming\n- Implement proper relations\n- Use proper field types\n- Define proper indexes\n- Implement proper constraints\n- Use proper enums\n\n## Prisma Queries\n- Use proper query optimization\n- Implement proper filtering\n- Use proper relations loading\n- Handle transactions properly\n- Implement proper pagination\n- Use proper aggregations\n\n## Supabase Setup\n- Configure proper project setup\n- Implement proper authentication\n- Use proper database setup\n- Configure proper storage\n- Implement proper policies\n- Use proper client setup\n\n## Supabase Security\n- Implement proper RLS policies\n- Use proper authentication\n- Configure proper permissions\n- Handle sensitive data properly\n- Implement proper backups\n- Use proper encryption\n\n## Supabase Queries\n- Use proper query optimization\n- Implement proper filtering\n- Use proper joins\n- Handle real-time properly\n- Implement proper pagination\n- Use proper functions\n\n## Database Design\n- Use proper normalization\n- Implement proper indexing\n- Use proper constraints\n- Define proper relations\n- Implement proper cascades\n- Use proper data types\n\n## Performance\n- Use proper connection pooling\n- Implement proper caching\n- Use proper query optimization\n- Handle N+1 queries properly\n- Implement proper batching\n- Monitor performance metrics\n\n## Security\n- Use proper authentication\n- Implement proper authorization\n- Handle sensitive data properly\n- Use proper encryption\n- Implement proper backups\n- Monitor security issues\n\n## Best Practices\n- Follow database conventions\n- Use proper migrations\n- Implement proper versioning\n- Handle errors properly\n- Document schema properly\n- Monitor database health",
    "prompt_type": "agent_rule",
    "framework": "cursor",
    "globs": "prisma/**/*, src/db/**/*, **/*.prisma, supabase/**/*",
    "compatible_models": [
        "Claude 3.5 Sonnet",
        "GPT-4o",
        "Cursor AI",
        "Gemini 2.5 Flash"
    ],
    "download_filename": "database.cursorrules",
    "tags": [
        "cursor",
        "cursorrules",
        "agent",
        "coding",
        "database"
    ]
}