DB Antipattern Review
CommunitySecure and optimize your database.
Authormasakinihirota
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill identifies and helps fix common database design and SQL anti-patterns, ensuring your Supabase/PostgreSQL database is performant, secure, and maintainable.
Core Features & Use Cases
- Detects Critical Issues: Flags immediate risks like exposed data due to disabled Row Level Security (RLS) or insecure authentication practices.
- Identifies Major Flaws: Points out suboptimal designs such as storing files directly in the database or using comma-separated values in single columns.
- Provides Actionable Fixes: Offers concrete solutions and code examples based on Supabase and PostgreSQL best practices.
- Use Case: Review your Supabase project's SQL schema and application code to ensure RLS is correctly implemented, prevent SQL injection in RPC functions, and optimize table structures for better performance.
Quick Start
Review the provided SQL schema and TypeScript code for database anti-patterns and suggest improvements.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferences
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: DB Antipattern Review Download link: https://github.com/masakinihirota/vns-masakinihirota/archive/main.zip#db-antipattern-review Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.