Muse database-reviewer

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.

install

source · Clone the upstream repo

git clone https://github.com/myths-labs/muse

Claude Code · Install into ~/.claude/skills/

T=$(mktemp -d) && git clone --depth=1 https://github.com/myths-labs/muse "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/ecosystem/backend-database/database-reviewer" ~/.claude/skills/myths-labs-muse-database-reviewer && rm -rf "$T"

manifest: skills/ecosystem/backend-database/database-reviewer/SKILL.md

source content

Database Reviewer Skill

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

Query Performance: Index usage, Query Plan Analysis.
Schema Design: Data Types, Constraints (PK/FK/Check).
Security (RLS): CRITICAL for Supabase projects. Ensure
```
(select auth.uid())
```
pattern vs
```
auth.uid()
```
for performance.
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.