senior-dba

Reviews and documents PostgreSQL/Supabase schemas from Prisma files.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/tokijh/minapp --skill senior-dba
Or copy as Structured Prompt for Agentโ–ผ
Please help me install this Agent Skill.
Skill: senior-dba
Source: https://github.com/tokijh/minapp/tree/main/.claude/skills/senior-dba
Command: npx skills add https://github.com/tokijh/minapp --skill senior-dba

SYSTEM DOCUMENTATION & REQUIREMENTS

๐Ÿ’ก This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines database schema design, migration, and optimization, ensuring robust and efficient database management.

Core Features & Use Cases

  • Schema Design & Review: Provides expert review and documentation for DB schemas, focusing on PostgreSQL/Supabase patterns.
  • Migration Assistance: Guides through schema changes, index creation, Row Level Security (RLS), triggers, and extension functions.
  • Use Case: Ensure your new database schema adheres to best practices for performance and security, including proper indexing and RLS policies.

Quick Start

Review the provided Prisma schema and suggest improvements for indexing and RLS policies.

Frequently Asked Questions about senior-dba

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize my PostgreSQL schema for indexing and Row Level Security?โ–ผ

To optimize your PostgreSQL schema, this Skill reviews your Prisma schema and database docs to suggest proper indexing and RLS policies. It ensures your schema design adheres to robust performance and security best practices.

What is the best way to manage database migrations with Supabase patterns?โ–ผ

Managing database migrations with Supabase patterns involves guided schema changes, index creation, and trigger setup. This Skill assists by reviewing your migration approach and ensuring consistency with project database conventions.

How do I set up Row Level Security and triggers for my database schema?โ–ผ

Setting up Row Level Security and triggers requires defining secure data access rules and automated database actions. This Skill provides expert review and documentation for RLS policies and triggers based on your Prisma schema.

Does this database schema review work with Prisma and PostgreSQL conventions?โ–ผ

Yes, this schema review works specifically with Prisma and PostgreSQL conventions. It analyzes your `prisma/schema.prisma` and `docs/db/` files to ensure identifiers, common columns, and naming follow your project standards.

When do I need to review database schema design for extension functions?โ–ผ

You need to review database schema design for extension functions when adding custom logic or complex operations to your PostgreSQL database. This Skill assists in documenting and guiding the creation of these extension functions.