Code

Database Schema Reviewer

by Invoke Studio Team·19 runs

Paste your Prisma schema or SQL DDL and get a focused review: missing indexes, normalization issues, N+1 risks, and security concerns — with exact fixes.

Example Output

## Schema Review

### 🔴 Critical
**Missing index on posts.userId**
Every query filtering posts by user does a full table scan.
Fix: add `@@index([userId])` to the Post model.

### 🟡 Design Issues
**address stored as single string in User**
Blocks filtering by city/country. Split into: street, city, state, country, postalCode.

### ✅ What's Good
- cuid() IDs used correctly
- Cascade deletes set correctly

What you'll need to provide

SchemaRequired
ORM / DatabaseRequired
Expected scale (optional)Optional

Constraints

Text input only — no file uploads
No live web data or real-time search
No code execution — tools can generate code, not run it
No memory between runs — each run is independent

Run this tool

$0.60USDC per run