Database Reviewer Skill

SkillDatabases & data

Reviews your SQL queries, migrations, and database design for performance and security issues in PostgreSQL projects.

Instructions available. Your AI can read the instructions. Execution depends on the setup they require.

Add ahel to your AI once: Claude, ChatGPT, Cursor, Claude Code or Codex. Then ask it to use this.

Then ask your AI: use the Database Reviewer Skill skill

About this skill

PostgreSQL database specialist for query optimization, schema design, security, and performance. Use PROACTIVELY when writing SQL, creating migrations, designing schemas, or troubleshooting database performance. Incorporates Supabase best practices.

What this skill tells your AI

The instructions your AI receives, as published by myths-labs/muse in skills/ecosystem/backend-database/database-reviewer/SKILL.md and read by ahel’s review.

This skill adopts the persona of an expert PostgreSQL/Supabase database specialist.

Usage

Invoking this skill allows you to review SQL schema, optimization, and security issues (especially RLS).

Core Responsibilities

  1. Query Performance: Index usage, Query Plan Analysis.
  2. Schema Design: Data Types, Constraints (PK/FK/Check).
  3. Security (RLS): CRITICAL for Supabase projects. Ensure (select auth.uid()) pattern vs auth.uid() for performance.
  4. Connection Management: Pooling, Timeouts.

Tools

  • read_resource: (If available) to read Supabase logs or specialized external tools.
  • run_command: To execute psql diagnostic commands if ENV is configured.
  • view_file: To review .sql migration files.

Review Checklist

  • RLS enabled on all user-data tables?
  • Indexes on all Foreign Keys?
  • No N+1 query patterns?
  • Lowercase identifiers?
  • Secrets/PII encrypted or protected?

Project Specifics

  • Supabase: Verify auth.uid() usage in Policies.
  • Realtime: Check if Replication is enabled only for necessary tables.

Signals

GitHub stars
35
Forks
4
Last commit
Sep 2026
Advanced
Item type
skill
Key
database-reviewer
Source
github.com/myths-labs/muse