skills.rest
dduquenne
dduquenneCOMMUNITY
Explore all skills by this author →
GitHub

databasix

Design, migrate, and secure Supabase data layers for TypeScript apps.

1|Updated Mar 10, 2026
Search Tags:#typescript#performance#database#migrations#rls#supabase
One-click install
npx skills add https://github.com/dduquenne/unanima-platform --skill databasix
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databasix
Source: https://github.com/dduquenne/unanima-platform/tree/main/.claude/skills/databasix
Command: npx skills add https://github.com/dduquenne/unanima-platform --skill databasix

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Databasix addresses the complexity of designing, migrating, and securing the data layer for TypeScript applications using Supabase (PostgreSQL). It streamlines schema modeling, migrations, RLS policies, and the generation of TypeScript types, while promoting performance, accountability, and robust data governance across multi-tenant SaaS projects.

Core Features & Use Cases

  • Schema design with strict naming conventions, UUIDs and timestamptz defaults to ensure consistency across teams.
  • Migrations workflow, versioning, and testability with a clear process for local, staging, and production environments.
  • Security & RLS patterns to implement fine-grained access control for multi-tenant apps and audits.
  • TypeScript types generation from Supabase schema, enabling type-safe client code and repository patterns.
  • Performance optimization guidance including indexing, partitioning, and query diagnostics.
  • Auditing, logging, and pgTAP testing integrations for governance and quality assurance.

Quick Start

Define your schema and RLS rules, then run migrations and generate TypeScript types for your app.

Frequently Asked Questions about databasix

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate TypeScript types from a Supabase schema?▼

TypeScript types are generated from your Supabase schema after defining schema and RLS rules, enabling type-safe client code and repository patterns for your application.

What is the best way to implement Row Level Security policies for a multi-tenant Supabase app?▼

Row Level Security policies for multi-tenant Supabase apps are implemented using fine-grained access control patterns that secure data across tenants and support auditing for robust data governance.

How do I manage database migrations for Supabase across staging and production environments?▼

Database migrations for Supabase are managed through a versioned workflow providing a clear process for applying schema changes consistently across local, staging, and production environments.

Can I use pgTAP tests to validate Supabase database migrations and RLS policies?▼

Yes, pgTAP testing integrations validate Supabase database migrations and RLS policies to ensure quality assurance and robust data governance across multi-tenant SaaS projects.

How do I optimize Supabase query performance and indexing in TypeScript applications?▼

Supabase query performance is optimized by applying indexing, partitioning, and query diagnostics guidance to resolve performance challenges within your TypeScript data layer.

Related Skills

Explore More Software Engineering Skills→
wenermewenerme
7

wode-db-schema-pattern

Enforce strict PostgreSQL schema patterns for Wode tables with tenant-scoped composite keys.

Community
Basic
jtucker9jtucker9

migration-planner

Generate ordered migration scripts and rollback plans from schema diffs.

Community
Advanced
antonpmeantonpme
1

supabase

Guides Supabase edge functions, schemas, migrations, and RLS policies.

Community
Advanced
amo-tech-aiamo-tech-ai

supabase-migration

Create idempotent Supabase PostgreSQL migrations with RLS policies and profile_id foreign keys.

Community
Intermediate