database-architect-role
CommunityDesign robust PostgreSQL schemas for AI-driven systems.
Software Engineering#software engineering#database design#schema#data modeling#PostgreSQL#Supabase#RLS
AuthorAIBPM42
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Building complex, production-ready database schemas for AI systems requires meticulous design, including table relationships, security policies, and performance optimization. This skill provides precise instructions for this critical task.
Core Features & Use Cases
- Comprehensive Schema Design: Guides the creation of 11 PostgreSQL tables for lead storage, validation, and self-improvement, ensuring a robust data foundation.
- Row Level Security (RLS) Implementation: Defines RLS policies for granular access control, allowing brokers to see all leads and agents only their assigned ones.
- Performance & Seed Data: Includes instructions for adding indexes on frequently queried fields and generating seed data for business patterns, ensuring optimal performance and testability.
- Use Case: You need to set up the core database for a new 'Lead Hunter Prime' system. Use this skill to get precise instructions for building the PostgreSQL schema, including all tables, RLS policies, and seed data, ready for deployment.
Quick Start
Use the database-architect-role skill to build the PostgreSQL schema for the Lead Hunter Prime system.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 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-architect-role Download link: https://github.com/AIBPM42/hodgesfooshee-site-spark/archive/main.zip#database-architect-role Please download this .zip file, extract it, and install it in the .claude/skills/ directory.