lokstra-schema-design
CommunityDesign production-grade multi-tenant DB schemas
Software Engineering#postgresql#migrations#rls#schema-design#multitenancy#sql-generation#database-security
Authorprimadi
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Generate robust, production-ready PostgreSQL database schemas for Lokstra modules with built-in multi-tenant patterns, ensuring data integrity, security, and maintainable migrations.
Core Features & Use Cases
- Design tenant-aware schemas with tenant_id, composite foreign keys, and Row-Level Security (RLS) to enforce data isolation.
- Produce migration-ready SQL including tables, indexes, RLS policies, triggers, and audit logging templates.
- Provide structured guidance and templates to accelerate designing scalable, compliant data layers for Lokstra applications.
Quick Start
Use lokstra-schema-design to draft a complete PostgreSQL schema for a new Lokstra module, including tables, indexes, RLS policies, and migration scripts.
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: lokstra-schema-design Download link: https://github.com/primadi/lokstra/archive/main.zip#lokstra-schema-design Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.