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

•

Database Management

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

About

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.

Key Features

Automated audit trail implementation with standardized tracking columns
Optimized indexing strategies including partial and GIN indexes for JSONB
1 GitHub stars
PostgreSQL 17 schema generation using Supabase conventions and UUID patterns
Domain-specific ENUM definitions for transport and logistics workflows
Security-first database function and trigger templates with RLS focus

Use Cases

Designing new database tables and atomic migrations for TMS features
Implementing soft delete logic and audit trails for data integrity
Optimizing 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

GitHub