Supabase Typed Query

概要

Streamlines Supabase development by providing a type-safe query builder and entity pattern library that leverages your database schema. It offers two complementary APIs—a functional, chainable Query API and a pattern-based Entity API—supporting advanced features like soft deletes, multi-tenancy via partitioned entities, and complex OR conditions. Integrated with the functype library, it ensures robust error handling through the TaskOutcome pattern, making database operations more predictable and less error-prone.

主な機能

• Advanced query capabilities including chainable OR conditions and functional operators
• Built-in support for soft delete logic and custom PostgreSQL schemas
• Type-safe query building leveraging auto-generated database schemas
• 1 GitHub stars
• Entity and PartitionedEntity patterns for standardized CRUD and multi-tenancy
• Robust error handling using TaskOutcome patterns and descriptive Supabase errors

ユースケース

• Building complex, type-safe database queries with multiple OR conditions or comparison operators
• Implementing multi-tenant architectures using partitioned entities with automatic filtering
• Standardizing CRUD operations and soft delete logic across a Supabase-backed application