supabase-node

Build Node.js APIs with Supabase authentication, storage, and Drizzle ORM.

Updated Jun 19, 2026
One-click install
npx skills add https://github.com/lciacci/tessera --skill supabase-node-lciacci
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: supabase-node
Source: https://github.com/lciacci/tessera/tree/main/skills/supabase-node
Command: npx skills add https://github.com/lciacci/tessera --skill supabase-node-lciacci

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a reliable blueprint for building Node.js backends that combine Supabase authentication and storage with Drizzle ORM database access, validation, and centralized error handling.

Core Features & Use Cases

  • Backend Foundation: Structure Express or Hono applications with routes, middleware, configuration, and health checks.
  • Supabase Integration: Implement authentication, JWT verification, session flows, storage uploads, and secure client configuration.
  • Database Workflows: Define PostgreSQL schemas and type-safe queries with Drizzle ORM, including CRUD operations and migrations.
  • Use Case: Build a posts API where users can sign up, authenticate, create and manage posts, upload avatars, and access published content through validated endpoints.

Quick Start

Use the supabase-node skill to design a TypeScript Express API with Supabase authentication, Drizzle schemas, protected post routes, validation, and centralized error handling.

Frequently Asked Questions about supabase-node

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

FAQPage Schema
How do I build a Node.js API with Supabase authentication and Drizzle ORM?

Build a Node.js API with Supabase authentication by structuring Express or Hono applications with middleware, configuring Supabase clients for JWT verification, and defining PostgreSQL schemas using Drizzle ORM for type-safe queries.

Can I use Supabase storage for file uploads in an Express backend?

Yes, you can implement Supabase storage uploads in an Express backend by configuring secure client connections, allowing authenticated users to upload avatars, and managing protected CRUD routes with validation.

What is the best way to handle JWT verification and user sessions in Hono?

Handle JWT verification and user sessions in Hono by applying asynchronous middleware that validates Supabase tokens, securing service-key usage, and protecting endpoints requiring active user contexts.

How do I manage PostgreSQL database migrations with Drizzle ORM in a Node service?

Manage PostgreSQL database migrations with Drizzle ORM by defining type-safe schemas, executing migration scripts, and applying centralized error handling to maintain data integrity across CRUD operations.

Do I need TypeScript to implement Supabase authentication and type-safe queries?

Yes, TypeScript is required to implement Supabase authentication and type-safe queries, ensuring environment-based secrets, asynchronous JWT verification, and secure service-key usage are properly configured.

Does this approach support centralized error handling for protected CRUD routes?

Yes, this approach supports centralized error handling for protected CRUD routes by validating endpoints, managing user sessions, and returning structured errors for Supabase and Drizzle ORM operations.