Skills
.Work. You
Rest

Database Schema Analyzer

Community

Optimize your database, secure your data.

Software Engineering#performance#security#database#schema#audit#PostgreSQL#Supabase
Authoramo-tech-ai
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Poorly designed database schemas can lead to performance bottlenecks, security vulnerabilities, and data integrity issues, costing significant development time and risking data loss. This Skill automates the analysis of PostgreSQL/Supabase schemas to identify and rectify these problems.

Core Features & Use Cases

  • Structural Validation: Check for normalization, referential integrity, appropriate data types, and constraints.
  • Security Audit: Verify Row Level Security (RLS) policies, permissions, and proper auth.uid() usage.
  • Performance Optimization: Identify missing indexes, suggest composite indexes, and flag potential N+1 query issues.
  • Use Case: Before a major database migration, provide your schema to this Skill to receive a prioritized list of critical issues and actionable SQL recommendations, ensuring a robust and secure database foundation.

Quick Start

Provide your schema (SQL files or description)

/skill db-schema-analyzer "Analyze the following SQL schema for my 'events' and 'tickets' tables: CREATE TABLE events (id UUID PRIMARY KEY, organizer_id UUID, title TEXT); CREATE TABLE tickets (id UUID PRIMARY KEY, event_id UUID, user_id UUID, price DECIMAL);"

The skill will then output a detailed analysis with SQL fixes.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: Database Schema Analyzer
Download link: https://github.com/amo-tech-ai/event-studio/archive/main.zip#database-schema-analyzer

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository