Is the database schema secure for multi-tenant applications?

Absolutely. The skill implements comprehensive Row Level Security (RLS) policies that ensure users can only access their own customer records, subscriptions, and invoices.

Does this skill work with payment providers like Stripe?

Yes, it provides the database foundation to store provider customer IDs, subscription statuses, and payment records, specifically designed to handle webhooks from Stripe, Paddle, or LemonSqueezy.

Does this store credit card information?

No. Following PCI compliance best practices, the schema is designed to store payment tokens and references from providers rather than sensitive raw card data.

How do I deploy the schemas to my project?

The skill includes automated shell scripts such as migrate-schema.sh and create-payment-tables.sh which handle the table creation and policy configuration for you.

What database platform is required for this skill?

This skill is specifically optimized for Supabase and PostgreSQL, leveraging Supabase Auth integration and Postgres-specific features like UUIDs and JSONB.

Supabase Subscription Schemas

Name: Supabase Subscription Schemas
Author: vanman2024

byvanman2024

0•

Database Management

Generates secure, production-grade Supabase database schemas and Row Level Security policies for managing SaaS subscriptions and payment workflows.

This skill provides a comprehensive, secure foundation for building subscription-based applications on Supabase. It automates the creation of normalized database tables for customers, subscriptions, payments, and invoices, while enforcing strict data isolation through pre-configured Row Level Security (RLS) policies. Designed for developers building multi-tenant SaaS platforms, it includes migration scripts, validation tools, and audit logging for webhooks, ensuring a scalable and compliant payment infrastructure that integrates seamlessly with providers like Stripe or Paddle.

Key Features

01Standardized webhook event logging for audit trails and payment reconciliation.

02Production-ready SQL schemas for customers, subscriptions, and billing transactions.

03Comprehensive Row Level Security (RLS) policies for strict multi-tenant data isolation.

04Automated migration and validation scripts for rapid database deployment.

05Pre-configured database indexes optimized for high-performance billing queries.

060 GitHub stars

Use Cases

01Setting up the database architecture for a new subscription-based SaaS application.

02Implementing secure Row Level Security for sensitive payment and invoice data.

03Adding webhook logging and audit trails to track payment provider events reliably.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add vanman2024/ai-dev-marketplace subscription-schemas

For use in Claude.ai and ChatGPT

Download Skill