What database version is this skill optimized for?

This skill is specifically designed for PostgreSQL 17 using Supabase conventions, ensuring compatibility with modern cloud-native database features.

How are database functions secured?

The skill mandates the use of SECURITY INVOKER and explicit search_path settings to protect against schema search path attacks and ensure proper permission handling.

Can I use this for non-logistics projects?

While the conventions are designed for LaneweaverTMS, the underlying PostgreSQL and Supabase best practices are highly applicable to any robust production database.

Does this skill handle soft deletes?

Yes, it enforces a standard pattern using a 'deleted_at' timestamp and provides guidance on querying active records while avoiding hard deletes.

Why are foreign keys indexed manually in this skill?

PostgreSQL does not automatically index foreign keys; this skill provides patterns to manually create these indexes to prevent performance degradation during joins.

Laneweaver Database Design

Name: Laneweaver Database Design
Author: linehaul-ai

bylinehaul-ai

•

데이터베이스 관리

Designs robust PostgreSQL 17 schemas and Supabase migrations tailored for the LaneweaverTMS logistics ecosystem.

The laneweaver-database-design skill empowers Claude to architect production-grade database structures using PostgreSQL 17 and Supabase best practices. It enforces strict domain-specific conventions for the LaneweaverTMS platform, including the mandatory use of UUIDs for primary keys (with user-table exceptions), comprehensive audit trails, and soft-delete patterns. By providing patterns for complex ENUM types, manual foreign key indexing, and security-hardened database functions, this skill ensures that your data layer is scalable, secure, and optimized for high-performance logistics operations.

주요 기능

01Automated audit trail implementation with standardized tracking columns

02Optimized indexing strategies including partial and GIN indexes for JSONB

031 GitHub stars

04PostgreSQL 17 schema generation using Supabase conventions and UUID patterns

05Domain-specific ENUM definitions for transport and logistics workflows

06Security-first database function and trigger templates with RLS focus

사용 사례

01Designing new database tables and atomic migrations for TMS features

02Implementing soft delete logic and audit trails for data integrity

03Optimizing query performance via manual foreign key and partial indexing

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add linehaul-ai/linehaulai-claude-marketplace laneweaver-database-design

For use in Claude.ai and ChatGPT

Download Skill