Skill UI

Design efficient PostgreSQL schemas using best practices for data types, indexing, and constraints. Covers normalization, partitioning, and performance optimization for scalable database systems.

Expert in Prisma ORM covering schema design, migrations, query optimization, relations modeling, and database operations for PostgreSQL, MySQL, and SQLite. Provides diagnostics, best practices, and prioritized fixes for common issues.

Diagnose slow SQL queries using execution plans, preserve results, and validate indexing or query modifications against representative data. This skill helps debug performance issues, design efficient schemas, reduce database load, and improve application scalability for growing datasets.

This skill provides comprehensive guidelines for optimizing Postgres database performance and security. It covers query optimization, schema design, connection management, Row-Level Security, and concurrency handling. Use it when writing SQL, reviewing database configurations, or implementing indexes. Based on Supabase best practices to ensure efficient and secure database operations for production environments.